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

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

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