Home

Awesome

TSqlRules

TSQL Static Code Analysis Rules for SQL Server

alt text

Project Description

This library extends the SSDT (SQL Server Data Tools) functionality for creating static code analysis rules for Database Projects. The TSqlRules DLL can be added to Visual Studio to display errors and warnings inside the "Error List" window and can also be used with MSBuild.

Based on functionality described here:

Rule Overview

Design

Performance

Naming

Usage Notes

The following references need to be updated if you are running different verions of Visual Studio. Currently they are configured for Visual Studio 2015 and are included in a Library folder to allow this to build online at Visual Studio Team Services. SSDT installs those DLL in the below referenced paths that you can use on your local.

Visual Studio 2013:

Visual Studio 2015:

Note: the path you copy the new rules DLL and PDB file to need to match the directory above for your VS version.

If you are adding as an extension to Visual Studio, the assembly needs to be signed.

Microsoft Rules

Microsoft Rules included in Code Analysis by default:

Design

Naming

Performance