SET QUOTED_IDENTIFIER

We recently received a script for a modified stored proc from a vendor.  My colleague ran the script on the...

The Moto Q and Being Proactive

I am a big fan of automating whatever I can and being proactive.  The more proactive you can be, the...

How to handle an invalid default database

My general recommendation for SQL Server service accounts and accounts that have sysadmin fixed server role membership is to default...

Midlands PASS Chapter is official

A group of us met on Thursday, December 7th, 2006, and voted to approve the bylaws and a motion to...

Jason Haley recently began posting his interesting finds again

Jason Haley used to post his Interesting Finds about every day, if not multiple times a day. The interesting finds...

Windows 2000 Resource Kit Tools Available

If you're like me and rely a lot on the resource kit tools, you may have found that it's relatively...

SysInternals Tools Updated

Several SysInternals Tools have been updated. One of the big updates was to the PSTools Suite - now you can pass...

Log Buffer #22: A Carnival of the Vanities for DBAs

Welcome to the 22nd edition of Log Buffer, a
weekly compendium of postings and news from database-related blogs across the...

Inserting missing rows

I can think of three ways to insert just the missing rows from one table or query into another table. ...

Extreme Work

"The Productivity Pro" Laura Stack posted in her blog today about jobs where long hours are the norm:

  'Extreme' jobs...