2012 in Review

With the year 2012 now in the rear view mirror, and while I’m still in the midst of my holiday...

Day 1 of 31 Days of Disaster Recovery: Does DBCC Automatically Use Existing Snapshot?

Day 1 of 31 Days of Disaster Recovery: Does DBCC Automatically Use Existing Snapshot?
31 Days of Disaster Recovery
Welcome to my...

Day 3 of 31 Days of Disaster Recovery: Determining Files to Restore Database

Day 3 of 31 Days of Disaster Recovery: Determining Files to Restore Database
31 Days of Disaster Recovery
Welcome back for day...

Day 4 of 31 Days of Disaster Recovery: Back That Thang Up

Day 4 of 31 Days of Disaster Recovery: Back That Thang Up
31 Days of Disaster Recovery
Here we are at day...

Reblog: December 28 to January 3

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer...

Row of nonclustered index page

Below is the formula of calculating the row size of non-clustered index page

so unique non-clustered index created on unique clustered index use smallest...

Speaking at SQL Saturday #183 – Albuquerque

I’ve been accepted to speak at SQL Saturday #183 in Albuquerque, NM on Feb 9, 2013. This is the first...

SQL Server Contracting and Business Network Wales - LinkedIn Groups Updates

I have been doing some work on some LinkedIn groups that I manage and look after over the holidays. There...

SSRS #73 – Use Calculated Field to Dynamically Set Default for Parameters

Calculated Field has existed in Reporting Services since version 2005. SSRS 2005 did not have the most attractive user interface...

T-SQL Tuesday #38 – Standing Firm

Introduction
Welcome back for the 38th installment in the wildly popular blog party for the SQL Server community.  This is the...