View Event: SQL Assessment – Microsoft’s Best Practices Checker
Do you want to get the current 313 suggested best practices from the SQL Server Team and evaluate your environments? These best practices are available for all instances, from your Data Center to the cloud.
In this demo session (Yes, no slides), I will show you both the “what” and “how” to use the SQL assessment API. How do you customize your checks and create rules that fit your environments? You will learn to identify a setting change after your initial review. The demo will use SQL assessment API, PowerShell cmdlets, and the new ‘SQL Assessment’ extension in Azure Data Studio to export assessment results in a SQL table and create an HTML report. I will show you how to configure “SQL best practices assessment configuration” in the Azure portal for SQL Server running on Azure VM.
At the end of this session, you will be equipped with the toolset to set up and run your assessment, create customized rules, and determine your compliance score against suggested best practices.
Leave a Reply