Tech Ed 2012 – A 20th Anniversary Celebration. Wish you were here!

Tech Ed has been wonderful this year, a chance to meet up with old friends, make new old friends and talk about SQL Server. My session DBI410 – SQL Power Tools: Enhance Your Effectiveness with Extended Events was well attended with much interest and great questions. Thanks to those of you who attended. Please be…

1

The holidays are over – back to work!

I plan on releasing the next installment of The Extended Events series on Monday so watch for that. I finished up my work as the technical reviewer on William Stanek’s book Microsoft SQL Server 2012 Pocket Consultant – the ISBN is 978-0-7356-6376-3 which will be released at the end of February.  

1

The Tool Man brings you Power Tools…

Starting on December 1st 2011, I will be publishing a series of blog posts that are deep dives into the ‘Power Tools’ that ship with SQL Server 2012. The first series will focus on Extended Events (XEvents) which allows the DBA to perform tasks, troubleshoot problems, and understand the internal workings of SQL Server like…

0

SQL Iterators: Making the Life of a SQL Server DBA That Much Easier

       Share Many Microsoft SQL Server DBAs automate as many of their day to day processes as possible, freeing them to attend to higher impact activities. To do so, many DBAs leveraged two undocumented system stored procedures, namely sp_MSForEachDatabase and sp_MSForEachTable. The upside of using these stored procedures are tremendous. For example, in a…

0