SQL Iterators – Making the life of the DBA that much easier

There are several undocumented stored procedures that many DBAs rely on to do their day to day work – namely spMSForEachDatabase and spMSForEachTable. This project is a SQL-CLR assembly that provides equivalent functionality to those two stored procedures. These stored procedures support pre and post commands, as well as up to three commands to be…

0

SQL Diag Configuration Tool released on Codeplex

SQL Diag is a very useful diagnostic tool that will help capture performance information from SQL Server. This tool is shipped with the SQL Server product. Howerver there is not an easy way to configure the tool – it requires the hand editing of an XML file, which is tedious and error prone. That is…

0

The Microsoft Data Warehouse Toolkit, 2nd Edition: With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset published

The updated version of this essential Business Intelligence book has been published. If you don’t have it, get it. If you have the SQL Server 2005 version, it’s time to upgrade. From the Kimball Group web site: “Joy Mundy and Warren Thornthwaite co-authored this guide to building a successful business intelligence system and its underlying…

1