OK, I know many of us have a short week this week because of the Labor Day holiday next Monday, so I want to get this post out early enough in the week so that folks can get started on writing. If you have the time, write your entry now and post it to go [...]
How Many Log Files Should My SQL Server Database Have?
One.
That’s it, no more, just one.
Why is that? Because activity to the transaction log is written sequentially. Adding more logs does not help with performance. If you don’t believe me then perhaps you would believe Paul Randal? If you don’t believe him then you need more help that any one blog post could ever give.
Now, are you [...]
Book Review: Microsoft SQL Server 2008 R2 Administration Cookbook
Recently I was contacted by Packt publishing regarding their book, Microsoft SQL Server 2008 R2 Administration Cookbook. I didn’t know that the book even existed! They were happy to provide me with a copy of the book in exchange for a review and I accepted their gracious offer. So, here we go!
I really enjoyed this book. [...]
Call Me Mini-Master
Earlier this year my friend Tim Chapman and I started meeting on Friday mornings in order to do some study prep for the SQL MCM exam. Tim had recently taken a role with Microsoft as a PFE and so he knew the MCM was in his future. Me? Well, I had taken the test in [...]
1 2