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

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

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

SQLFriends in Minneapolis

Ever wanted to hang out and talk about SQL Server over lunch?  Maybe get a chance to ask those questions...

SSIS 2012 Copy or Duplicate Environments

In SSIS 2012 there is a great new feature called environments. They can be thought of as a collection of parameters...