Ars Technica

SQL Server PIVOT (with calendar weeks)

This has been driving me crazy. Can anyone help me understand how I can dynamically create a sort of calendar view for a promotional schedule? I can't seem to get anything to work My table ...
Network World

PowerPivot with SQL Server 2008 R2

PowerPivot with SQL Server 2008 R2 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 ...
Ars Technica

SQL Server 2005: Pivot Help

I have a SQL Script that produces the following pivot query:<BR><BR> <pre class="ip-ubbcode-code-pre">SELECT ClientID, FirstName, LastName, SSN, 05/01/2009],[05/02 ...
dbta

Microsoft’s Trajectory for SQL Server Becomes Clear with PowerPivot

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, ...
Cloud Computing

Microsoft server platforms pivot to cloud-first development

The overriding themes of Microsoft’s latest server platform announcements delivered last week at the company’s annual TechEd conference were about design for the cloud. Announcements for Microsoft ...
Visual Studio Magazine

Returning JSON from SQL Server Queries

With JSON now the default format for moving data between clients and servers, SQL Server adds JSON support to make it easier to get your data out of the database and down to the client. SQL Server ...