Sessions Submitted for SQL Saturday – Olympia
SQL Saturday 166 in Olympia WA on November 10th was announced, and that one is close enough to drive to. I have submitted 2 sessions… Read More »Sessions Submitted for SQL Saturday – Olympia
TSQL
Sessions for Code Camp in 2 weeks
Here are the sessions that I will be presenting at Code Camp in two weeks.. What’s New in TSQL 2012 This is the first time… Read More »Sessions for Code Camp in 2 weeks
Sessions Accepted for Seattle Code Camp 2012
I learned today that several of the sessions that I pitched for Code Camp 2012 have been accepted. Code Camp will be on Saturday June… Read More »Sessions Accepted for Seattle Code Camp 2012
TSQL 2012 – OFFSET and FETCH
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
My Top 10 TSQL Enhancements in SQL Server 2012
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
IIF in TRANSACT SQL on SQL SERVER 2012
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
Cumulative Distribution Function (CDF) – Analyzing the Roll of Dice with TSQL
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
More TSQL 2012 Analytics CUME_DIST – Cumulative Distribution
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
More TSQL 2012 Analytics PERCENTILE_DISC and PERCENTILE_CONT
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
Using the OUTPUT Clause in TSQL for Auditing
The OUTPUT clause is often times underappreciated by the TSQL programmer. There are many really interesting things that you can do with the OUTPUT clause,… Read More »Using the OUTPUT Clause in TSQL for Auditing