Sunday, December 11, 2011
SQL Advent 2011 series of posts
I have started a series of post about upgrading your skills to 2005 and 2008 versions of your code from 2000. Below is a list of posts that are already up
Day 1: Date and time
Day 2: System tables and catalog views
Day 3: Partitioning
Day 4: Schemas
Day 5: Common Table Expressions
Day 6: Windowing functions
Day 7: Crosstab with PIVOT
Day 8: UNPIVOT
Day 9: Dynamic TOP
Day 10: Upsert by using the Merge statement
Day 11: DML statements with the OUTPUT clause
Day 2: System tables and catalog views
Day 3: Partitioning
Day 4: Schemas
Day 5: Common Table Expressions
Day 6: Windowing functions
Day 7: Crosstab with PIVOT
Day 8: UNPIVOT
Day 9: Dynamic TOP
Day 10: Upsert by using the Merge statement
Day 11: DML statements with the OUTPUT clause
Also check out the post Are you ready for SQL Server 2012 or are you still partying like it is 1999? which is the one that explains why I did this
Friday, July 15, 2011
6 new SQL Server Denali CTP3 posts
I have created 6 new SQL Server Denali CTP3 posts
A Quick look at the new IIF function in Denali CTP3
These posts are about the new things introduced in SQL Server Denali CTP3, below is a list of the posts
A Quick look at the new IIF function in Denali CTP3
Subscribe to:
Posts (Atom)