azuredatastudio/extensions/sql-assessment
dependabot[bot] 32421b9a51
Bump semver from 6.3.0 to 6.3.1 in /extensions/sql-assessment (#23764)
Bumps [semver](https://github.com/npm/node-semver) from 6.3.0 to 6.3.1.
- [Release notes](https://github.com/npm/node-semver/releases)
- [Changelog](https://github.com/npm/node-semver/blob/v6.3.1/CHANGELOG.md)
- [Commits](https://github.com/npm/node-semver/compare/v6.3.0...v6.3.1)

---
updated-dependencies:
- dependency-name: semver
  dependency-type: indirect
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2023-07-12 10:29:02 -07:00
..
images Assessment core extension (#10154) 2020-05-29 01:17:41 +03:00
resources Sql-Assessment api info button (#13490) 2020-11-20 20:53:34 +03:00
src Add mssql.proposed.d.ts (#23394) 2023-06-15 16:29:20 -07:00
.eslintrc.json Enable no-unsafe-assignments for MSSQL (#23407) 2023-06-18 10:01:41 -07:00
.gitignore Webpack Extensions update (#15919) 2021-07-01 09:56:55 -07:00
.vscodeignore Webpack Extensions update (#15919) 2021-07-01 09:56:55 -07:00
README.md Update privacy documentation (#22520) 2023-03-29 15:40:01 -07:00
extension.webpack.config.js Webpack Extensions update (#15919) 2021-07-01 09:56:55 -07:00
package.json Update ads-extension-telemetry to 3.0.1 (#22374) 2023-03-20 12:48:31 -07:00
package.nls.json SQL Assessment display name and description update (#11253) 2020-07-08 14:40:39 -07:00
tsconfig.json Merge from vscode a348d103d1 (#15681) 2021-06-17 08:17:11 -07:00
yarn.lock Bump semver from 6.3.0 to 6.3.1 in /extensions/sql-assessment (#23764) 2023-07-12 10:29:02 -07:00

README.md

SQL Assessment (preview)

SQL Assessment for Azure Data Studio provides a mechanism to evaluate the configuration of SQL Server for best practices. It uses SQL Assessment API to achieve this. With this preview version, you can:

  • Assess a SQL Server or Azure SQL Managed Instance and its databases with built-in rules (Invoke Assessment)
  • Get a list of all built-in rules applicable to an instance and its databases (View applicable rules)
  • Export assessment results and the list of applicable rules as a script to store it in a SQL table (Export as script)
  • Create HTML reports on assessments results (Create HTML Report)

SqlAssessmentPic

How do I start SQL Assessment?

After you install the SQL Assessment extension, open the list with your servers, right-click a server or database that you want to assess and select Manage. Then, in the General section, select SQL Assessment. On the Assessment tab, click Invoke Assessment to perform assessment of the selected SQL Server or SQL Database. Once the results are available, you can use the filtering and sorting features. Click Export as Script to get the results in an insert-into-table format. You can also click Create HTML Report to save the assessment results as an HTML file. Some assessment rules are intended for particular SQL Server configurations and some for others. The same is true for database rules. For example, there are rules that are applicable only to SQL Server 2016 or the tempdb database. The View applicable rules button displays the assessment rules that are used to perform assessment of your servers and databases after you click Invoke Assessment. To view information about SQL Server and SQL Assessment API, click Info. Assessment session results can be reviewed on the History tab.

Code of Conduct

This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact opencode@microsoft.com with any additional questions or comments.

Telemetry

This extension collects telemetry data, which is used to help understand how to improve the product. For example, this usage data helps to debug issues, such as slow start-up times, and to prioritize new features. While we appreciate the insights this data provides, we also know that not everyone wants to send usage data and you can disable telemetry as described in the Azure Data Studio disable telemetry reporting documentation.

Privacy Statement

To learn more about our Privacy Statement visit this link.

License

Copyright (c) Microsoft Corporation. All rights reserved.

Licensed under the Source EULA.