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
New T-SQL features in SQL Server 2012 – OFFSET and FETCH
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
Get a SQL Server 2012 ebook for free!
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!
SQL Server 2012 certification
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
Keeping fit could improve your performance as a DBA
It is not uncommon for a DBA to work long hours. In addition to the 9-5 standard, there will requirements to stay later after work to meet deadlines or because there is a problem with a production server that requires your attention. 50-60 hour weeks can become the norm and there may also be an on-call system in place which you may be part of. There is a lot of pressure … [Read more...] about Keeping fit could improve your performance as a DBA