Introducing the New SQL Assessment API For Microsoft SQL Server

Image of lines of code on a computer screen

VIAcode is happy to announce the public availability of the SQL Assessment API, a new extension of Microsoft SQL Server Management Objects (SMO) that allows SQL Server users to programmatically evaluate the configuration of SQL Server instances against a configurable set of rules.

The SQL Assessment API gives SQL Server users an easy-to-use tool for comparing the configuration of SQL Server instances with best practices and the policies of their organization. The SQL Assessment API is implemented both as an extension to SQL Server SMO and as a pair of new cmdlets in the SQL Server PowerShell module.

The SQL Assessment API supports all versions of SQL Server newer than SQL Server 2012, including both SQL on Windows and SQL on Linux. The API is available in the July 2019 release of both SQL Server Management Objects and the SQL Server PowerShell module.

Using The SQL Assessment API

The SQL Assessment API runs tests against SQL Server instances based on a set of rules or checks defined as objects in JSON files. These rules can be customized; users can add their own rules to implement custom checks, enable or disable rules and groups of rules, or adjust threshold parameters for rules that use a specific metric.

Microsoft provided a prewritten set of best-practice rules and has also made a comprehensive set of sample rules available on GitHub that can be used to guide the development of custom rulesets.

The API performs checks against SQL Server objects, including Server, Database, Filegroup, and AvailabilityGroup objects.

SQL Server users can run the tests against their SQL Server instances from PowerShell with a pair of cmdlets. ‌Get-SqlAssessmentItem provides a list of assessment checks for a specific SQL Server object. ‌Invoke-SqlAssessment runs the tests and returns the results of an assessment.

The included ruleset will test both Server and Database objects, producing a set of results and recommendations to help users conform with Microsoft’s recommended best practices. Users can schedule tasks to run periodic assessments against their SQL Server instances.

For full details of how to use the SQL Assessment API, visit Microsoft’s documentation page.

VIAcode and Microsoft SQL Server

Alex Andruschenko, software architect at VIACode, said, “Our developers are proud to work with the Microsoft SQL Server team to bring new monitoring solutions to SQL Server and other Microsoft software products. The SQL Assessment API is a valuable addition to SQL Server’s monitoring and assessment tools and will help many businesses to ensure that their database configurations conform to best practices.”

VIAcode provides a wide range of SQL Server and Microsoft Azure services, including free migration to Azure for users of SQL and Windows 2008. These platforms are reaching the end of their life, and Microsoft will stop supporting them soon.

VIAcode will migrate applications running on Windows 2008 and databases running on SQL Server 2008 to Azure for free. Contact our migration experts for a free initial consultation.

Read More

VIAcode Will Migrate Your Applications To Azure Cloud For Free

Pink clouds against an azure blue sky.

Does legacy IT infrastructure frustrate your efforts to grow and evolve business-critical applications? Are you paying too much for on-premises or colocated servers? Migrating to the Azure cloud will free your business from legacy infrastructure. With Azure, businesses iterate quickly, scale smoothly, and take control of infrastructure spending.

(more…)
Read More

Best Practices for Building a Cloud Migration Strategy

This article is the third in a series that focuses on Rehosting To Azure. In previous articles, we looked at The Benefits of [...] Read More

How a Cloud Migration Assessment Will Help Avoid Mistakes

Rehosting to Azure can bring incredible improvements to infrastructure agility, scalability, and performance, as we discussed in the previous article in this series [...] Read More

Why Cloud Migration: The Benefits of Rehosting to Azure

This is part 1 of our 4-part series on the benefits of cloud migration with Azure. Azure cloud migration is the transfer of [...] Read More

Microsoft Updates Version-Agnostic Management Pack For SQL Server With Support For SQL Server 2012-2016

Microsoft recently released updates to the version-agnostic management pack for SQL Server. The management pack was originally released in November 2017 and at [...] Read More

Bring SCOM Alert Rules to Azure Monitor with SCOM Alert Management by VIAcode

VIAcode is happy to announce the release of a new Azure Marketplace app that makes it easier for Azure users to integrate their [...] Read More

Application Performance Monitoring with Azure Application Insights, Azure Monitor and Azure Log Analytics

Azure Application Performance Monitoring provides a comprehensive array of telemetry, monitoring primitives, and domain-specific monitoring tools for all Azure services.

Read More

Application Performance Monitoring with Azure Application Insights, Azure Monitor and Azure Log Analytics

On September 20, VIAcode’s CEO Victor Mushkatin, one of the creators of Azure Application Insights, entrepreneur and cloud manageability visionary, hosted a webinar [...] Read More

Automate Infrastructure Deployment with Azure Resource Manager

Still no ARM? Manual deployment is like digging a pit with a shovel. Don’t miss the excavator! VIAcode DevOps technical brains, Alexey Baltikov [...] Read More
/*header menu botton*/