TSQL 2012

Home after Seattle (Redmond) Code Camp 2012

by SteveStedman
June 16, 2012June 16, 2012
Analytic TSQL, Classes, Code Camp, CTE, TSQL 2012

What a great day at Code Camp today. Click here to download the slides and sample code from the presentations. The first presentation that I… Read More »Home after Seattle (Redmond) Code Camp 2012

Code Camp in Redmond Today

by SteveStedman
June 16, 2012April 5, 2013
Analytic TSQL, Classes, Code Camp, CTE, TSQL 2012

I am headed to Code Camp in Redmond WA today. I ended up with 3 sessions that I will be presenting, and I am really looking forward… Read More »Code Camp in Redmond Today

TSQL 2012 CHOOSE Function

by SteveStedman
June 8, 2012June 8, 2012
Code Camp, SQL 2012, TSQL 2012

In SQL Server 2012 there is a new function called CHOOSE that takes in an offset, and a list of options. Choose is a function… Read More »TSQL 2012 CHOOSE Function

Sessions Submitted for SQL Saturday – Olympia

by SteveStedman
June 8, 2012
Code Camp, CTE, SQL 2012, SQL Saturday, TSQL 2012

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

Sessions for Code Camp in 2 weeks

by SteveStedman
June 3, 2012June 3, 2012
Analytic TSQL, Code Camp, CTE, SQL 2012, TSQL 2012

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

by SteveStedman
April 4, 2012July 28, 2015
CTE, SQL 2012, TSQL 2012

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

by SteveStedman
April 4, 2012April 4, 2013
SQL 2012, TSQL 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

by SteveStedman
April 3, 2012April 3, 2012
TSQL 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

by SteveStedman
March 30, 2012March 30, 2012
58 Comments
Analytic TSQL, SQL 2012, TSQL 2012

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