Mssql extension adds Object Explorer and IntelliCode to VS Code

Pretty neat stuff, although the SQL command line still is a bit “raw”.  Going to explore how this combines with git versioning, because proper VCS for SQL is important!

The mssql extension for Visual Studio Code is the official SQL Server extension that supports connections to SQL Server and adds a rich editing experience for T-SQL in Visual Studio Code.

Source: Mssql extension for Visual Studio Code now has Object Explorer and IntelliCode – SQL Server Blog

Static Code Analyzer for T-SQL – MS SQL Server.

Static Code Analyzer for T-SQL – MS SQL Server.
Plugs into MS SSMS and can also be run from command line.

It reports useful clues which you can turn/on off to your liking. 
http://sqlcodeguard.com/index-database-issues.html

It will spot declared but unused variables, but it appears it doesn’t do code coverage or execution path to spot stuff like variables being used without being initialized.

http://sqlcodeguard.com/

Price: Free

   

http://sqlcodeguard.com