How to Run SQL Assessment Checks in Azure SQL MI | Data Exposed

Published 03-11-2021 10:06 AM 988 Views
Microsoft

SQL Assessment API provides a mechanism to evaluate the configuration of your SQL Server for best practices. The API is delivered with a ruleset containing best practice rules suggested by SQL Server Team. This ruleset is enhancing with the release of new versions but at the same time, the API is built with the intent to give a highly customizable and extensible solution. So, users can tune the default rules and create their own ones. The API can be used to assess SQL Server versions 2012 and higher and Azure SQL Managed Instance.

In this episode with Aaron Nelson, we’ll show you the basics of the SQL Assessment PowerShell commands, and how you can run the assessments for your Azure SQL Managed Instances as well as your on-prem SQL Server instances.


Watch on Data Exposed


Resources:
 
View/share our latest episodes on Channel 9 and YouTube!
Co-Authors
Version history
Last update:
‎Mar 15 2021 08:35 AM
Updated by: