Tag: Whats New

DATEFROMPARTS function in TSQL

SQL Server 2012 adds a new function called DateFromParts.  This new function simplifies the creating of a DATE type in TSQL over the older ways of doing it. The information here has been extracted from my SQL Saturday presentation on Whats New in

Posted in 70-461 Training, SQL 2008, SQL 2012, SQL 2014, TSQL, TSQL 2012 Tagged with: , , , , , , , ,

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 information about what the results will look like.  sp_describe_first_result_set is an alternative to sp_columns, and appears

Posted in SQL 2012, SQL Saturday, TSQL, TSQL 2012 Tagged with: , , , , , , , ,

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 that you learned something useful. Here is the slides and sample code to download: Whats

Posted in SQL 2012, SQL Saturday Tagged with: , , , ,

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 in TSQL 2012 presentation at SQL Saturday 166.

Posted in SQL 2012, SQL Saturday Tagged with: , , , , , , ,

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 16th 2012 in Redmond WA.   I am not sure why the call it Seattle

Posted in Code Camp, SQL 2012, TSQL 2012 Tagged with: , , ,