![]() SQL Server Schema Compare (Microsoft) – compare DACPAC files and databases, and apply changes.SQL Server Profiler (Microsoft) – trace queries, but don’t be fooled by the name: this actually uses Extended Events.SQL Server Import (Microsoft) – the Import Flat File Wizard from SSMS, but in Azure Data Studio.SQL Server Dacpac (Microsoft) – manage data-tier applications, working with DACPAC and BACPAC files.SQL Server Agent (Microsoft) – manage, configure and troubleshoot SQL Agent jobs.Server Reports (Microsoft) – get useful performance-related insights, including tempdb.Schema Visualization (Jens Hunt) – visualize database schemas in Azure Data Studio using mermaid.js.SandDance for Azure Data Studio (msrvida) – visually explore, understand, and present your data.Query History (Microsoft) – keep a record of past executed queries.PowerShell (Microsoft) – write and run PowerShell scripts with rich language support including syntax highlighting and IntelliSense.PostgreSQL (Microsoft) – connect, query, and manage Postgres databases with Azure Data Studio.Poor SQL Formatter (WSR Publishing, Inc) – use the popular Transact-SQL code formatter created by Tao Klerks.New Database (Kevin Cunnane) – add a “New Database” option when right-clicking on the Databases folder.MSSQL Db Insights (matticusau) – provide additional dashboard widgets to give you insight into your SQL Server instance.Machine Learning (Microsoft) – manage packages and models, make predictions, and create notebooks to run experiments for SQL databases.First Responders Kit (Drew Skwiers-Koballa) – work with the First Responder’s Kit from Brent Ozar Unlimited.Demo Mode (Drew Skwiers-Koballa) – toggle the editor font size between your font and a larger font size.Delete database (AlexP) – add a “Delete” option when right-clicking on a database.Data Virtualization (Microsoft) – support for Data Virtualization in SQL Server 2019 and higher, including Virtualize Data wizards.Central Management Servers (Microsoft) – store a list of instances of SQL Server that is organized into one or more groups (more info here).Admin Pack for SQL Server (Microsoft) – a single package containing SQL Server Agent, SQL Server Profiler, SQL Server Import, and SQL Server Dacpac. ![]() Since I use a MacBook as my day-to-day computer, I am listing two sets of extensions, because some of them have dependencies on the underlying operating system. In most cases you can trust extensions from reputable publishers, but always take care. For many of them you must visit a website, download the VSIX file and install it manually using the File > Install Extension from VSIX Package menu option. Note: not all extensions can be installed from the Extensions pane. Installing this many on SQL Server Management Studio (SSMS) would slow it down dramatically. ![]() It’s worth mentioning that for the most part Azure Data Studio extensions are extremely lightweight, both in download size and memory usage. Let's just say in short - you can smoothly work with the databases.At last week’s presentation to the Edmonton SQL Server user group, I spoke at length about the many extensions that are available for Azure Data Studio, and was asked by Chris Wood to share all the extensions I use. Working with dataĪdding connections and operating with SQL data sources is nothing new to Microsoft data tools, so I'll skip it here. And coming to the cloud, where cross-platform is a concern, and heavily using platforms such as Linux, containers, and Mac OS, Azure Data Studio gives much possibilities for work with different data sources. Target audience for the Azure Data Studio is huge: it is intended for application developers, database administrators, database developers, data analysts, as well as for data engineers and scientists, as more features are coming to the ADS in every update.Īpart from SQL Server-based databases (SQL databases on-prem, and Azure SQL), you can also connect to other data sources, by using the various extensions (such as Azure Synapse Analytics, PostgreSQL, MySQL in the future). You will be positively impressed about the look & feel, since it very much resembles Visual Studio Code, and that shouldn't come as a surprise, since the project is actually forked from the GitHub repository, and it has been continuously developed alongside. If you have been using SQL Server Management Studio (SSMS), and you did not know about Azure Data Studio, one surprise for you: you have it probably already installed on your computer, since it's included with the SSMS installation (from version 18.7.1, dated October 27, 2020)!Īzure Data Studio - SQL Server | Microsoft Docs
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |