This article is contributed. See the original author and article here.
If you are curious about how to easily determine if your SQL is following best practices guidelines, you can watch the Data Exposed Live episode we did recently. We demo’ed SQL Assessment API and SQL Assessment Extension for Azure Data Studio (ADS).
If you prefer scripting, SQL Assessment API PowerShell cmdlets give you an easy and flexible way to do an assessment. If you prefer a GUI solution, you can use SQL Assessment Extension.
SQL Assessment API provides a mechanism to evaluate the configuration of your SQL Server, Azure SQL VMs, and Managed Instances for best practices. The API is delivered with a ruleset containing best practice rules suggested by SQL Server Team. The API is built with the intent to give a highly customizable and extensible solution. Users can tune the default rules and create their own. SQL Assessment extension for Azure Data Studio provides an interface for the API.
0:00 Show begins
3:05 SQL Assessment API Overview
6:30 Results of an assessment
11:38 Demo: SQL Assessment API
20:35 Try for yourself in Github
23:00 Demo: SQL Assessment Extension for ADS (for those who prefer a GUI solution rather than scripting with Powershell)
31:48 Demo: How to customize existing ruleset to fits your needs (Powershell and JSON)
50:00 Getting started
Some resources :
Rules and samples on GitHub – You can see all the rules in Defaultruleset csv file
Notebooks on GitHub – these have lots of examples on how to use the cmdlets
Please watch the video, look at the resources listed above, and try it out. You can use github issues on our repo (http://aka.ms/sql-assessment-api) to reach out to us with any feedback.
Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.