SQLRally Can’t Miss Events

Things have been quiet around here lately and I have a one word explanation….SQLRally.  There’s work and family and several...

Denali — Day 5: Column-store indexes (aka Project Apollo)

Denali – Day 5: Column-store indexes (aka Project Apollo)

 
There is another great achievement for Denali, especially for Data warehouse, where data...

It was time for an upgrade

I am not one of these anti PC sorta guys, but I do love my MacBook Pro.  I have owned...

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