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 rulesxsd, describes the elements in the xml fileTo 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.
Hi acortina68,
Do you mind sharing your visual studio solution, I'm currently researching on this topic as well and I'm leaning towards the DacFx approach on extending the static code analytics for SSDT. Thanks in advance, my email address is eatierra@gmail.com if you can email me please. Thanks so much.