The mssql extension for Visual Studio Code, used to support SQL Server connections and T-SQL editing, has been updated with IntelliCode functionality and a new Object Explorer, among other new ...

PySpark development is now fully supported in Visual Studio Code. Through an extension built for the aforementioned purpose, users can run Spark jobs with SQL Server 2019 Big Data Clusters.

Microsoft SQL Operations Studio (source: Microsoft). As for more of that VS Code goodness, Microsoft said "You'll be able to leverage your favorite command line tools like Bash, PowerShell, sqlcmd, ...