SQL Server Training in London this Christmas

If you are thinking of upgrading to SQL Server 2012 in the near future then why not join me in...

SSAS – Setting Attributes as Properties for Excel

When a user is browsing your cube with excel they may not understand how to slice the data and end...

Undocumented functionality in FORMATMESSAGE

I was reading a rather interesting post on stackexchange “Why is % a forbidden char in a THROW message?” (which is...

MDX Order by Multiple Criteria

The MDX language includes an ORDER function that orders members of a set in ascending or descending order based on a numeric (or string) expression.  The syntax of the...

MDX Order by Multiple Criteria

The MDX language includes an ORDER function that orders members of a set in ascending or descending order based on...

MDX Order by Multiple Criteria

The MDX language includes an ORDER function that orders members of a set in ascending or descending order based on a numeric (or string) expression.  The syntax of the...

Gotcha!!! Trying to install SQL Server 2012 on Windows 8.1 Professional

OK, after several tranquillizers and much grey hair, I found out why SQL Server 2012 will NOT install on Windows...

My First Windows Update Gone Bad

I don’t think I’ve ever had a Windows Update go bad - until this week.
I recently upgraded to Office 2013 and late Monday afternoon, decided to check in with...

A Rickety Stairway to SQL Server Data Mining, Part 14.6: Custom Mining Functions

by Steve Bolton

…………In the last installment of this amateur series of mistutorials on SQL Server Data Mining (SSDM), I explained how to...

Decrypting Stored Procedures Thanksgiving Special:Quick Tips

Update: Thanks for your response Jon Gurgul! I have updated the files to reflect your updates. It's faster and cleaner...