<commit_before># TSqlRules
TSQL Static Code Analysis Rules for SQL Server

## 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:
* [Overview of Extensibility for Database Code Analysis Rules](https://msdn.microsoft.com/en-us/library/dn632173(v=vs.103).aspx)
* [DACFx Reference](https://msdn.microsoft.com/en-us/library/dn645454.aspx)
* [ScriptDom Namespace](https://technet.microsoft.com/en-us/library/microsoft.sqlserver.transactsql.scriptdom(v=sql.110).aspx)

## Usage Notes
The following references need to be updated if you are running different verions of Visual Studio.  Currently they are configured to reference Visual Studio 2015 installation path.
* Microsoft.Data.Tools.Schema.Sql.dll
* Microsoft.Data.Tools.Utilities.dll
* Microsoft.SqlServer.Dac.dll
* Microsoft.SqlServer.Dac.Extensions.dll
* Microsoft.SqlServer.TransactSql.ScriptDom.dll

Visual Studio 2013: 
* C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\120\

Visual Studio 2015:<commit_msg>Update reference info and add build status<commit_after># TSqlRules
TSQL Static Code Analysis Rules for SQL Server

![alt text](https://aleefncinc.visualstudio.com/_apis/public/build/definitions/c2c2dfd2-e9c4-472e-8ffb-e45f661e5dbf/2/badge "Build Info")

## 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:
* [Overview of Extensibility for Database Code Analysis Rules](https://msdn.microsoft.com/en-us/library/dn632173(v=vs.103).aspx)
* [DACFx Reference](https://msdn.microsoft.com/en-us/library/dn645454.aspx)
* [ScriptDom Namespace](https://technet.microsoft.com/en-us/library/microsoft.sqlserver.transactsql.scriptdom(v=sql.110).aspx)

## 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.  SSDT installs those DLL in the below referenced paths.
* Microsoft.Data.Tools.Schema.Sql.dll
* Microsoft.Data.Tools.Utilities.dll
* Microsoft.SqlServer.Dac.dll
* Microsoft.SqlServer.Dac.Extensions.dll
* Microsoft.SqlServer.TransactSql.ScriptDom.dll

Visual Studio 2013:
* C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\120\
* C:\Program Files (x86)\Microsoft SQL Server\120\SDK\Assemblies

Visual Studio 2015:
{'fraction_non_alphanumeric': 0.09040907528360262, 'fraction_numerical': 0.03403231350979718, 'mean_word_length': 5.2312633832976445, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 7, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '6282362', 'n_tokens_mistral': 927, 'n_tokens_neox': 817, 'n_words': 272}