Microsoft has unveiled the July 2020 update to Azure Data Studio. The new release of the database tool mainly includes new features around notebooks and the query editor – as well as a number of bug fixes.
A cross-platform SQL code editor that leverages Microsoft’s IntelliSense technology, Azure Data Studio is available for users on Windows, Linux and macOS to work directly with data on SQL Server, Azure SQL Database and SQL Data Warehouse. Jupyter’s integrated notebooks make data management easy in Markdown. For this purpose, the current update offers, among other things, extended header options in the Markdown toolbar to format the notebook content in a more structured way. If required, all headings can be hidden with a single click. Apparently at the request of many users, Microsoft has now added a side-by-side view for the Markdown preview, which previously could only be placed below the text in the notebooks.
Azure Data Studio’s query editor now also supports drag-and-drop of tables. The ability to drag SQL tables and columns directly from the database tree view into the editor was previously reserved for users of SQL Server Management Studio (SSMS). Unlike Azure Data Studio, however, SSMS is primarily optimized for database management and is available only for Windows.
For more information on what’s new in the Azure Data Studio update, see the SQL Server blog and the release notes. Microsoft makes the source code for Azure Data Studio available on GitHub. The software may be freely used and even modified, but distribution or hosting on a cloud service is not allowed.