(Arshad Ali) Power View is a new tool for intuitive ad hoc SQL Server reporting which provides an interactive data exploration, visualization, and presentation experience to the business users. But how do you create these Power View reports? Check out this tip to learn more.
Author: SSWUG Research
Full calendar – A complete web diary system for jQuery and C# MVC
(AJSON) This article describes using the very fine open source JQuery plugin “FullCalendar” by Adam Shaw to develop an appointment booking system. I will demonstrate numerous ways to use the plugin and show how it can integrate with an SQL Backend with Entity-Framework.
When to use SELECT * in PostgreSQL
(Chris Travers) In LedgerSMB we use a lot of queries which involve SELECT *. Many people consider SELECT * harmful but there are several cases where it is useful. Keep in mind we encapsulate the database behind an API, so SELECT * has different implications than it does from applications selectin
Big Data Analytics with IBM Cognos BI Dynamic Query
(Jason Tavoularis and Marcela Adan) IBM Cognos Business Intelligence (BI) helps you make better and smarter business decisions faster. Advanced visualization capabilities bring your data to life, and you can consume your Cognos BI reports, scorecards, and dashboards through Internet browsers and mob
Oracle 12c & PHP
(Michael McLaughlin) This answers “How you connect PHP programs to an Oracle 12c multitenant database. This shows you how to connect your PHP programs to a user-defined Container Database (CDB) and Pluggable Database (PDB). It presupposes you know how to provision a PDB, and configure your Oracle li
Moving Objects to Shrink Data Files
(mdinh) At a company I used to work for, I would frequently get asked, “There’s 200 GB free in the tablespace. Why can’t you just shrink it?”
Heat Maps – 12c Edition
(Bobby Curtis) Over the last few months, I’ve been slowly playing with Oracle Database 12c and various features within it. One such feature has been the heat maps. I was curious about heat maps during beta testing but didn’t have a chance to test it while there.
How DB2 10.5 with BLU Acceleration Speeds the Analysis for Cognos Users
(Chris Eaton) I’ve written about DB2 10.5 BLU Acceleration already (and lots more to come) but I wanted to write about a combined solution that IBM is now calling “Fast on Fast”. As mentioned in my previous blog, BLU Acceleration can make analytic queries run significantly faster by using dynamic in
A Chat With David Amerland: Opening Up SEO In The Age Of Semantic Search
(Jennifer Zaino) Marketers, SEO experts and businesses not yet on-board with retooling their approaches to the new world of semantic technology and semantic search need to seriously rethink their positions.
Limitation with YEAR() function in SSIS
(Bob Pearson) I learned something new today while researching an ETL failure: