SESSION Details

SQL Assessment - Microsoft's Best Practices Checker

Do you want to get the current 232 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 all demo session (Yes, no slides), I will show you both the "what" and "how" to use the SQL assessment API. You will learn if a setting is changed after your initial check. How to customize your checks and create your own rules that fit your environments? 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.

At the end of this session, you will be equipped with the toolset to set up and run your own assessment, create customized rules, and determine your compliance score against suggested best practices.

Feedback link: https://sqlb.it/?7017

Starts: 13:20 12th Mar 2022
Ends: 14:10 12th Mar 2022

Q&As

Short Description
- Do you want to get the current 232 suggested best practices from the Microsoft SQL Server Team and evaluate your environments? In this all demo session (Yes, no slides), I will show you both the "what" and "how" to do the same using the SQL assessment API and Azure Data Studio 'SQL Assessment' extension.

Slidedeck Link

SQL Assessment – Microsoft’s Best Practices Checker.txt

Speakers

Taiob Ali

Tags

AzureOn PremisesOperational DatabasesManagingMonitoringOptimisingSecurityAzure SQL DatabaseDatabase EngineManaged InstanceSQL 2019BeginnerHow