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

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

OFFSET and FETCH Query Options in SQL Server 2012

If you are tired of implementing query paging solution in old classic style than try query hints OFFSET & FETCH newly introduced in SQL Server 2012. You might have...