The January release of Azure Data Studio
We are excited to announce the January release of Azure Data Studio (formerly known as SQL Operations Studio) is now available.
Note: If you are currently using the preview version, SQL Operations Studio, and would like to retain your settings when upgrading to the latest version, please follow these instructions. After downloading Azure Data Studio, click “Yes” to enable preview features so that you can use extensions.
Azure Data Studio is a new cross-platform desktop environment for data professionals using the family of on-premise and cloud data platforms on Windows, MacOS, and Linux. To learn more, visit our GitHub.
Azure Data Studio was announced Generally Available at Microsoft Ignite 2018. If you missed it, you can view that GA announcement here. You wont want to miss the great orthogonality matrix that compares SQL Server Management Studio (SSMS) and Azure Data Studio, and it may provide answers to many of your questions.
Check out the video below for a general overview of Azure Data Studio.
The key highlights for the January release include:
- Azure Active Directory Authentication support
- Announcing Data-Tier Application Wizard support
- Announcing IDERA SQL DM Performance Insights (Preview)
- Updates to the SQL Server 2019 Preview extension
- SQL Server Profiler improvements
- Preview: results streaming for large queries
- User setup installation support
- Bug fixes
For a complete list of updates, refer to the Release Notes.
Azure Active Directory Authentication support
When Azure Data Studio was announced for Public Preview in November 2017, we received many requests and upvotes for features users wanted to see in Azure Data Studio. What turned out to be the third most upvoted feature request was Azure Active Directory (AAD) support, and we are excited to announce that AAD is now supported in Azure Data Studio.
Thanksto feedback from our user community from testing our insider builds, we have made it easier for you to connect with AAD. To see AAD in action, view the gif below.
For Azure SQL Database and SQL Data Warehouse users who require AAD, you can now get started with using Azure Data Studio. We challenge you to make a connection with AAD and try our Quickstarts for Azure SQL Database and Azure SQL Data Warehouse. If there are feature gaps, you can file an issue on our Issues page.
With the release of AAD, we made it a priority to release this feature as soon as dependencies in .NET Core were available.Thank you to our user community for helping us prioritize this feature through Twitter, GitHub, sqlcommunity Slack channel, and at conferences for this feature.
A more immediate way to let us know the importance of your feature request is to look for an existing issue on this list and encourage your coworkers, colleagues, and friends on social media to give a thumbs up on the issue, or blog about it. Even bettercomment about what scenarios this feature would help you with. If a feature request doesnt already exist, feel free to make it yourself. We want you to be part of the journey for this product.
Announcing Data-Tier Application Wizard support
Speaking of top customer feature requests, we have also added preview support for the Data-Tier Application Wizard used in SSMS, which is currently among the top 10 most requested features.
These wizards make it easier for users to manage .dacpac and .bacpac files, which simplifies the development, deployment, and management of data-tier elements that support an application. To learn more about using Data-tier applications, you can read this documentation.
The current experience combines the four separate wizards from SSMS into one wizard where users can choose which action they need to take. These actions include:
- Deploying .dacpac to SQL Server instance
- Extracting SQL Server instance to a .dacpac
- Creating a database from .bacpac
- Exporting schema and data to .bacpac
You can see Extract in action in the gif below.
In order to use this wizard, you will need to install the SQL Server Import extension. This is included with the Import Flat File Wizard, which is also a preview experience. This extension gives you the top two most used wizards from SSMS.
After downloading the extension, you can access the wizard in two ways:
- Right click a database in the Object Explorer and clickData-tier Application wizard
- If you are connected to a SQL Server instance, you can also start the wizard from the command palette (Ctrl+Shift+P) by searching forData-tier Application wizard
As we did for SQL Server Agent and Import, we are actively seeking community feedback on improving this experience.
If you are interested in having a chat about this experience to help out your team, feel free to reach out on GitHub or email email@example.com.
Introducing the IDERA extension SQL DM Performance Insights (Preview) extension
As part of the roadmap for Azure Data Studio, we’re finding ways to empower our partners to build extensions with our extensibility model. To show the progress we’re making on our extensibility, we are excited to announce the new IDERA extension.
IDERA SQL DM Performance Insights is an Azure Data Studio (ADS) extension that will display key performance metrics for SQL Server that have been collected and stored in a database repository by IDERAs SQL Diagnostic Manager, a powerful performance monitoring, alerting, and diagnostics solution for SQL Server that proactively notifies administrators to health, performance, or availability problems via a desktop console, web console add-on, or mobile device.
This extension is a free add-in for Azure Data Studio that quickly allows you to see high level aggregated performance issues across multiple servers monitored by SQL Diagnostic Manager.
This preview provides the following features:
- Servers: Display metrics such as CPU, Disk I/O, network, and memory used
- Sessions: Display session summary averages such as client connections, logins, user processes, transactions, and oldest open transactions
- Databases: Display database summary-related statistics such as reads, writes, transactions, and log activity at the server level, as well as database statistical averages at the database level
- Queries: Display wait statistics and summaries of query statistics
This extension is free and will be supported through the IDERA Community Free Tools.
With partners joining our marketplace, if you are also interested in joining our extension marketplace or are curious about how to get started, feel free to contact me firstname.lastname@example.org get started.
SQL Server 2019 Preview extension
Since announcing the Public Preview of SQL Server 2019 at Ignite, we are continuing to make updates to the SQL Server 2019 extension in Azure Data Studio, including improvements in the Azure Data Studio Notebooks and the Create External Data Wizard.
Azure Data Studio Notebooks
- The Notebook view UI has moved into Azure Data Studio core. This improves performance when loading and updating a notebook, including Jupyter notebook compatibility.
- The PROSE python package has been updated to 1.2.1 and includes a number of bug fixes. Use the Reinstall Notebook Dependencies commandin the command palette to update this package.
- Cells have a simpler look with just one Run Cell button on the action bar, a real context menu with additional actions on the right of the cell. You can also double-click to edit support on Markdown cells.
- A Notebook API is in progress. This is included in the proposed API file for Azure Data Studio. As this feature is in active development, we expect some APIs to change, but these can be used to perform basic operations on a Notebook – Open New/Existing Notebook, query contents, add cells, etc.
Create External Data Wizard
- A new wizard to create external data sources from HDFS files/folders in SQL Server 2019 big data clusters has been added.
- Support for mapping SQL Server and Oracle Views has been added to the existing Create External Data wizard.
- Performance and reliability fixes for the existing wizard were also added.
SQL Server Profiler Improvements
We know the user community has been asking for a better Profiler experience. Whileworking with Julie Lerman on her MSDN magazine article, we decided to make some investments to improve the Profiler experience.
To access SQL Server Profiler, you will need to download the extension through the Extensions marketplace. You can then right-click your target server and click Launch Profiler.
In this release, we fixed 11 bugs which include:
- Consistent Text/Details pane to pop up
- Fixed long time for profiler to refresh events
- Fixed Profiler for Azure SQL instances
We also added UI updates to the toolbar to make each action or dropdown clearer that the user can change. Please let us know any feedback you have.
In addition, we worked on improving the first-time experience to make it easier to launch Profiler. When you right-click a server and click Profiler, there is a default session name provided for each session template.
When you click start, Profiler will immediately start running. If you have any issues running Profiler, please let us know on GitHub.
Preview: Results streaming for large queries
In previous versions of Azure Data Studio, when a user ran large queries, no results would appear in the results grid until the query could show all of the results. This was not a great experience for our users, thus we did some investigating to improve this experience. In the latest build of Azure Data Studio, users can now see results streamed in the results grid. This makes it a better experience since users can see the results quicker and interact with their data instead of being in a waiting state.
However, this is still a preview feature so it is disabled by default. To enable this feature when you are running large queries, you will need to go to File> Preferences > Settings,andSearch Settings for “sql.results.streaming” and set this value to true. Then you will need torestart Azure Data Studio.
Please let us know of any feedback you have for this experience, we will continue to be making investments in improving Query Editor and theresults grid in the upcoming months.
User Setup installation support
Now featured on the Azure Data Studio download page is user setup installation for Windows only. This downloads the whole executable for Azure Data Studio so you wont need admin privileges to install Azure Data Studio since the location will be under Local AppData folder. This also makes it easier to get monthly auto-updates.
We encourage users to download User Setup going forward. If you are transitioning from System Setup to User Setup, you will not lose any of your settings or extensions in the process.
Bug fixes and thank yous
If you would like to help make Azure Data Studio a great product, please share any feedback or report issues through our Issues page. Our engineering team is regularly monitoring the untriaged issues and assigning issues into different monthly milestones so that you will know we are working on it. Your votes on issues helps us prioritize.
To see the full list of bug fixes in the January release, view them here.
We also want to take this time to thank many of our users who have submitted PRs or taken time to give us feedback in calls.
- Tarig0 forAdd Routine_Type to CreateStoredProc fixes #3257 (#3286)
- oltruong fortypo fix #3025′
- Thomas-S-B forRemoved unnecessary IErrorDetectionStrategy #749
- Thomas-S-B forSimplified code #750
- Julie Lerman for feedback on Profiler and Import Wizard extensions, as well as writing MSDN magazine article on Azure Data Studio
- Dave Dustin for testing AAD, user setup, Data-Tier Application Wizard
- Peter Schott for feedback on AAD and Data-Tier Application Wizard
- Josh Booker for feedback on Data-Tier Application Wizard
- Constantine Kokkinos for feedback on Profiler
- Warwick Rudd for feedback on SQL Agent
- Mario Ezra for testing user setup