Static Code Analysis and SARG-ability

This morning while coding a stored procedure for a SQL Server 2012 SSDT project in Visual Studio, I noticed an interesting little blue squiggly under one of the column references in the WHERE-clause of the statement I was working on.  Curiously, I hovered the mouse over it and was pleasantly surprised to see the following […]

Robert Frost and Pie Charts

Earlier this year, Microsoft released an incredible self-service reporting and presentation tool called Power View (with SQL Server 2012).  It’s highly interactive, has excellent visualizations, and I could go on and on about the value it adds to businesses currently leveraging the Microsoft BI stack.  Instead, I’d like to point out the huge statement Microsoft  made […]