SQL Resource

By now, I am sure that you are well aware of the Resource Database.  Starting with SQL Server 2005, a new system database was made available – the Resource...

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

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

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

Statistics, row estimations and the ascending date column

SQL’s auto-updating statistics go a fair way to making SQL Server a self-tuning database engine and in many cases they...

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

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