Dynamic Management Quickie: Exploring SQL Server’s system views and functions as you work

There’s a lot of dynamic management and system objects to keep track of in SQL Server.
We all sometimes have the...

What Are Your Indexing Strategies?

A couple weeks ago, I got some pretty great new.  The book proposal that I had submitted to Apress was...

SQL Server 2008 SP2 Cumulative Update 3

Microsoft has released SQL Server 2008 SP2 Cumulative Update 3, which is Build 10.00.4279.00. I count 25 fixes listed in...

SQL Server 2008 SP1 Cumulative Update 13

Microsoft has released  SQL Server 2008 SP1 Cumulative Update 13, which is Build 10.00.2816.00. I count twelve fixes listed in...

SQL Server 2005 SP4 Cumulative Update 3

Microsoft has released SQL Server 2005 SP4 Cumulative Update 3, which is Build 9.0.5266. There are only five fixes listed...

SQL Server 2005 SP3 Cumulative Update #15

Microsoft has released SQL Server 2005 SP3 Cumulative Update 15, which is Build 9.0.4325. There are only six fixes included...

SSAS - Measures or Attributes in Multiple Display Folders

I had a client recently show me a neat little tip that I thought I would share.In the cube he...

SSAS errors: Errors in the metadata manager. The dimension with ID of ‘xxx’ referenced by the ‘yyy’ cube, does not exist.

When deploying or processing a cube or dimension you may encounter an error similar to this:

Errors in the metadata manager. The...

Database Mail – Collection of SQL Server Scripts

As part of my blogging I’ll be periodically providing readers with a collection of my scripts which I use on...

SSIS Foreach File Enumerator returns more files than expected by appending a wildcard (*) to the file mask

While working on a recent project for a customer that involved importing both Excel 97-2003 and Excel 2007/2010 files, I was...