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

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

Default database

What?

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

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

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

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

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

Notes on Presenting

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

Running Powershell scripts remotely.

I’ve only recently started to play with Powershell (PoSH) but even I’ve begun to discover what a huge number of...