SQL Server Database standards & best Practices

Question

Are any SQL Server Database standards & best Practices documentation that I can use as reference for naming conventions, security, using schemas, etc?

Answer 1

Hi gugulethun

There's a few short words on it here http://www.interaktonline.com/Support/Articles/Details/Design+Your+Database-Best+Practices+in+Database+Design.html?id_art=24&id_asc=220

That site and the next in the article seems pretty ok.

Answer 2

Hi, Maybe you can look on this website http://www.sqlskills.com and find something interesting. Or try this one http://www.sqlservercentral.com

Answer 3

I'm new to my current company and have moved up in the chain from previous jobs. It was my responsibility to draw up some Coding Standards and best practices for our Software Development and there were bunches of documents out there for C# for me to start with. To my surprise however there wasn't nearly as much for SQL Server. I think that is because it isn't nearly as clear cut when it comes to databases. It is a much more subjective area and very much depends on your design and what you need to do.

Here are a couple of links I came across:

Jumping off point: http://blogs.techrepublic.com.com/datacenter/?p=436

Best Practices Analyzer: http://esersahin.wordpress.com/2009/01/18/best-practices-design-and-development-guidelines-for-microsoft-sql-server/

I would also pay a visit to the Patterns and Practices site: http://msdn.microsoft.com/en-us/practices/default.aspx

And look st some of the specific things you are doing to get a feel for what they recommend on the database side.

Answer 4

A few links of interest:

• SSW Rules to Better SQL Server Databases
• MSDN - SQL Server Best Practices