MCM Road Less Traveled

I began this post back in October of 2012 after learning that I had passed the SQL Server 2008 MCM Knowledge exam.  I had set it aside in hopes...

Necromancing the Chicken

First off, I’m sorry this space has been dead for so long. I’m sure I’ve dropped off many an RSS...

SQL Server – Generate Calendar using TSQL

Introduction
Recently, I was asked to develop a SSRS based report for the Event Management module in MS Dynamics CRM 2011....

SQL Server : Index at a glance

In the last ten posts, we have discussed in details about the SQL server index and its storage structure. In...

SQL Server 2012 Diagnostic Information Queries (April 2013)

Here is the April 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...

SQL Server Management Data Warehouse (MDW) – Why it Rocks

Ensuring excellent performance for users and customers is a high priority for Database Administrators.

Here I share a free and easy way for you to get valuable insight into the...

SQL Server Management Data Warehouse (MDW) – Why it Rocks

Ensuring excellent performance for users and customers is a high priority for Database Administrators.
Today I want to share a free and easy...

The Bucket List – Item #1 is (finally) finished

We all have a bucket list – that list of things that we want to accomplish before one, well, kicks the...

Calculating the length of a string (Len vs DataLength)

This one is basic but still something that can catch you unawares if you aren’t careful. Most DBAs and developers...

Customizing SSMS–Results

This is a short series on some customizations in SSMS to make it visually more appealing.
As a presenter, I’ve learned...