I previously wrote about SQL Server 2012 certification in March and at the time of writing the post, the information on the Microsoft website about the SQL Server certification paths that you could take spoke of "Professional Level Certifications". I also wrote that there did not appear to be a comparative MCTS to MCITP achievement path and that in order to be qualified, you … [Read more...] about SQL Server 2012 certification – part 2
sql server 2012
Microsoft has decided in SQL Server 2012, that they will modify the ORDER BY clause and do what MySQL has been doing for a long time - providing simple functions for paging result sets. This comes in the form of OFFSET and FETCH. Now, I'm not saying that this was previously not possible in SQL Server. There are solutions to this problem in other versions of the product in … [Read more...] about New T-SQL features in SQL Server 2012 – OFFSET and FETCH
I've just downloaded a free ebook on SQL Server 2012. Introducing Microsoft SQL Server 2012, by Ross Mistry (@RossMistry) and Stacia Misner (@StaciaMisner) It's 229 pages long and so provides a good amount of content with 10 chapters. If you have read my previous post on SQL Server 2012 certification and you are going for the certification or if you simply want to learn … [Read more...] about Get a SQL Server 2012 ebook for free!
So SQL Server 2012 has gone RTM and I am considering studying for a SQL Server 2012 certification. At the time of writing this post, the exams are not yet available but are due in June 2012 with the beta exams happening in March 2012. For this release, in order to attain a SQL Server 2012 certification you must pass five exams but if you are already SQL Server 2008 MCITP … [Read more...] about SQL Server 2012 certification
Continuing on from new T-SQL features of SQL Server 2012, I wanted to explain about the new CREATE SEQUENCE feature. What is CREATE SEQUENCE for? A common feature in table design is to place an auto incrementing number on a field in the form of an IDENTITY column. So this is an easy way of maintaining a sequential number on a table. What if you wanted to create a database … [Read more...] about New T-SQL features in SQL Server 2012 – CREATE SEQUENCE