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

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