How to Enable Preview Features in Azure Data Studio

Microsoft always releases new features and enhancements as part of preview features in Azure Data Studio before making it publicly available for general use. Users can go ahead and check these features, give their feedback to Microsoft and based on these feedbacks Microsoft makes changes or release that feature under General Availability. Users can only use them if preview features will be enabled in Azure Data Studio. I will explain how to enable preview features in Azure Data Studio in this article.

Azure Data Studio is cross-platform database management tool to manage on prem as well as cloud based SQL Server deployments on windows, Linux and MacOS platforms. This tool offers a modern editor experience with IntelliSense, code snippets, source control integration, and an integrated terminal.

When you launch Azure Data Studio first time, it will show you a popup window and ask you to enable the preview features. You can choose “Yes” to use preview features and “No” to disable this feature. If this settings is disabled in your Azure Data studio then you can enable it anytime by accessing settings tab given bottom left of the Azure Data Studio screen. Below is the list of preview features for SQL Server in Azure Data Studio.

  • Azure portal integration
  • SQL Server Backup and Restore
  • Deployments of SQL Edge, SQL Server Big Data Cluster, SQL Server container image & SQL Server on Windows
  • SQLCMD mode
  • Admin Pack for SQL Server
  • Azure Synapse Analytics Insights
  • Central Management Servers
  • Database Administration Tool Extensions for Windows
  • Kusto
  • Language packs
  • PostgreSQL
  • PowerShell
  • Query History
  • SandDance for Azure Data Studio
  • Server Reports
  • SQL Assessment
  • SQL Server Agent
  • SQL Server Profiler
  • Machine Learning
  • Managed Instance Dashboard
  • Visual Studio IntelliCode
  • whoisactive

Above list is not limited to only given features. I was restoring a database using Azure Data Studio. When i tried to click at restore button, another popup window came and suggested to enable preview features for this restore as shown in below image. When you try to preform any above activity in Azure Data studio, you will get similar popup window.

Preview Features in Azure Data Studio

I will show you step by step process to enable or disable preview feature in Azure Data Studio.

Enable Preview Features

I was trying to perform a database restore using Azure Data Studio and got a popup which was saying ” You must enable preview features in order to use restore “. Follow below steps to get it done.

  • Launch Azure Data Studio
  • Click at the setting button given bottom left of the screen, then again click at the setting options from displayed menu.
Click at Settings
  • Type Enable Preview Features from search bar given on the screen.
  • You will get few options in drop down. Click at checkbox for Enable unreleased preview features under Workbench: Enable Preview Features.
Click at check box to enable preview features
  • This change will automatically been saved in Azure Data Studio.

Now, you are good to go ahead and use all features which are in preview as per your need.

Disable Preview Features

Disabling preview features in Azure Data Studio is similar to above steps. You just need to uncheck the checkbox which you have checked in above step. Follow below steps to get it disabled.

  • Launch Azure Data Studio
  • Click at the setting button given bottom left of the screen. You will get a list of options from which you need to click at the settings options again.
  • Type “Enable Preview Features” from search bar given on the screen.
  • You will get few options in drop down. Uncheck the checkbox for Enable unreleased preview features
  • This change will automatically been saved in Azure Data Studio.

You have learnt preview features enablement and how to disable it in Azure Data Studio.

Read More Articles:

Manvendra Deo Singh
Follow me:

Leave a Reply

Your email address will not be published. Required fields are marked *