SQL Server Performance

Changing Default Database File Locations in SQL Server

When you create a database in SQL Server and do not specify a file location for your data and log files SQL Server will rely on the default database file locations as defined in the server properties. You can see these properties for yourself by...

Doing it Wrong: Database Mirroring

Just a quick post for some Friday fun.If you want to know how to do database mirroring right, start with this MSDN link: if you are thinking of buying yourself a nice book on Christmas on database mirroring, I'd recommend this one: Pro SQL...

The Five DBA Food Groups

Tomorrow is Thanksgiving here in the USA. It's a day where we are supposed to be thankful for what we have been given and instead we mostly use it as an excuse to eat obscene amounts of food, watch 10 hours of NFL action, and force...

HOW TO: Find Currently Running Long SQL Agent Jobs

A while ago I had posted a script to help find jobs that were currently running longer than expected. Since I've been sharing some scripts recently, I decided to verify that this script still works for finding long running jobs in SQL Agent for SQL Server...