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

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

Presenting at SQL Saturday 119 Chicago!

First thing in the morning Saturday May 19th:

I will be presenting with my colleague from House of Brick David Klee...

One Week from SQLRally!

SQLRally is a week away (pre-cons start on Tuesday, conference starts on Thursday). I have the privilege of two sessions to...

SQL Server Indexed Views Explained

Indexed views are a really powerful and possibly underused feature of SQL Server. It’s basically a way of writing a...