×

Data Platform Meetup Israel

Date/Time: Wednesday, September 7, 2022 13:30 to 15:00 GMT
Location: Virtual

View Event: Microsoft’s Best Practices Checker

Do you want to get more than 200 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), we will explore both the “what” and “how” to use the SQL assessment API. How to customize your checks and create your own 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 to a SQL table and create an HTML report. We will learn 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

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.



profile for SqlWorldWide on Stack Exchange, a network of free, community-driven Q&A sites

Kubernetes Learning Path

50-days from zero to
hero with Kubernetes

Download eBook

Lot's of actions to take. One simple one is sign the petition to demand Congress codify Roe and Expand the Court. ...#RoeVWade

https://www.demandjusticeprotectroe.com/?utm_source=exc_TW&utm_campaign=8398c460

Load More...