Select Favorite SQL Server 2012 Articles
The following articles are a collection of my favorite SQL Server related posts over the last 6 months. 3 Steps to Work More Efficiently in… Read More »Select Favorite SQL Server 2012 Articles
TSQL
T-SQL 2012 Procedure sp_describe_first_result_set
SQL Server 2012 adds a new stored procedure called sp_describe_first_result_set. This new procedure returns metadata for the result set returned from a query. The metadata is… Read More »T-SQL 2012 Procedure sp_describe_first_result_set
Happy Birthday SQL Server 2012
It has been a year since SQL Server 2012 released. There were some fun posts on Twitter about the SQL Server 2012 birthday or anniversary.… Read More »Happy Birthday SQL Server 2012
Sessions submitted to SQL Saturday Vancouver BC
I had so much fun at SQL Saturday in Vancouver BC last year, I have decided to go again. The sessions submitted are: The “Run… Read More »Sessions submitted to SQL Saturday Vancouver BC
Unleashing CTEs in SQL Server – Slides and Sample Code – Olympia SQL Saturday
Thanks to everyone who attended my CTE presentation at SQL Saturday in Olympia Washington today. Have a great rest of the day. As promised I have… Read More »Unleashing CTEs in SQL Server – Slides and Sample Code – Olympia SQL Saturday
Exploring the TSQL Enhancements in SQL Server 2012 – Slides and Sample Code
I just finished the Exploring the TSQL Enhancements in SQL Server 2012 presentation at SQL Saturday 166 in Olympia Washington. Thanks everyone who attended, I hope… Read More »Exploring the TSQL Enhancements in SQL Server 2012 – Slides and Sample Code
SEQUENCE Sample Code from SQL Saturday in Olympia WA
The sample code below is a quick run down of the new sequence object introduced in SQL Server 2012. Just part of my Whats New… Read More »SEQUENCE Sample Code from SQL Saturday in Olympia WA
TSQL 2012 – Generating letters with a SEQUENCE object
As shown in my previous posting on SEQUENCES, they are a user-defined object that generates a sequence of numeric values in Transact SQL 2012. But what… Read More »TSQL 2012 – Generating letters with a SEQUENCE object
Unleashing Common Table Expressions in SQL Server – Slides and Sample Code
Thanks to everyone who attended my CTE presentation at SQL Saturday in Portland Oregon today. Have a great rest of the day. As promised… Read More »Unleashing Common Table Expressions in SQL Server – Slides and Sample Code
Recursive CTE to Calculate Dates for the Last 30 Days
Have you ever needed to generate a list of dates for the last 30 days. There are lots of different ways to do this with… Read More »Recursive CTE to Calculate Dates for the Last 30 Days