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

From the creator

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. 0:00 Introduction 1:23 Intro to SQL Assessment checks 2:19 Demo: SQL Assessment checks 9:08 Getting started ✔️Resources: SQL Server Samples: https://github.com/microsoft/sql-server-samples/tree/master/samples/manage/sql-assessment-api?WT.mc_id=dataexposed-c9-niner 📌 Let's connect: Twitter: Aaron Nelson, https://twitter.com/SQLvariant Twitter: Anna Hoffman, https://twitter.com/AnalyticAnna Twitter: AzureSQL, https://aka.ms/azuresqltw 🔴 To check out even more Data Exposed episodes, see our playlist: https://aka.ms/dataexposedyt 🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt Microsoft Developer: https://aka.ms/microsoftdeve

Published 2021-03-11 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.