![]() |
VOOZH | about |
dotnet add package Microsoft.SqlServer.Assessment --version 1.1.17
NuGet\Install-Package Microsoft.SqlServer.Assessment -Version 1.1.17
<PackageReference Include="Microsoft.SqlServer.Assessment" Version="1.1.17" />
<PackageVersion Include="Microsoft.SqlServer.Assessment" Version="1.1.17" />Directory.Packages.props
<PackageReference Include="Microsoft.SqlServer.Assessment" />Project file
paket add Microsoft.SqlServer.Assessment --version 1.1.17
#r "nuget: Microsoft.SqlServer.Assessment, 1.1.17"
#:package Microsoft.SqlServer.Assessment@1.1.17
#addin nuget:?package=Microsoft.SqlServer.Assessment&version=1.1.17Install as a Cake Addin
#tool nuget:?package=Microsoft.SqlServer.Assessment&version=1.1.17Install as a Cake Tool
SQL Assessment API provides a mechanism to evaluate the configuration of your SQL Server for best practices. The API is delivered with a ruleset containing best practice rules suggested by SQL Server Team. This ruleset is enhancing with the release of new versions but at the same time, the API is built with the intent to give a highly customizable and extensible solution. So, users can tune the default rules and create their own ones. The API can be used to assess SQL Server versions 2012 and higher and Azure SQL Database Managed Instance (more to come).
Learn more about the API on the SQL Assessment API docs page.
Try the sample SqlAssessmentClient application out.
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net5.0 net5.0 was computed. net5.0-windows net5.0-windows was computed. net6.0 net6.0 was computed. net6.0-android net6.0-android was computed. net6.0-ios net6.0-ios was computed. net6.0-maccatalyst net6.0-maccatalyst was computed. net6.0-macos net6.0-macos was computed. net6.0-tvos net6.0-tvos was computed. net6.0-windows net6.0-windows was computed. net7.0 net7.0 was computed. net7.0-android net7.0-android was computed. net7.0-ios net7.0-ios was computed. net7.0-maccatalyst net7.0-maccatalyst was computed. net7.0-macos net7.0-macos was computed. net7.0-tvos net7.0-tvos was computed. net7.0-windows net7.0-windows was computed. net8.0 net8.0 was computed. net8.0-android net8.0-android was computed. net8.0-browser net8.0-browser was computed. net8.0-ios net8.0-ios was computed. net8.0-maccatalyst net8.0-maccatalyst was computed. net8.0-macos net8.0-macos was computed. net8.0-tvos net8.0-tvos was computed. net8.0-windows net8.0-windows was computed. net9.0 net9.0 was computed. net9.0-android net9.0-android was computed. net9.0-browser net9.0-browser was computed. net9.0-ios net9.0-ios was computed. net9.0-maccatalyst net9.0-maccatalyst was computed. net9.0-macos net9.0-macos was computed. net9.0-tvos net9.0-tvos was computed. net9.0-windows net9.0-windows was computed. net10.0 net10.0 was computed. net10.0-android net10.0-android was computed. net10.0-browser net10.0-browser was computed. net10.0-ios net10.0-ios was computed. net10.0-maccatalyst net10.0-maccatalyst was computed. net10.0-macos net10.0-macos was computed. net10.0-tvos net10.0-tvos was computed. net10.0-windows net10.0-windows was computed. |
| .NET Core | netcoreapp2.0 netcoreapp2.0 was computed. netcoreapp2.1 netcoreapp2.1 was computed. netcoreapp2.2 netcoreapp2.2 was computed. netcoreapp3.0 netcoreapp3.0 was computed. netcoreapp3.1 netcoreapp3.1 was computed. |
| .NET Standard | netstandard2.0 netstandard2.0 is compatible. netstandard2.1 netstandard2.1 was computed. |
| .NET Framework | net451 net451 is compatible. net452 net452 was computed. net46 net46 was computed. net461 net461 was computed. net462 net462 is compatible. net463 net463 was computed. net47 net47 was computed. net471 net471 was computed. net472 net472 was computed. net48 net48 was computed. net481 net481 was computed. |
| MonoAndroid | monoandroid monoandroid was computed. |
| MonoMac | monomac monomac was computed. |
| MonoTouch | monotouch monotouch was computed. |
| Tizen | tizen40 tizen40 was computed. tizen60 tizen60 was computed. |
| Xamarin.iOS | xamarinios xamarinios was computed. |
| Xamarin.Mac | xamarinmac xamarinmac was computed. |
| Xamarin.TVOS | xamarintvos xamarintvos was computed. |
| Xamarin.WatchOS | xamarinwatchos xamarinwatchos was computed. |
Showing the top 5 NuGet packages that depend on Microsoft.SqlServer.Assessment:
| Package | Downloads |
|---|---|
|
Microsoft.SqlServer.SqlManagementObjects.SSMS
The SQL Server Management Objects (SMO) Framework is a set of objects designed for programmatic management of Microsoft SQL Server and Microsoft Azure SQL Database. |
|
|
Microsoft.SqlServer.Management.Assessment
Implements SQL Management Object-based wrappers for the Microsoft.SqlServer.Assessment APIs |
|
|
Microsoft.SqlServer.Assessment.DataSources
The SQL Assessment API provides a mechanism to evaluate whether the configuration of your SQL Server conforms to the best practices. The package contains auxiliary classes that can be used as alternative data sources for the API. These data sources provide Azure instance metadata and data from the WMI and Windows registry. |
|
|
Microsoft.SqlServer.Migration.SqlTargetProvisioning
Nuget package for Azure SQL Target Provisioning |
|
|
DatabaseJobs.Shared
Summary of changes made in this release of the package. |
Showing the top 3 popular GitHub repositories that depend on Microsoft.SqlServer.Assessment:
| Repository | Stars |
|---|---|
|
microsoft/sqltoolsservice
SQL Tools API service that provides SQL Server data management capabilities.
|
|
|
trimble-oss/dba-dash
DBA Dash - SQL Server Monitoring Tool
|
|
|
microsoft/sqlmanagementobjects
Sql Management Objects, an API for scripting and managing SQL Server and Azure SQL Database
|
| Version | Downloads | Last Updated |
|---|---|---|
| 1.1.17 | 640,553 | 12/20/2022 |
| 1.1.15-preview | 1,109 | 12/19/2022 |
| 1.1.9 | 13,980,710 | 7/7/2022 |
| 1.1.9-preview | 1,298 | 7/5/2022 |
| 1.1.5 | 41,092 | 2/25/2022 |
| 1.1.4 | 2,715 | 2/24/2022 |
| 1.1.0 | 68,288 | 12/30/2021 |
| 1.0.305 | 3,706,997 | 3/10/2021 |
| 1.0.305-preview | 1,331 | 3/10/2021 |
| 1.0.304 | 5,151 | 2/26/2021 |
| 1.0.304-preview | 1,264 | 2/26/2021 |
| 1.0.303-preview | 1,309 | 2/25/2021 |
| 1.0.302 | 53,007 | 12/30/2020 |
| 1.0.299-preview | 1,428 | 12/27/2020 |
| 1.0.280 | 3,189,723 | 10/12/2020 |
| 1.0.280-preview | 2,171 | 10/6/2020 |