×

New England SQL Server User Group

Date/Time: Wednesday, September 8, 2021 18:30 to 20:30 EST
Location: Virtual

View Event: SQL Assessment – Microsoft’s Best Practices Checker

Do you want to get the current 204 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.

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

We have a really cool new feature! Now the system can automatically send calendar appointments to all accepted speakers,... so everybody can be sure they don't miss their slots, especially in virtual events where speakers are scattered around the globe.

#runhappy
@erinstellato @SQLBalls @SQLRockstar @wstrasser @SQLFlipFlopsDBA @heymiky @Kjonge @CPorteous @Transmokopter ... @landrews5807 @WidowPage @NickyvV @Ko_Ver @SQLEspresso @SqlWorldWide @mwdarab @bweissman

Do you use dbatools against Azure SQL Databases or Managed Instances? If so, what are some of the scenarios you're using... it for? ⛅️ What's missing that you'd like to see?

Load More...
/* (function () { var s = document.createElement('script'); s.type = 'text/javascript'; s.async = true; s.src = 'https://app.termly.io/embed.min.js'; s.id = '4f4146f3-eaa6-4e46-8f46-3fc9f2223b5f'; s.setAttribute("data-name", "termly-embed-banner"); var x = document.getElementsByTagName('script')[0]; x.parentNode.insertBefore(s, x); })(); */