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

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

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

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

SQLRally at Starbucks Networking Event

Craig Purnell and I are hosting an informal networking event at SQLRally this year on Friday May 11th from 7-8:30...

Changing Priorities

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

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

Denali – Day 3: Hardware & Software requirements and Installation, Upgrade / Migration

Denali – Day 3: Hardware & Software requirements and Installation, Upgrade / Migration

 
I know this should be first or second blog post when...