New Years Resolutions for 2009
I’ve been tagged by Denis Gobo for a New Years Resolution post. I’ve only got a couple of things to put, since I’m not a big fan of New Years resolutions. Upgrade our production systems to SQL Server 2008 I’ve been speaking about SQL Server 2008 since before it was released. It would probably be […]
Managing Multiple Databases on a Single Server
Back in November I wrote an article for Enterprise IT Planet entitled “Managing Multiple Databases on a Single Server” in which I go over the potential problems you can face when consolidating instances of SQL Server. Denny
Order To Restore Database Backups In
I’m often asked (both online and offline) once you have all your database backups, in what order to they need to be restored in? I’ve actually asked this very question to senior level DBAs as an interview question before, and gotten some very interesting answers. When restoring your database you start with your full backup, […]
What should I do when my Windows Admin wants to put an anti-virus on the SQL Servers?
My answer to that one is pretty easy. Let him / her. I’m a firm believer that every machine on the network should have anti-virus software installed. Most anti-virus software is pretty lightweight (especially compared to the amount of hardware that your SQL Server has), and if a virus did get onto the SQL Server the results could be awful.