| CARVIEW |
Select Language
HTTP/2 301
content-length: 0
cache-control: no-cache, no-store, must-revalidate
location: /sql-tools-enforce/
set-cookie: ASP.NET_SessionId=jwm0dylhtccyrew2yhshrgqu; path=/; secure; HttpOnly; SameSite=Lax
set-cookie: QSTLB=33373962.1.4271802240.3407880705; path=/; httponly;secure ;
x-aspnet-version: 4.0.30319
x-ua-compatible: IE=edge,chrome=1
x-frame-options: SAMEORIGIN
strict-transport-security: max-age=31536000; includeSubDomains; preload
x-content-type-options: nosniff
referrer-policy: strict-origin-when-cross-origin
content-security-policy: upgrade-insecure-requests;
x-permitted-cross-domain-policies: None
permissions-policy: camera=(), microphone=(), payment=()
date: Thu, 31 Jul 2025 03:43:11 GMT
x-cache: Miss from cloudfront
via: 1.1 9ef4ea79411a6ec653bbc06a680774b2.cloudfront.net (CloudFront)
x-amz-cf-pop: BOM54-P2
x-amz-cf-id: DiAUrZGIQpUU-I62go5FfBkgOBI7txERbp_2BKwGuY-5_lgdjWBoSg==
HTTP/2 200
content-type: text/html; charset=utf-8
cache-control: max-age=14400, s-maxage=86400
server:
x-aspnet-version: 4.0.30319
x-ua-compatible: IE=edge,chrome=1
x-frame-options: SAMEORIGIN
strict-transport-security: max-age=31536000; includeSubDomains; preload
x-content-type-options: nosniff
referrer-policy: strict-origin-when-cross-origin
content-security-policy: upgrade-insecure-requests;
x-permitted-cross-domain-policies: None
permissions-policy: camera=(), microphone=(), payment=()
date: Thu, 31 Jul 2025 03:43:12 GMT
content-encoding: gzip
vary: accept-encoding
x-cache: Miss from cloudfront
via: 1.1 9ef4ea79411a6ec653bbc06a680774b2.cloudfront.net (CloudFront)
x-amz-cf-pop: BOM54-P2
x-amz-cf-id: xwkMC2YMrJf6lYQ5Rz7s5vAK_Kqb9jgcq9VyjpvcNPR1ix5ThqsyyQ==
SQL code smells | ApexSQL
SQL code smells
09:58
![ApexSQL DevOps toolkit]()
This is the end
SQL code smells
ApexSQL Enforce is a SQL developer tool used to create, maintain and run a set of best practice code rules against a SQL server database or a SQL script. The process of executing rules can be set to run unattended via the command line interface. New rules can be written, or you can use the included set of pre-defined rules that can be updated and customized.
09:58
Benefits
-
Review databases and individual SQL scripts
-
Import and export rules
-
Process unattended via the CLI
-
Seamlessly integrate into your CI/CD process
-
Leverage a library of 100+ pre-written rules
-
Create custom rules with a built in IDE
-
Write custom rules in C# or VB.NET
-
Create HTML reports and XML exports
-
Integrate with SSMS and Visual Studio
-
Generate SQL to fix violations
Features
Enforce best practices
Process databases and scripts against more than 100 out-of-the-box rules
covering best practices, naming conventions, potential configuration and
performance problems and more
Create and manage rulebases
Create new/different rulebases by exporting and importing. Download updated rulebases directly from our website and import new rules into your existing rulebase
Create new rules
Create your own, custom rules using C# or VB.NET. Code rule conditions using auto-complete, syntax highlighting and all the other features you would expect in an integrated IDE
Manage rules
Edit, sort, filter, group and view rules within a grid based interface
Report and export results
Create XML reports and XML exports. Export all generated Fix SQL snippets into a single script to fix all detected problems
Process static scripts
Review and process stand-alone scripts aka static script analysis
Customize severity, impact score and failure thresholds
Customize severity level for rules and impact score for severities. Set custom thresholds for build failure
Categorize rules
Allocate rules to existing or custom categories i.e. security, performance, naming conventions within an existing rulebase
Programmatically construct Fix SQL statements
Enter static Fix SQL into the rule editor, or create it programmatically via the rule condition
Write rules down to the statement level
Our API exposes a script parse tree down to the sub-statement level like elements of a Where or Order by clause. This allows rules to be written to govern script level best practices like statement construction, use of triggers and cursors, variable naming and much more
Explore rulebases
View, select and run specific rules from various groups using the Rulebase explorer panel
View results
See a summary from a processed rulebase including summary and detail information
Visual themes
Customize the visual appearance with interface themes. Learn
more
Resources and support
Gallery
Related Topics
Testimonials
Clinical NetwoRx
I have worked for 18 yrs as a developer and for the past 5 yrs I have been an application manager, never have I seen a prompt response in my career. Worked with tons of products most of them not as good, but kudos to you man, you have got a great product and promising support.
Trenton D Souza Application Manager, Clinical NetwoRxConnected System Developer
Thanks for great products!
John Saunders Microsoft MVP, Connected System DeveloperApexSQL Enforce is part of the ApexSQL DevOps toolkit
Get started now
Improve SQL code smells with best coding practices reviews and enforcement.
Please wait...