SQL Server 2012 – Transact-SQL Enhancements – Learning Resources


Last week I delivered a session on T-SQL Enhancements in SQL Server 2012 (code-named “Denali”). 40+ people attended the session and the response was awesome. One of the asks during the session was to share some links and references on the new and enhanced features. Hence I thought of putting together links to some of the best resources that I have found so far on the web.

Here is a list of New and Enhanced Transact-SQL Enhancements in SQL Server 2012.

New Features

OFFSET AND FETCH

SEQUENCES

WITH RESULT SETS

THROW Statement

FORCESCAN

Functions

Conversion Functions

PARSE

TRY_PARSE

TRY_CONVERT

Date and Time Functions

Logical Functions

CHOOSE

IIF

CHOOSE and IIF Logical Functions:

String Functions

CONCAT

FORMAT

CONCAT and FORMAT String Functions:

Analytical Functions

Enhanced Features

OVER Clause

FORCESEEK

In addition to the links to various articles/blogs, here are few additional resources – Virtual Labs and Videos.

Virtual Labs

Videos

E-Book (Free)

That is all for now. Hope you find this article useful. Please do share your feedback.

If you find any other articles, which you think can be a good addition to the above list, please share the link in the comments section below and I will add it to this article. Until we meet next time, happy learning 🙂

About Dattatrey Sindol (Datta)

Datta is a Microsoft BI Enthusiast, passionate developer, and a blogger. View Full Profile

Posted on July 30, 2012, in Books, Learning Resources, SQL Server, SQL Server 2012, T-SQL, Tech Videos and tagged , , , , , , , . Bookmark the permalink. 1 Comment.

What are your thoughts?

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: