Five months from now, Microsoft will stop supporting Windows XP. As Tim Rains points out, running Windows XP after this date will effectively be an open invitation for attack. XP will, in his words, be…
The SQL Server 2000 Duplicate Index Finder has been updated. I presented the newest version tonight at the SQLskills.com immersion event open night. Grab the scripts here. Changes include a workaround for appending RID and…
On SuperUser.com, a question came up about how to do a proper Linux backup, including the applications installed, and associated configurations. In light of a previous post I wrote about backups and run books, I…
The latest version of sp_WhoIsActive (and apparently last for SQL Server 2005/2008, according to Adam Machanic), was released a week ago. Yesterday, out of curiosity piqued by my recent three-week SQLskills training, I decided to…
Via Tim Radney, here’s a quick and easy way to increase the number of error logs from the default of six. The blog post also has a walkthrough in SQL Server Management Studio if you…