Some of you might not aware that, currently the Visual Studio Development Edition has been merged with Visual Studio Database Edition (see my previous post).
If you are having the Visual Studio Database Edition, you can now do T-SQL static code analysis for your database project. Just download the Microsoft Visual Studio Team System 2008 Database Edition Power tools from here:http://www.microsoft.com/Downloads/details.aspx?FamilyID=73ba5038-8e37-4c8e-812b-db14ede2c354&displaylang=en
Once you installed the power tools, in your project’s properties windows, you will see the extra “Static Analysis” tab. There are couples of rules that shipped in this tool, including design, naming and performance rules.
Besides the Static Code Analysis, there are some new features that shipped in this release updates. The new features include two custom unit test conditions, a new Data Generation Wizard, and new MSBuild tasks to support running TSQL Static Code Analysis from the command line. The updated features include 5 refactoring types, a dependency viewer, additional data generators and editors, 2 MSBuild tasks for Schema and Data Compare and the TSQL Static Code Analysis feature
New Test Conditions for Database Unit Tests
