I’ve accumulated a lot of tips and tricks over the years. Here’s some of my articles and pages about SQL Server best practices.
Before you set up SQL Server 2005 or 2008, here’s a few things you need to know:
- SQL Server 2005 Setup Best Practices Checklist – a best-practices list that explains not just what to do before installing a new SQL Server, but also why I recommend each step.
- Dev, Test and Production Environment Best Practices – my favorite way to set up these environments.
- SQL Server 2008 Central Management Server – you’ve never heard of this, right? In this post, I explain why this hidden feature is so cool and how you can use it to do policy-based management on your SQL 2000 and 2005 boxes.
- Before You Upgrade SQL Server – learn why you have to benchmark every query before and after so you can avoid some of the troubles we had at StackOverflow.com.
- Steel Cage Blogmatch: How To Configure a SAN for SQL Server – I have a virtual debate with Jason Massie of StatisticsIO, and you get a ringside seat.
- Browse All Posts Tagged “SQL-Server-Best-Practices”




[...] Brent Ozar (Becoming a DBA, How to Hire a DBA, SQL Server Best Practices) [...]