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

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

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

Identity Crisis

I’m sure most people have identity values lurking somewhere in their databases.  In fact I would guess that most people...

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

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

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

SQLFriends in Minneapolis

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

Automatic page repair with SQL Server Mirroring

Now and then my colleagues and I find our selves in the middle of a discussion about SQL Server Mirroring...