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...

21st March - Today is International Day for the Elimination of Racial Discrimination

 
How to Counter Intolerance, Adapted from UNESCO’s Recommendations

1. The Battle Against Intolerance Requires Law
Every Political Entity needs to reinforce Human...

SQL Server Connections in a week

I’m heading to SQL Server Connections next week, part of the DevConnections conference featuring a whole slew of technologies. Once...

Dedupe Data CTE

As a DBA working with SQL Server, some data issues arise that need to be fixed.  One such data issue is the duplication of data.  Duplicate data can happen...

Dedupe Data CTE

As a DBA working with SQL Server, some data issues arise that need to be fixed.  One such data issue...