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…


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…


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…


New book on PowerPivot for Excel 2010 published

There’s a new book out on PowerPivot for Excel 2010 by Sivakumar Harinath, Ron Pihlgren and Denny Guang-Yeu Lee. It covers PowerPivot end-to-end including Sharepoint 2010. It’s published by Wrox and available at many retailers. Professional Microsoft PowerPivot for Excel and SharePoint 


New SQL Server 2008 R2 High Availability Whitepaper Published

This whitepaper describes five commonly-deployed architectures using SQL Server 2005 and SQL Server 2008 R2 that are designed to meet the high-availability and disaster recovery requirements of enterprise applications. The whitepaper describes the architectures and also presents case studies that illustrate how real-life customers have deployed these architectures to meet their business requirements. This whitepaper is…


The upgrade is done…

After a big effort, the MSDN and Technet blog platform has been upgraded. This new platform should provide a lot of new funcationality. I’ve been waiting for this to pass before posting any new content. But now it’s time to get back to work and post.


Test page

this is a test, please ignore.


Troubleshooting Reporting Services at the Client Tier with Fiddler

SQL Server Reporting Services enables report developers to build and deploy reports quickly and without having to write complicated code. But this abstraction can come at a price. In general, most report developers either have no experience developing web applications or understand the behind the scenes mechanics of a web-based application like SSRS. Trouble-shooting slow…


The Connected Show: Paul Thurrott on Windows Server 2008 R2

In this episode, guest Paul Thurrott joins Dmitry and Peter to discuss Windows Server 2008 R2 and Virtualization. Also Peter and Dmitry discuss the news about Codeplex.org, an open source software foundation created by Microsoft. The Connected Show Episode 16   Get Connected With the Connected Show Online   Follow us on Twitter, Become a Fan on…


This blog now available in 15 languages using Windows Live Translator

If you can read one of the fifteen languages supported by the Windows Live Translator, you can now view this blog in one of those languages. Simply click on the dropdown at the top of this web page to select the language. A new browser window will open and display both the English and translated pages…