What’s next in ApexSQL Enforce

We are excited to announce the imminent release of another new SQL Server developer tool, ApexSQL Enforce. ApexSQL Enforce is a coding, design and development review and enforcement tool for SQL Server.

It will ship with a comprehensive rule base of nearly 200 rules, that enforce such things as naming conventions, coding standards and general development best practices.

  1. Community – a sub-set of functionality for Azure SQL Database, Amazon RDS and SQL Express
  2. Standard – a sub-set of functionality for all editions of SQL Server
  3. Professional – a full set of functionality including CLI

The power of ApexSQL Enforce is that is parses script based objects and even standalone scripts at a deep level and can create an object model out of things like your code structure, that lets you write rules down to the line of code level. For example, you can set rules about what can or can’t exist in order by clauses.

Although we will offer a comprehensive rulebase, users can write their own rules in the .NET language of their choice, with a powerful internal rule editor against our meta data object model.
Results will be displayed in rich detail in the grid for further analysis (sorting, grouping, filtering) or exported to a report.

ApexSQL Enforce will be able to be deployed against single databases, stand alone scripts and soon, as an add-in to ApexSQL Source Control, so code can be validated, and approved or rejected, at the check-in level.

Existing customers of ApexSQL Developer and ApexSQL Universal, will get ApexSQL Enforce keys added for free to their bundle. Please contact service@apexsql.com to get your updated key(s) once the product is released.

This screen shows the main interface with the Best practices rule base loaded. The rulebase can been browsed via the rulebase explorer on the left and also a detailed grid on the right.

The rulebase grid supports grouping and a variety of functions from the context menu

The grid also supports column level filters

Once processed, the results will be displayed including fields like Result (Pass/Fail), Type (Column), Severity and Impact level

Scripts that exist in script based objects, like stored procedures, as well as standalone scripts can be parsed at a deep level for rule violations.

Rules exist as code in C#, VB.NET and PowerShell.NET and can leverage the full power of the .NET family of programming languages

Rules can include “Fix SQL” that can be run to correct the problem detected, violation raised

July 12, 2017