MORE ABOUT ME

SQL Server Performance

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

db-mirror-meme
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: http://msdn.microsoft.com/en-us/library/ms189852.aspxAnd if you are thinking of buying yourself a nice book on Christmas on database mirroring, I'd recommend this one: Pro SQL...

5-DBA-Food-Groups
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...

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