Modified Insert Unknown Row to Dimension Table

A little over a year ago Patrick LeBlanc wrote a blog post about inserting an unknown row into a dimension. ...

Roundup for Un-SQL Friday #005: Bad Interviews

It’s time for the Un-SQL Friday #005 roundup!

From managers…
First up, The Lone DBA admits that he wasn’t always (ahem) one of us…he’s got...

Re-blog – July 22-July 28

As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week.  Some posts...

Calling SCOM in C#

Written by David Postlethwaite
I’m sure there are many out there using System Centre Operations Manager (or SCOM for short)...

Marking FK Constraints NOT FOR REPLICATION

When administering Merge Replication, sometimes we need to mark foreign
key constraints NOT FOR REPLICATION.  In some cases, we might...

Build a schedule for SQL Saturday

A new feature has been added to SQL Saturday.  Now when you register for an event you can build your...

Activity Monitor and Profiler

Today I came across a link to a neat little script for SQL 2005 / 2008 to help derive the head blocker in a blocking chain.  That script can...

Activity Monitor and Profiler

Today I came across a link to a neat little script for SQL 2005 / 2008 to help derive the head...

T-SQL refactoring

Keeping your SQL objects’ naming rules during furious development is hard. New levels of information are added continuously, entities are...

How to move Cluster MSDTC Drive

I recently had the need to move the MSDTC for a cluster to a new SAN drive.  It’s a quite simple...