My first blog post!

I’ve started my own SQL blog. Hopefully I’ll write some interesting SQL blog posts here soon.

View execution plan for a sproc in the wild

Got stored procedure problems?  I feel sorry for you son.

Here's a quick query to pull the cached execution plan out...

Open_transaction_count in sys.dm_exec_sessions

This news may be a few months old, but it is worth noting that there is now a column called...

Factless fact table

A factless fact table is a fact table that does not have any measures.  It is essentially an intersection of...

Re-blog – December 9 – December 15

Welcome to the Friday Re-Blog summary post.  The aim of these posts is to bring some old posts that newer readers may...

Why Am I Amazed By a 2000 Page Word Doc?

It’s not uncommon to have information shared in a Word doc, but I was surprised recently to open one up...

The ‘Microsoft.Ace.OLEDB.12.0' Provider Is Not Registered on the Local Machine

If you have used SSIS to move data from something like Access or more commonly Excel, it is a good...

Counting Merge Replication Article Changes

One of the cool things about Merge Replication is that it has the capability of revealing very interesting information regarding...

Why did I start blogging?

This post is in response to #meme15 started by Jason Strate (b|t). Two questions were asked in the first assignment....

PASS Summit 2011 Session Evaluations

Session evaluations from the 2011 PASS Summit have been entered, calculated, and officially released to speakers. While I didn't make...