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

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

Fast Track Data Warehouse Reference Guide for SQL Server 2012

I have previously blogged about Fast Track Data Warehouse, a reference configuration optimized for data warehousing (see Microsoft SQL Server Reference...

Denali – Day 2: AlwaysON High Availability (aka Project HADRON)

Denali – Day 2: AlwaysON High Availability (aka Project HADRON )

AlwaysON Availability Group:

is another very important achievement done by development team project...