Clean up all (most) of the orphans on an instance

Recently we have been doing a number of instance moves as part of a large upgrade project. And as anyone...

Yet one more quick and easy performance tuning setting

I blogged in the past about two simple commands that can be a big help in performance tuning SET STATISTICS...

Multiple Windows Groups with different default databases

A question came up at work the other day, mostly as a mind game, but you never know it might...

Default database

What?

The default database is one of the options when creating a login in SQL Server. This is the initial database...

Adding new users & groups in windows

I do a lot of testing with security in SQL Server. And of course to do a thorough job of...

Extending your metadata with Extended Properties

Ever wanted to put a comment on a table? Or maybe even a column? How about an expiration date on...

Test first; Mileage may vary;

I went to a SQL Saturday recently and saw a number of great sessions. If you haven’t been to a...

TSQL Tuesday #66: Monitoring

If a user is going to call me about problem, I’d much rather know about it ahead of time. In...

Notes on Presenting

As you may know I’m preparing to write my first presentation. I have a great abstract and an outline of...

Building a job to monitor other jobs

The other day Tom Roush (b/t) and Tim Radney (b/t) were having a discussion on twitter about using scheduled windows...