SQL Server – Row count for all views / tables

Getting row count for all tables in a database is straight forward. You can display row count for all tables...

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

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