How and Why to Enable Instant File Initialization

See my new blog post (written with Denzil Ribeiro) about “How and Why to Enable Instant File Initialization” on our PFE blog. Keep an eye on the PFE blog for more posts from my team in the near future.  


Professional SQL Server 2008 Internals and Troubleshooting

Our new book, Professional SQL Server 2008 Internals and Troubleshooting, will be shipping soon! Order now! 🙂 Christian Bolton, Justin Langford, Brent Ozar, and James Rowland-Jones have each written several chapters in this book. Steven Wort, Jonathan Kehayias and I each contributed a chapter as well. The 1st half of the book introduces you to how things…


Latest SQL Server 2005 Cumulative Updates – SP2 based CU17, SP3 based CU7

There are two new cumulative updates (CUs) available for SQL Server 2005 as of today. ·         SQL Server 2005 SP2 based CU17 (9.00.3356). This is the last SP2 based CU as SP2 will no longer be supported after 1/12/2010. KB = Cumulative update package 17 for SQL Server 2005 Service Pack 2 ·         SQL…


SQL Server’s Default Trace

Are you familiar with SQL Server’s default trace setting? It can be helpful with finding basic who/when type information on major events. For example, you may want to know who was creating and dropping databases on a given instance.   SQL Server has a couple of options that might help you find out more about…


Backing up a corrupted SQL Server database

I had a question about how to do a backup and skip a corrupted block of data. First, DO NOT DO IT unless you absolutely have to, such as when you are taking a backup prior to trying to fix the corruption (which means you should be on the phone with Microsoft PSS). If you do…