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...

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. ...

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...

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...

SQL Azure – simple description, part I.

I was studying SQL Azure parameters some time ago and found out that there are no materials which tell you...

SQL Server Hardware Book News and Reviews

Today was an exciting day, since I discovered that fellow SQL Server MVP Brent Ozar (Blog|Twitter) had posted a very...

Thank you PASS Community

This has been a great week for me.  I had a lot of new faces come out for the Columbus...

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...

Bad Admins: Non-Production Servers

This is part of a series of tips on how bad/rogue admins can get access to the data in your...