question

JamesJ-9502 avatar image
1 Vote"
JamesJ-9502 asked ErlandSommarskog answered

Need recommended list of free static code analysis tool to inspect SQL files

Hi,

In the market we have many paid version of static code analysis tools to check many programming languages and scripts. I would like to know, Do you have any recommended static code analysis (free) tool to analyze SQL files.
Requirement: It has to inspect the SQL script quality and security.

Please share the details. Will be helpful.

Thanks,
J

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
1 Vote"
ErlandSommarskog answered

I saw a flash for something called SQL Fluff today: https://docs.sqlfluff.com/en/stable/. It was described as an open-source SQL Linter. There is also a VS Code extension: https://marketplace.visualstudio.com/items?itemName=dorzey.vscode-sqlfluff.

I only saw this today, and I have not had the time to try it myself.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered TomPhillips-1744 edited

That is functionality built-in to the SSDT add-in for Visual Studio for common problems.

https://docs.microsoft.com/en-us/previous-versions/visualstudio/visual-studio-2010/dd172133(v=vs.100)

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.