SQL Server 2012 (“Denali”): Master Data Services

SQL Server Master Data Services (MDS) has a number of enhancements in SQL Server 2012:
Improved web user interface – If you...

What’s new in SQL Server RC0 setup

Datacentre Edition is no longer available as a MS SQL Server 2012 RC0 candidate, Read MoreMS SQL Server 2012 RC0...

Wrapping Up 2011 and a Blog Break

I’m writing this on December 17th, thinking back on 2011, and it has been a good year. Not always simple...

In 2012, It’s Me and Vanilla Ice

Like many others, I’m planning a few changes for my life for next year.  I’m a believer in finding one’s...

PASS Update #69 (The Wrap Up)

Next week marks the end of my third and final year serving on the PASS Board of Directors. I’ve struggled...

SQL Server 2012 Diagnostic Information Queries (December 2011)

Since the final RTM release of SQL Server is getting ever closer, I thought it was a good time to...

SSAS – Display Folders

Display folders are an often used tool in Analysis Services to help end users navigate through a cube or dimension...

Why doesn’t my gauge show correct values?

Here is an issue I encountered recently while using gauge in reporting services.

There are three gauges in the report one...

Backing up the Service Master Key

Making a backup of your Service Master Key (SMK) should be one of the first things that you do if...

Modifying SQL Server Synonyms – this time with Powershell

So, how do you recover from the Holidays? Hot Cocoa by the fire? Relaxing evening with your spouse watching an...