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

Blog Syndication

I got sent an email recently asking  how I went about syndicating my blog on some of the popular SQL...

Communication

It sure seems like there’s a lot of miscommunication between developers and database specialists. In fact, the communication can become...

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

Dedupe Data CTE

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

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