Hi, while SQLEnlight gives you good options, it does not integrate in a natural way with SSDT, which is the tool we use in our DLM. We have customized or extended the static code analysis for other languages c#, so we just wanted to do it in the same way for TSQL, so using DacFx and ScriptDom API we found a way to do it.

We created 3 files:

dll, implements the rules

xml, customizes the rules

xsd, describes the elements in the xml file

To install the rules you just need to copy the files to the Visual Studio extension folder. VS will recognize the rules automatically.

We are using this approach in our CI process too with great results.