I have been thinking about creating a tool like this for a while now. I know that there is the SQL Server 2005 Best Practices Analyzer and that in SQL server 2008 this has become Policy Management. What I want to create is a pure T-SQL tool where you can just run a stored proc and specify what to check.

I wonder if people would be interested in such a tool, I started a therad here: SQLCop and got some feedback from various people.

Here is what I want this tool to do

identify that:

no p...

I was listening to show number 426 on dotnetrocks: Rob Boucher on Application Architecture Guidance! They mentioned the Patterns And Practices Application Architecture Guide 2.0, this guide is available for free on codeplex.

Although it is a Microsoft technology centric guide, there should be chapters for every developer in your group.

Here is one example from the book

Key Design Principles

When getting started with your design, bear in...

Straight from the man himself comes this statement posted in the microsoft.public.sqlserver.programming forum: “You need to read ISO-11179 so you use proper data element names. You

actually had “tbl-"on the table names! Sometimes “id” id a

prefix and sometimes it is a postfix.“

Of course you know who I am talking about? No? Joe Celko of course. So what is ISO-11179?

The ...