Eight Words

I remember a lot of things about that day.  It was July in Texas, which is to say, it was...

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

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

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

Patience

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

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

SQL Rally–1 week out

It’s hard to believe that after all the hard work, planning, and prep, that SQL Rally Dallas is just a...

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

Building an Intel Ivy Bridge Desktop System, Part 2

A few weeks ago, I wrote about buying some of the components that I needed to build a new 22nm...

Choosing the Right Microsoft Reporting Technology Part 6: Making the Decision

We’ve completed reviewing the major Microsoft tools and now you have to make “The Decision”.  Which tool(s) is the best...