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. To watch more Data Exposed episodes, check out our playlist on YouTube: https://aka.ms/dataexposedyt Subscribe to our YouTube channel: https://aka.ms/msazuresqlyt Follow us on Twitter: https://aka.ms/azuresqltw
https://techcommunity.microsoft.com/t5/video-hub/how-to-run-sql-assessment-checks-in-azure-sql-mi-data-exposed/m-p/2202993#M1116 https://techcommunity.microsoft.com/t5/video-hub/how-to-run-sql-assessment-checks-in-azure-sql-mi-data-exposed/m-p/2202993#M1116 2021-03-11 17:46:30Z