Indexes – Understanding basic types and their components

The biggest problem developers and newer DBAs have with understanding indexes is that you don’t realize when you’re using the...

Software Design and Schizophrenic Windows 8 Part 2

I know it’s not schizophrenic, but that sounds better. It’s really a split personality.
I wrote recently about Windows 8 and...

Windows, RIP (1992 – 2013)

Today is a very sad day for me. My love, my dear Windows has passed away. We were together for...

Certifiable?

I have recently begun to contemplate pursuing the MCSA Certification.  I have been working with SQL Server for almost 20...

SQLSaturday #220 Atlanta

From the tweets, it looks like there will be about 800 attendees sitting in on 11 different tracks with 5...

Indexes – Unused and Duplicates

Indexes aren’t free, and many databases end up with unused indexes. Every time you make any update to a table...

SQLSaturday Redmond(SQLSat212) is almost here…Will you be there?

This is my first SQLSaturday and I’m super excited to attend this event.

SQLSaturday’s are always a great opportunity to learn something exciting,...

Virtualization Networking Tips for SQL Server 2012 AlwaysOn

A while back Kendal Van Dyke (b | l | t) asked me a great question regarding the ideal VMware vSphere networking...

Parameterizing an Excel Spreadsheet

I’ve had a few discussions in the past week about not only including Excel spreadsheets on PerformancePoint dashboards, but specifically...

When the person you hire is not the person you hire

This is something I just heard about recently, but then experienced it for myself.
This story was told to me: A...