One of the prime-time features of Microsoft SQL Server 2008 R2 is provided by the “Project Gemini” technology known as PowerPivot for “Self Service BI”. Working with Office Excel 2010 ...

I can't seem to get anything to work My table (tbl_Promotions) has 3 columns which I'd like to create the pivot from If I create a temp table which has the 52 calendar weeks of the year ...

I was once asked what I thought Microsoft's overall product trajectory for SQL Server was, in light of Oracle's rather obvious trajectory of acquiring multiple application vendors who will, in turn, ...