SQL Best Practices

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”