DQS Domain Validation Rules

A compelling feature of the new Data Quality Services in SQL Server 2012 is the ability to apply rules to...

DQS Domain Validation Rules

A compelling feature of the new Data Quality Services in SQL Server 2012 is the ability to apply rules to...

SQL Server 2005 Diagnostic Information Queries (May 2012)

Even though SQL Server 2005 fell out of Mainstream Support back in April of 2011, I know many people are...

SQL Saturday Houston Recap

Last month I made the trip with some other Dallas-area speakers down to Houston’s second annual SQL Saturday event.  This...

Win a Free SQLRally Admission!

As those of you in our local North Texas SQL Server User Group are aware, we have given away one...

Patience

Update: This is confirmed by Snopes.
A NYC Taxi driver wrote:
I arrived at the address and honked the horn. After waiting...

Content is King: Great (paraphrased) advice from TheOatmeal.com

TheOatmeal.com has provided the absolute best counsel regarding creativity vs marketing. The comic I’m talking about is entitled “How to get...

Changing Priorities

If you’ve been following this blog for a while, you have probably noticed that the content here has been a...

On the road less traveled: a DBA Roadmap review

The story of why I came up with this blog is no secret to the few readers I have here. In...

Slowing Changing Dimension (SCD) demystified – Part 1

SCD is a basically a concept that explains how historical data/values are stored within a data in a database.

There are...