Driving The Database Engine
A blog about Microsoft SQL Server.
There are several undocumented stored procedures that many DBAs rely on to do their day to day work...
Date: 05/01/2011
SQL Diag is a very useful diagnostic tool that will help capture performance information from SQL...
Date: 04/30/2011
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...
Date: 03/01/2011
There's a new book out on PowerPivot for Excel 2010 by Sivakumar Harinath, Ron Pihlgren and Denny...
Date: 06/22/2010
This whitepaper describes five commonly-deployed architectures using SQL Server 2005 and SQL Server...
Date: 06/02/2010
After a big effort, the MSDN and Technet blog platform has been upgraded. This new platform should...
Date: 05/24/2010
this is a test, please ignore.
Date: 10/13/2009
SQL Server Reporting Services enables report developers to build and deploy reports quickly and...
Date: 10/13/2009
As many of you know, Windows 7 RTM is now available to MSDN and Technet subscribers. I've had the...
Date: 08/11/2009
These are links to material relevant to consolidating and upgrading SQL Server. SQL Server...
Date: 07/31/2009
Jimmy May and Denny Lee (along with a huge supporting cast) have published an excellent white paper...
Date: 06/04/2009
All the official Microsoft Team Blogs are now listed on BlogMS. These are blogs maintained by the...
Date: 05/14/2009
An astute member of the SQL Server community has observed the presence of SPIDs with a negative...
Date: 04/29/2009
Thanks to those of you who attended SQLSaturday and a special thanks to all the volunteers from the...
Date: 04/28/2009
One of my colleagues, Rob Carrol, has uncovered a way to use the Performance Dashboard Reports on...
Date: 04/02/2009
As a consultant working in the field, I am part of a relatively small group of people who are...
Date: 03/18/2009
Mark Pohto, one of our Microsoft IT senior system engineer's, just published an excellent technical...
Date: 03/11/2009
SQL Saturdays are events organized by local SQL user groups (mostly) that consist of a one day...
Date: 02/19/2009
A new security patch for SQL Server has been announced. You should pay close attention to this one...
Date: 02/10/2009
Creating a job to re-index all user databases in a Standard Edition instance of SQL Server 2005/2008
Here's another version of the reindex script that supports SQL Server 2005/2008 Standard and...
Date: 02/10/2009
I'm in Miami for the next couple of weeks. They issued a "sweater alert" last night because the...
Date: 01/14/2009
Creating a job to re-index all user databases in an instance of SQL Server 2005/2008 Enterprise Edition
Here is a script that will create a job to re-index each user database in an instance that is not in...
Date: 12/31/2008
Here's a function that will obfuscate a string of credit card or social security numbers. It can be...
Date: 12/26/2008
I wanted to apologize to anyone who has wondered why my blog has gone cold in the last few months....
Date: 11/26/2008
Here's a script that will check for and display any pending file rename operations. Windows stores...
Date: 08/15/2008
A utility to generate unit tests for Visual Studio Team Suite has been posted to Codeplex. This tool...
Date: 07/22/2008
The Index Physical Statistics report in SQL Management Studio is an easy way to identify fragmented...
Date: 07/02/2008
Upgrading a database from SQL Server 2000 to 2005 is not a difficult task. Microsoft provides the...
Date: 06/27/2008
The Microsoft SQL Server Performance Dashboard contains a drill-down report detailing information...
Date: 05/30/2008
It's interesting how many companies are suddenly interested in upgrading from SQL Server 2000 to...
Date: 05/05/2008
Here is an un-official but interesting article about the future of hosted database services:...
Date: 05/03/2008
Welcome to my MSDN blog. I'm privileged to be able to contribute to the MSDN community. Over time,...
Date: 05/03/2008