Wednesday, January 3, 2007

Best Practices for SQL (Evolving entry)

This is an incremental link. Those are links I wanted to put here to find quickly some best practices to design administer and maintain SQL databases.

Books online/ Sample Data bases. Always huge source of best advises.

SQL Best Practices
------------------------
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/default.mspx

Best Practice Analyzer tool
-------------------------------
http://www.microsoft.com/downloads/details.aspx?FamilyID=B352EB1F-D3CA-44EE-893E-9E07339C1F22&displaylang=en

Storage Top 10 Best Practices
------------------------------------
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/storage-top-10.mspx

Data Patterns (high level)
--------------------------------
http://msdn.microsoft.com/practices/compcat/default.aspx?pull=/library/en-us/dnpatterns/html/dp.asp

No comments: