T-SQL development with SQL Server 2012
SQL Server 2012 brings a whole bag of powerful new T-SQL features 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, sub-queries, quirky updates or cursors? 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.
This session focuses on practical uses of the awesome new features in SQL Server 2012 that that allow you to improve your existing solutions.
Thursday 18 April 2013
Gather for food and drinks at 5:45 PM
Presentation starting at 6:10 PM
Our speaker is:
Dave Dustin. He's just this guy, you know?
In his spare time, Dave is a Certified Microsoft shill, SQL Server MVP and overall pretty normal bloke who'll sit down with you to help diagnose why the query plans on your mission critical application aren't running as you expected. Often for free. If you provide the beer.