In the world of SQL Server the most popular words I hear are “It depends” (SQL Skills even have a t-shirt with it on).  So It’s nice to every once in a while get some standards and rules that you can rely on and trust.

With that im starting a collection of standards and best practices that I find.

SQL Server – Paul Nielsen – Design and Development Standards, from SQL Bible 2008

http://sqlstandards.codeplex.com/

SSIS – Andy Leonard’s – Framework, SQL Server 2012 Integration Services Design Patterns

http://sqlblog.com/blogs/andy_leonard/archive/2011/09/16/designing-an-ssis-framework.aspx

SSIS – Jamie Thomson’s – Suggested Best Practises and Naming Conventions

http://sqlblog.com/blogs/jamie_thomson/archive/2012/01/29/suggested-best-practises-and-naming-conventions.aspx

Advertisements