Azure Data Studio extensions enable adding new functionality for development and administrative tasks. It is an open-source functionality and allows Microsoft as well as third party extensions using Marketplace. We explored a few useful extensions in the Azure Data Studio category of articles.
Azure Data Studio扩展允许添加用于开发和管理任务的新功能。 它是一种开源功能,允许Microsoft以及使用Marketplace的第三方扩展。 我们在文章的Azure Data Studio类别中探索了一些有用的扩展。
In this article, we will acquire a knowledge of the SQL Server Assessment extension and its usage.
在本文中,我们将获得有关SQL Server评估扩展及其用法的知识。
先决条件 (Pre-requisites)
安装最新版本(2020年6月)的Azure Data Studio (Install the latest version (June 2020) of Azure Data Studio)
Microsoft provides monthly releases for the Azure Data Studio. You should always work with the latest version to take the benefits of all features. In this article, we will use June 2020 release version 1.19.0. You can download it from Microsoft docs on your choice of platform Window, macOS and Linux.
Microsoft提供Azure Data Studio的每月版本。 您应该始终使用最新版本以充分利用所有功能。 在本文中,我们将使用2020年6月发行版1.19.0。 您可以选择Windows平台,macOS和Linux平台从Microsoft文档下载它。
You should use the user installer (recommended) because it does not require administrative rights on your local system.
您应该使用用户安装程序(推荐),因为它不需要本地系统上的管理权限。
启用预览功能 (Enable Preview Features)
You should also have Enable Preview Features checked in the ADS user settings. To verify it, go to View -> Command Palette ->search for Preferences: Open user settings.
您还应该在ADS用户设置中选中“ 启用预览功能” 。 要进行验证,请转到查看->命令面板->搜索首选项:打开用户设置。
It should have a tick on the Enable unreleased preview features.
它应该在“ 启用未发布的预览功能”上打勾。
适用于Azure Data StudioSQL Server评估扩展概述 (Overview of the SQL Server Assessment extension for Azure Data Studio)
You might be familiar with the Windows PowerShell and SQL Server PowerShell module. It has an Invoke-SqlAssessment cmdlet to assess SQL Server and returns a list of SQL Server best practices. We can use it for SQL Server 2012 onwards along with the Azure SQL Database Managed Instance.
您可能熟悉Windows PowerShell和SQL Server PowerShell模块。 它具有一个Invoke-SqlAssessment cmdlet可以评估SQL Server并返回SQL Server最佳实践的列表。 我们可以将其与 Azure SQL数据库托管实例一起用于SQL Server 2012及更高版本 。
为Azure Data Studio安装SQL Server评估扩展的步骤 (Steps to install SQL Server Assessment Extension for Azure Data Studio)
Launch ADS, and go to Marketplace as shown in the below image. Search for the SQL Server Assessment.
启动ADS,然后转到市场,如下图所示。 搜索“ SQL Server评估”。
Click on the Install to begin installation as