{"id":24964,"date":"2018-09-25T08:00:43","date_gmt":"2018-09-25T15:00:43","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?p=24964"},"modified":"2018-11-07T15:35:16","modified_gmt":"2018-11-07T23:35:16","slug":"azure-data-studio-for-sql-server","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/","title":{"rendered":"Azure Data Studio for SQL Server"},"content":{"rendered":"<p>Azure Data Studio is a new cross-platform desktop environment for data professionals using the family of on-premises and cloud data platforms on Windows, MacOS, and Linux. Previously released under the preview name SQL Operations Studio, Azure Data Studio offers a modern editor experience with lightning fast IntelliSense, code snippets, source control integration, and an integrated terminal. It is engineered with the data platform user in mind, with built-in charting of query resultsets and customizable dashboards.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24967 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/09\/Azure-data-studio-for-sql-server-screenshot.png\" alt=\"\" width=\"1920\" height=\"1161\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/09\/Azure-data-studio-for-sql-server-screenshot.webp 1920w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/09\/Azure-data-studio-for-sql-server-screenshot-300x181.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/09\/Azure-data-studio-for-sql-server-screenshot-1024x619.webp 1024w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/09\/Azure-data-studio-for-sql-server-screenshot-768x464.webp 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/09\/Azure-data-studio-for-sql-server-screenshot-1536x929.webp 1536w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/09\/Azure-data-studio-for-sql-server-screenshot-330x200.webp 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/09\/Azure-data-studio-for-sql-server-screenshot-800x484.webp 800w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/09\/Azure-data-studio-for-sql-server-screenshot-400x242.webp 400w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/p>\n<p>Research has shown that users spend an order of magnitude more time working on query editing than on any other task with SQL Server Management Studio. For that reason, Azure Data Studio has been designed to focus deeply on the functionality that is used the most, with additional experiences made available as optional extensions into the product. This allows every user to customize their environment to the workflows that they use most often. Today we are pleased to announce the GA of the product, which will continue to be released on a monthly basis.<\/p>\n<p>The vision of the product is to create a unified experience across heterogenous data sources regardless of their form or location: structured or unstructured, on-premises or cloud. Azure Data Studio currently offers built-in support for SQL Server on-premises and on the cloud and Azure SQL Database, along with preview support for Azure SQL Managed Instance, Azure SQL Data Warehouse and SQL Server 2019 Big Data Clusters. Other preview experiences include Azure Data Studio Notebooks, Azure Resource Explorer, SQL Server Profiler, SQL Server Agent, SQL Server Import Wizard, and SQL Server PolyBase Create External Table Wizard. Due to the extensible nature of the product, Azure Data Studio also offers third party partners and community members to contribute their own experiences to the tool, including Redgate\u2019s SQL Search extension.<\/p>\n<p>We are proud to offer a preview of the first ever notebook experience for SQL Server in the Azure Data Studio SQL Server 2019 Preview Extension. Notebooks are one of the most common code development environments for data and serve multiple purposes in a modern data development workflow. Notebooks combine human readable documentation with executable code and resultsets, greatly improving the process of collaborating on data analysis. The Azure Data Studio notebook viewer uses the open source Jupyter server and file format, but adds in the modern, keyboard-focused coding environment and rich editor experience of Azure Data Studio, allowing users to write code in the language of their choice. Having a notebook embedded with Azure Data Studio allows seamless in-context operations such as launching notebook analysis on an HDFS file from the Object Explorer and connection to remote SQL Server big data clusters. In the CTP 2.0 Preview, notebooks may be run locally or against SQL Server big data clusters using Python and Scala, with additional language and endpoint support coming in a future preview, including a planned pure T-SQL notebook experience for the SQL Server user.<\/p>\n<p>Azure Data Studio shares a heritage and a roadmap with SQL Server Management Studio, which has been a phenomenally successful and well-liked tool in its own right. Over the course of time, all of the management features of SQL Server Management Studio will be made available in Azure Data Studio and the two products will integrate smoothly with each other. At present, Azure Data Studio is tightly focused on the experiences around query editing and data development. Additional high-value administrative features such as backup, restore, agent job management, and server profiling are also available as extensions in Azure Data Studio. Azure Data Studio is also cross-platform, allowing users to work on their platform of choice. However, SQL Server Management Studio still offers the broadest range of administrative functions and remains the flagship tool for platform management tasks.<\/p>\n<p><a href=\"https:\/\/aka.ms\/getazuredatastudio\">Azure Data Studio may be downloaded from here<\/a>. You can participate in the future of the tool by entering or voting on feature suggestions, reporting bugs, or by contributing your own pull requests or extensions into the product. The team welcomes your feedback and will be adding capabilities on a monthly basis based on community requests.<\/p>\n<h2>When Should I Use Azure Data Studio vs SQL Server Management Studio?<\/h2>\n<p>Use Azure Data Studio if you:<\/p>\n<ul>\n<li>Need to run on macOS or Linux<\/li>\n<li>Are connecting to a SQL Server 2019 big data cluster<\/li>\n<li>Spend most of your time editing or executing queries<\/li>\n<li>Need the ability to quickly chart and visualize result sets<\/li>\n<li>Can execute most administrative tasks via the integrated terminal using sqlcmd or Powershell<\/li>\n<li>Have minimal need for wizard experiences<\/li>\n<li>Do not need to do deep administrative configuration<\/li>\n<\/ul>\n<p>Use SQL Server Management Studio if you:<\/p>\n<ul>\n<li>Spend most of your time on database administration tasks<\/li>\n<li>Are doing deep administrative configuration<\/li>\n<li>Are doing security management, including user management, vulnerability assessment, and configuration of security features<\/li>\n<li>Make use of the Reports for SQL Server Query Store<\/li>\n<li>Need to make use of performance tuning advisors and dashboards<\/li>\n<li>Are doing import\/export of DACPACs<\/li>\n<li>Need access to Registered Servers and want to control SQL Server services on Windows<\/li>\n<\/ul>\n<h2>Feature comparison<\/h2>\n<table style=\"height: 1527px;width: 100%;border-collapse: collapse;border-style: none\" border=\"1\">\n<tbody>\n<tr style=\"height: 21px;background-color: #d4d4d4\">\n<td style=\"width: 17.37%;height: 21px\">\n<h3>Shell Features<\/h3>\n<\/td>\n<td style=\"width: 10.17%;height: 21px\"><\/td>\n<td style=\"width: 11.82%;height: 21px\"><\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\"><strong>Feature<\/strong><\/td>\n<td style=\"width: 10.17%;height: 21px\"><strong>Azure Data Studio<\/strong><\/td>\n<td style=\"width: 11.82%;height: 21px\"><strong>SSMS<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Azure Sign-In<\/td>\n<td style=\"width: 10.17%;height: 21px\">Yes<\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Dashboard<\/td>\n<td style=\"width: 10.17%;height: 21px\">Yes<\/td>\n<td style=\"width: 11.82%;height: 21px\"><\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Extensions<\/td>\n<td style=\"width: 10.17%;height: 21px\">Yes<\/td>\n<td style=\"width: 11.82%;height: 21px\"><\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Integrated Terminal<\/td>\n<td style=\"width: 10.17%;height: 21px\">Yes<\/td>\n<td style=\"width: 11.82%;height: 21px\"><\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Object Explorer<\/td>\n<td style=\"width: 10.17%;height: 21px\">Yes<\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Object Scripting<\/td>\n<td style=\"width: 10.17%;height: 21px\">Yes<\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Project System<\/td>\n<td style=\"width: 10.17%;height: 21px\">Yes<\/td>\n<td style=\"width: 11.82%;height: 21px\"><\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Select from Table<\/td>\n<td style=\"width: 10.17%;height: 21px\">Yes<\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Source Code Control<\/td>\n<td style=\"width: 10.17%;height: 21px\">Yes<\/td>\n<td style=\"width: 11.82%;height: 21px\"><\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Task Pane<\/td>\n<td style=\"width: 10.17%;height: 21px\">Yes<\/td>\n<td style=\"width: 11.82%;height: 21px\"><\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Theming<\/td>\n<td style=\"width: 10.17%;height: 21px\">Yes<\/td>\n<td style=\"width: 11.82%;height: 21px\"><\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Dark Mode<\/td>\n<td style=\"width: 10.17%;height: 21px\">Yes<\/td>\n<td style=\"width: 11.82%;height: 21px\"><\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Azure Resource Explorer<\/td>\n<td style=\"width: 10.17%;height: 21px\">Preview<\/td>\n<td style=\"width: 11.82%;height: 21px\"><\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Generate Scripts Wizard<\/td>\n<td style=\"width: 10.17%;height: 21px\"><\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Import\\Export DACPAC<\/td>\n<td style=\"width: 10.17%;height: 21px\"><\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Object Properties<\/td>\n<td style=\"width: 10.17%;height: 21px\"><\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Table Designer<\/td>\n<td style=\"width: 10.17%;height: 21px\"><\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"border-style: none;border-color: #d4d4d4;height: 54px;background-color: #d4d4d4\">\n<td style=\"width: 17.37%;height: 54px\">\n<h3>Query Editor<\/h3>\n<\/td>\n<td style=\"width: 10.17%;height: 54px\"><\/td>\n<td style=\"width: 11.82%;height: 54px\"><\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\"><strong>Feature<\/strong><\/td>\n<td style=\"width: 10.17%;height: 21px\"><strong>Azure Data Studio<\/strong><\/td>\n<td style=\"width: 11.82%;height: 21px\"><strong>SSMS<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Chart Viewer<\/td>\n<td style=\"width: 10.17%;height: 21px\">Yes<\/td>\n<td style=\"width: 11.82%;height: 21px\"><\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Export Results to CSV, JSON, XLSX<\/td>\n<td style=\"width: 10.17%;height: 21px\">Yes<\/td>\n<td style=\"width: 11.82%;height: 21px\"><\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">IntelliSense<\/td>\n<td style=\"width: 10.17%;height: 21px\">Yes<\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Snippets<\/td>\n<td style=\"width: 10.17%;height: 21px\">Yes<\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Show Plan<\/td>\n<td style=\"width: 10.17%;height: 21px\">Preview<\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Client Statistics<\/td>\n<td style=\"width: 10.17%;height: 21px\"><\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Live Query Stats<\/td>\n<td style=\"width: 10.17%;height: 21px\"><\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Query Options<\/td>\n<td style=\"width: 10.17%;height: 21px\"><\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Results to File<\/td>\n<td style=\"width: 10.17%;height: 21px\"><\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Results to Text<\/td>\n<td style=\"width: 10.17%;height: 21px\"><\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Spatial Viewer<\/td>\n<td style=\"width: 10.17%;height: 21px\"><\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">SQLCMD<\/td>\n<td style=\"width: 10.17%;height: 21px\"><\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 54px;background-color: #d4d4d4\">\n<td style=\"width: 17.37%;height: 54px\">\n<h3>Operating System Support<\/h3>\n<\/td>\n<td style=\"width: 10.17%;height: 54px\"><\/td>\n<td style=\"width: 11.82%;height: 54px\"><\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\"><strong>Feature<\/strong><\/td>\n<td style=\"width: 10.17%;height: 21px\"><strong>Azure Data Studio<\/strong><\/td>\n<td style=\"width: 11.82%;height: 21px\"><strong>SSMS<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Linux<\/td>\n<td style=\"width: 10.17%;height: 21px\">Yes<\/td>\n<td style=\"width: 11.82%;height: 21px\"><\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">macOS<\/td>\n<td style=\"width: 10.17%;height: 21px\">Yes<\/td>\n<td style=\"width: 11.82%;height: 21px\"><\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Windows<\/td>\n<td style=\"width: 10.17%;height: 21px\">Yes<\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px;background-color: #d4d4d4\">\n<td style=\"width: 17.37%;height: 21px\">\n<h3>Data Engineering<\/h3>\n<\/td>\n<td style=\"width: 10.17%;height: 21px\"><\/td>\n<td style=\"width: 11.82%;height: 21px\"><\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\"><strong>Feature<\/strong><\/td>\n<td style=\"width: 10.17%;height: 21px\"><strong>Azure Data Studio<\/strong><\/td>\n<td style=\"width: 11.82%;height: 21px\"><strong>SSMS<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Create External Table Wizard<\/td>\n<td style=\"width: 10.17%;height: 21px\">Preview<\/td>\n<td style=\"width: 11.82%;height: 21px\"><\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">HDFS Integration<\/td>\n<td style=\"width: 10.17%;height: 21px\">Preview<\/td>\n<td style=\"width: 11.82%;height: 21px\"><\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Notebooks<\/td>\n<td style=\"width: 10.17%;height: 21px\">Preview<\/td>\n<td style=\"width: 11.82%;height: 21px\"><\/td>\n<\/tr>\n<tr style=\"height: 54px;background-color: #d4d4d4\">\n<td style=\"width: 17.37%;height: 54px\">\n<h3>Database Adminstration<\/h3>\n<\/td>\n<td style=\"width: 10.17%;height: 54px\"><\/td>\n<td style=\"width: 11.82%;height: 54px\"><\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\"><strong>Feature<\/strong><\/td>\n<td style=\"width: 10.17%;height: 21px\"><strong>Azure Data Studio<\/strong><\/td>\n<td style=\"width: 11.82%;height: 21px\"><strong>SSMS<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Backup \/ Restore<\/td>\n<td style=\"width: 10.17%;height: 21px\">Yes<\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Flat File Import<\/td>\n<td style=\"width: 10.17%;height: 21px\">Preview<\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">SQL Agent<\/td>\n<td style=\"width: 10.17%;height: 21px\">Preview<\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">SQL Profiler<\/td>\n<td style=\"width: 10.17%;height: 21px\">Preview<\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Always On<\/td>\n<td style=\"width: 10.17%;height: 21px\"><\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Always Encrypted<\/td>\n<td style=\"width: 10.17%;height: 21px\"><\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Copy Data Wizard<\/td>\n<td style=\"width: 10.17%;height: 21px\"><\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Data Tuning Advisor<\/td>\n<td style=\"width: 10.17%;height: 21px\"><\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Error Log Viewer<\/td>\n<td style=\"width: 10.17%;height: 21px\"><\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Maintenance Plans<\/td>\n<td style=\"width: 10.17%;height: 21px\"><\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Multi-Server Query<\/td>\n<td style=\"width: 10.17%;height: 21px\"><\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Policy Based Management<\/td>\n<td style=\"width: 10.17%;height: 21px\"><\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">PolyBase<\/td>\n<td style=\"width: 10.17%;height: 21px\"><\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Query Store<\/td>\n<td style=\"width: 10.17%;height: 21px\"><\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Registered Servers<\/td>\n<td style=\"width: 10.17%;height: 21px\"><\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Replication<\/td>\n<td style=\"width: 10.17%;height: 21px\"><\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Security Management<\/td>\n<td style=\"width: 10.17%;height: 21px\"><\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Service Broker<\/td>\n<td style=\"width: 10.17%;height: 21px\"><\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">SQL Mail<\/td>\n<td style=\"width: 10.17%;height: 21px\"><\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Template Explorer<\/td>\n<td style=\"width: 10.17%;height: 21px\"><\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">Vulnerability Assessment<\/td>\n<td style=\"width: 10.17%;height: 21px\"><\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<tr style=\"border-style: none;border-color: #000000;height: 21px\">\n<td style=\"width: 17.37%;height: 21px\">XEvent Management<\/td>\n<td style=\"width: 10.17%;height: 21px\"><\/td>\n<td style=\"width: 11.82%;height: 21px\">Yes<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Azure Data Studio is a new cross-platform desktop environment for data professionals using the family of on-premises and cloud data platforms on Windows, MacOS, and Linux. Previously released under the preview name SQL Operations Studio, Azure Data Studio offers a modern editor experience with lightning fast IntelliSense, code snippets, source control integration, and an integrated<\/p>\n","protected":false},"author":5562,"featured_media":25459,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"post_tag":[],"product":[2542],"content-type":[2421],"topic":[2466],"coauthors":[2530],"class_list":["post-24964","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","product-azure-data-studio","content-type-announcements","topic-developer"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Azure Data Studio for SQL Server - Microsoft SQL Server Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Azure Data Studio for SQL Server - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"Azure Data Studio is a new cross-platform desktop environment for data professionals using the family of on-premises and cloud data platforms on Windows, MacOS, and Linux. Previously released under the preview name SQL Operations Studio, Azure Data Studio offers a modern editor experience with lightning fast IntelliSense, code snippets, source control integration, and an integrated\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2018-09-25T15:00:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-07T23:35:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/Azure-Data-Studio_Blog_Thumbnail.png\" \/>\n\t<meta property=\"og:image:width\" content=\"280\" \/>\n\t<meta property=\"og:image:height\" content=\"180\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Vicky Harp\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vicky Harp\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/vicky-harp\/\",\"@type\":\"Person\",\"@name\":\"Vicky Harp\"}],\"headline\":\"Azure Data Studio for SQL Server\",\"datePublished\":\"2018-09-25T15:00:43+00:00\",\"dateModified\":\"2018-11-07T23:35:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/\"},\"wordCount\":1064,\"commentCount\":6,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/Azure-Data-Studio_Blog_Thumbnail.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/\",\"name\":\"Azure Data Studio for SQL Server - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/Azure-Data-Studio_Blog_Thumbnail.png\",\"datePublished\":\"2018-09-25T15:00:43+00:00\",\"dateModified\":\"2018-11-07T23:35:16+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/Azure-Data-Studio_Blog_Thumbnail.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/Azure-Data-Studio_Blog_Thumbnail.png\",\"width\":280,\"height\":180,\"caption\":\"a close up of a sign\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Azure Data Studio for SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Azure Data Studio for SQL Server - Microsoft SQL Server Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"Azure Data Studio for SQL Server - Microsoft SQL Server Blog","og_description":"Azure Data Studio is a new cross-platform desktop environment for data professionals using the family of on-premises and cloud data platforms on Windows, MacOS, and Linux. Previously released under the preview name SQL Operations Studio, Azure Data Studio offers a modern editor experience with lightning fast IntelliSense, code snippets, source control integration, and an integrated","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2018-09-25T15:00:43+00:00","article_modified_time":"2018-11-07T23:35:16+00:00","og_image":[{"width":280,"height":180,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/Azure-Data-Studio_Blog_Thumbnail.png","type":"image\/png"}],"author":"Vicky Harp","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"Vicky Harp","Est. reading time":"4 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/vicky-harp\/","@type":"Person","@name":"Vicky Harp"}],"headline":"Azure Data Studio for SQL Server","datePublished":"2018-09-25T15:00:43+00:00","dateModified":"2018-11-07T23:35:16+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/"},"wordCount":1064,"commentCount":6,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/Azure-Data-Studio_Blog_Thumbnail.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/","name":"Azure Data Studio for SQL Server - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/Azure-Data-Studio_Blog_Thumbnail.png","datePublished":"2018-09-25T15:00:43+00:00","dateModified":"2018-11-07T23:35:16+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/Azure-Data-Studio_Blog_Thumbnail.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/Azure-Data-Studio_Blog_Thumbnail.png","width":280,"height":180,"caption":"a close up of a sign"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Azure Data Studio for SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/24964"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/5562"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=24964"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/24964\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media\/25459"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=24964"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=24964"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=24964"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=24964"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=24964"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=24964"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}