I finished my draft copy of my chapter titled “Minimal Downtime and Minimal Risk SQL Server Upgrades” for the SQL Tribal Knowledge book. I am… Read More »Finished my Draft Copy of my Chapter for SQL Tribal Knowledge book
Its about time, MySQL has had a feature LIMIT which is similar to the usage of OFFSET and FETCH for years. Now in SQL Server… Read More »TSQL 2012 – OFFSET and FETCH
So far after playing around with SQL Server 2012 there are many new features to SQL. Overall I think my favorites are in the Analytic… Read More »My Top 10 TSQL Enhancements in SQL Server 2012
One of the common questions that I get asked after my Unleashing CTE Presentation is “Can we use CTEs in SSRS reports?” The answer is… Read More »Can we use CTEs use in SSRS?
For years I have heard the question of how can I do an IIF in TSQL? Honestly I never thought it would be that useful… Read More »IIF in TRANSACT SQL on SQL SERVER 2012
Over the last week I have pitched 8 presentations for SQL Connections in Vegas at the end of October 2012. Hoping that 3 of my… Read More »Working on my Presentations for SQL Connections Fall 2012
A couple years ago in my Incident Safety Officer class with the fire department we studied risk assessment for any incident that the fire department… Read More »Risk Assessment Matrix for SQL Server Upgrades
After the last post on Cumulative Distribution Function (CDF) or as it is known in TSQL CUME_DIST(), I realized that although I showed how to… Read More »Cumulative Distribution Function (CDF) – Analyzing the Roll of Dice with TSQL
Continuing on the TSQL 2012 Analytic Series now on to the CUME_DIST function SQL Server 2012 introduces another new analytic function. The Cumulative Distribution Function… Read More »More TSQL 2012 Analytics CUME_DIST – Cumulative Distribution
Like the other new Analytic functions, PERCENTILE_DISC and PERCENTILE_CONT require the use of the OVER clause. For this example I will be using almost the… Read More »More TSQL 2012 Analytics PERCENTILE_DISC and PERCENTILE_CONT