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.
VMware 3.5 won’t start any VMs if the Licensing server is down
So tonight I finely got around to patching the fourth VMware ESX 3.0.2 server to 3.5 Update 3. The other 3 servers went just fine, quick reboot when done and back up and running in no time. So experience said that the fourth one would be no problem…
sp_replwritetovarbin Heap Overflow Code Exploit Code In The Wild, Works By Using Our Good Friend SQL Injection
For those living under a rock there is a new SQL exploit in the wild. Dennis did an excellent write up of it already so I’ll refer you do <. for his entry and save myself the time of writing what has already been written. Denny