Watch and learn about SQL Assessment API and SQL Assessment Extension

Published Feb 23 2021 03:16 AM 2,430 Views
Microsoft

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).

Best Practices Assessment for Azure SQL VMs, Managed Instances, and SQL Servers | Data Exposed Live ...

 

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. 

 

SQLAssessment.png

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

1:16​ Introductions

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

53:40​ Q&A

 

Some resources :

Docs online page

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

SQL Assessment Extension public preview blog post

 

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.

 

%3CLINGO-SUB%20id%3D%22lingo-sub-2158682%22%20slang%3D%22en-US%22%3EWatch%20and%20learn%20about%20SQL%20Assessment%20API%20and%20SQL%20Assessment%20Extension%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2158682%22%20slang%3D%22en-US%22%3E%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%3CFONT%20size%3D%224%22%3EIf%20you%20are%20curious%20about%20how%20to%20easily%20determine%20if%20your%20SQL%20is%20following%20best%20practices%20guidelines%2C%20you%20can%20watch%20the%26nbsp%3BData%20Exposed%20Live%20episode%20we%20did%20recently.%20We%20demo'ed%20SQL%20Assessment%20API%20and%20SQL%20Assessment%20Extension%20for%20Azure%20Data%20Studio%20(ADS).%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%3CFONT%20size%3D%224%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DiJvkVhV93ag%26amp%3Bfeature%3Demb_logo%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%3CSPAN%20style%3D%22font-family%3A%20'Segoe%20UI'%3B%20font-size%3A%2010.5pt%3B%22%3EBest%20Practices%20Assessment%20for%20Azure%20SQL%20VMs%2C%20Managed%20Instances%2C%20and%20SQL%20Servers%20%7C%20Data%20Exposed%20Live%20-%20YouTube%3C%2FSPAN%3E%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%3CFONT%20size%3D%224%22%3EIf%20you%20prefer%20scripting%2C%20SQL%20Assessment%20API%20PowerShell%20cmdlets%20give%20you%20an%20easy%20and%20flexible%20way%20to%20do%20an%20assessment.%20If%20you%20prefer%20a%20GUI%20solution%2C%20you%20can%20use%20SQL%20Assessment%20Extension.%26nbsp%3B%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%3CFONT%20size%3D%224%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SQLAssessment.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F256978i17B1F0C874ECDE89%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22SQLAssessment.png%22%20alt%3D%22SQLAssessment.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3ESQL%20Assessment%20API%20provides%20a%20mechanism%20to%20evaluate%20the%20configuration%20of%20your%20SQL%20Server%2C%20Azure%20SQL%20VMs%2C%20and%20Managed%20Instances%20for%20best%20practices.%20The%20API%20is%20delivered%20with%20a%20ruleset%20containing%20best%20practice%20rules%20suggested%20by%20SQL%20Server%20Team.%20The%20API%20is%20built%20with%20the%20intent%20to%20give%20a%20highly%20customizable%20and%20extensible%20solution.%20Users%20can%20tune%20the%20default%20rules%20and%20create%20their%20own.%20SQL%20Assessment%20extension%20for%20Azure%20Data%20Studio%20provides%20an%20interface%20for%20the%20API.%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DiJvkVhV93ag%26amp%3Blist%3DPL3EZ3A8mHh0zShlR5z5n3r0HWHdx7pr3m%26amp%3Bindex%3D1%26amp%3Bt%3D0s%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E0%3A00%3C%2FA%3E%20Show%20begins%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DiJvkVhV93ag%26amp%3Blist%3DPL3EZ3A8mHh0zShlR5z5n3r0HWHdx7pr3m%26amp%3Bindex%3D1%26amp%3Bt%3D76s%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E1%3A16%3C%2FA%3E%20Introductions%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DiJvkVhV93ag%26amp%3Blist%3DPL3EZ3A8mHh0zShlR5z5n3r0HWHdx7pr3m%26amp%3Bindex%3D1%26amp%3Bt%3D185s%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E3%3A05%3C%2FA%3E%20SQL%20Assessment%20API%20Overview%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DiJvkVhV93ag%26amp%3Blist%3DPL3EZ3A8mHh0zShlR5z5n3r0HWHdx7pr3m%26amp%3Bindex%3D1%26amp%3Bt%3D390s%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E6%3A30%3C%2FA%3E%20Results%20of%20an%20assessment%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DiJvkVhV93ag%26amp%3Blist%3DPL3EZ3A8mHh0zShlR5z5n3r0HWHdx7pr3m%26amp%3Bindex%3D1%26amp%3Bt%3D698s%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E11%3A38%3C%2FA%3E%20Demo%3A%20SQL%20Assessment%20API%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DiJvkVhV93ag%26amp%3Blist%3DPL3EZ3A8mHh0zShlR5z5n3r0HWHdx7pr3m%26amp%3Bindex%3D1%26amp%3Bt%3D1235s%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E20%3A35%3C%2FA%3E%20Try%20for%20yourself%20in%20Github%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DiJvkVhV93ag%26amp%3Blist%3DPL3EZ3A8mHh0zShlR5z5n3r0HWHdx7pr3m%26amp%3Bindex%3D1%26amp%3Bt%3D1380s%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E23%3A00%3C%2FA%3E%20Demo%3A%20SQL%20Assessment%20Extension%20for%20ADS%20(for%20those%20who%20prefer%20a%20GUI%20solution%20rather%20than%20scripting%20with%20Powershell)%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DiJvkVhV93ag%26amp%3Blist%3DPL3EZ3A8mHh0zShlR5z5n3r0HWHdx7pr3m%26amp%3Bindex%3D1%26amp%3Bt%3D1908s%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E31%3A48%3C%2FA%3E%20Demo%3A%20How%20to%20customize%20existing%20ruleset%20to%20fits%20your%20needs%20(Powershell%20and%20JSON)%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DiJvkVhV93ag%26amp%3Blist%3DPL3EZ3A8mHh0zShlR5z5n3r0HWHdx7pr3m%26amp%3Bindex%3D1%26amp%3Bt%3D3000s%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E50%3A00%3C%2FA%3E%20Getting%20started%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DiJvkVhV93ag%26amp%3Blist%3DPL3EZ3A8mHh0zShlR5z5n3r0HWHdx7pr3m%26amp%3Bindex%3D1%26amp%3Bt%3D3220s%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E53%3A40%3C%2FA%3E%20Q%26amp%3BA%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3ESome%20resources%20%3A%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fsql-assessment-api%2Fsql-assessment-api-overview%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EDocs%20online%20page%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3E%3CA%20href%3D%22http%3A%2F%2Faka.ms%2Fsql-assessment-api%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ERules%20and%20samples%20on%20GitHub%3C%2FA%3E%20-%20You%20can%20see%20all%20the%20rules%20in%20Defaultruleset%20csv%20file%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fsql-server-samples%2Ftree%2Fmaster%2Fsamples%2Fmanage%2Fsql-assessment-api%2Fnotebooks%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ENotebooks%3C%2FA%3E%20on%20GitHub%20-%20these%20have%20lots%20of%20examples%20on%20how%20to%20use%20the%20cmdlets%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fsql-server%2Freleased-sql-server-assessment-extension-for-azure-data-studio%2Fba-p%2F1470603%22%20target%3D%22_blank%22%3ESQL%20Assessment%20Extension%20public%20preview%20blog%20post%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3EPlease%20watch%20the%20video%2C%20look%20at%20the%20resources%20listed%20above%2C%20and%20try%20it%20out.%20You%20can%20use%20github%20issues%20on%20our%20repo%20(%3CA%20href%3D%22http%3A%2F%2Faka.ms%2Fsql-assessment-api%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttp%3A%2F%2Faka.ms%2Fsql-assessment-api%3C%2FA%3E)%20to%20reach%20out%20to%20us%20with%20any%20feedback.%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2158682%22%20slang%3D%22en-US%22%3E%3CP%3E%3CFONT%20size%3D%224%22%3EIf%20you%20are%20curious%20about%20how%20to%20easily%20determine%20if%20your%20SQL%20is%20following%20best%20practices%20guidelines%2C%20you%20can%20watch%20the%26nbsp%3BData%20Exposed%20Live%20episode%20we%20did%20recently.%20We%20demo'ed%20SQL%20Assessment%20API%20and%20SQL%20Assessment%20Extension%20for%20Azure%20Data%20Studio%20(ADS).%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2158682%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQLServerTiger%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Co-Authors
Version history
Last update:
‎Feb 23 2021 03:16 AM
Updated by: