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

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

PASS Election Results

The 2011 Election results were just posted, congratulations to Adam Jorgensen, Denise McInerney, and Rob Farley for taking the top...

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

Retrieving position() value of node by using XQuery alone

You can only use the position() function within an xquery predicate and can't use it to return the position value...

My Top 5 for 2011

I have seen a few recap posts bouncing around the net and started thinking about my own blog.  So out of curiosity, I decided to take a look at...

My Top 5 for 2011

I have seen a few recap posts bouncing around the net and started thinking about my own blog.  So out...

Learn SQL 2012

Microsoft is working on the next round of certification exams for SQL Server 2012. So now is the best time...

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

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