Can You Dig It? – Determining Index Plan Usage

She Can Dig It!
A while back I was asked, if you can use the plan cache to determine which plans...

Living a Dream

It was a little over a year ago that I stood on stage at the Rocky Mountain Tech Trifecta and...

Slowing Changing Dimension (SCD) demystified – Part 2

In Part 1 of this series, we looked at SCD Type I. We would now look at the SCD Type...

Denali – Day 4: Editions & Licensing

Denali – Day 4: Editions & Licensing

Editions:

Here is a brief edition summary of Editions available for all sql server from 2005 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...

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