Awesome new T-SQL candy in SQL Server 2012 with Mladen Prajdić

Platinum Sponsor

Home

Travel & Accommodation

SQLBits Query across the mersey

SQLBits Beside the seaside

SQLBits 7 Wonders of SQL

SQLBits The 6th Sets (VI)

SQLBits goes West (V)

SQLBits goes Forth (IV)

Premium Sponsor

Gold Sponsors

Silver Sponsors

Bronze Sponsors

It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript, click here for a page that doesn't require javascript.

Awesome new T-SQL candy in SQL Server 2012

SQL Server 2012 brings a whole bag of new features. We'll focus on the awesome new stuff that will make your T-SQL development a breeze.
How did you do your paging so far? Got mad at the lack of proper support? Not any longer! Now there's OFFSET to help you with that
Remember when you had to do those running totals with CLR, subqueries, quirky updates or (GASP!) cursors?No more! Enter the new WINDOWING FUNCTIONS that offer a simple solution to that problem and a bunch of new possibilities.
Ever had identity problems? Let me show you the power of new SEQUENCES!
But wait, there's more! We'll even take a look at the upgraded ERROR HANDLING, new FORMATTING and CONVERTING functions, awesome METADATA DISCOVERY and more.

Presented by Mladen Prajdić at SQLBits X

Downloads

Slide Deck 892 KB

Demo Code 6 KB
SpeakerBIO

Mladen Prajdić

Mladen Prajdić is a SQL Server MVP from Slovenia and a C# and SQL Server developer for over 10 years. He blogs at http://weblogs.sqlteam.com/mladenp. He develops a popular free add-in for SSMS, called SSMS Tools Pack (http://www.ssmstoolspack.com/).
Video

The video is not available to view online.

Session Files Explorer

Awesome_new_T-SQL_candy_in_SQL_Server_2012

Could not find a part of the path '\\sqlbits01\DENALI\SQLBitsFiles\'.