Buck Woody : Links for Patterns and Practices for the Data Professional

Some useful links here.

Patterns and Practices Developer Center: http://msdn.microsoft.com/en-us/practices/default.aspx

Microsoft Solution Accelerators: http://technet.microsoft.com/en-us/solutionaccelerators/default.aspx

Application Architecture Guides: http://apparch.codeplex.com/wikipage?title=Knowledge%20Base%20Index&referringTitle=Home&ProjectName=apparch

Application Architecture Guide Free Book: http://apparchguide.codeplex.com/

Microsoft Operations Framework: http://technet.microsoft.com/en-us/library/cc506049.aspx

Patterns and Practices Symposium: http://blogs.msdn.com/b/agile/archive/2010/08/25/the-patterns-amp-practices-symposium-redmond-2010.aspx

Patterns and Practices document from Microsoft, for data: http://msdn.microsoft.com/en-us/library/ms998446.aspx

Article by Brian Knight on Database Standards and Conventions: http://www.sqlservercentral.com/articles/Naming+Standards/sqlstandards/176/

SQL Server Best Practices: http://technet.microsoft.com/en-us/sqlserver/bb331794.aspx

Also - The information for making a "default template" for SSMS queries is here in this post: http://blogs.msdn.com/b/buckwoody/archive/2009/10/28/templates-for-new-query-window.aspx