SQL Enlight 1.9.8.877

By Blog Author
#releases #sql-enlight-v1 #sql-enlight

We are happy to announce the release of SQL Enlight - 1.9.8.877.

The enhancements in this release are:

  • SQL Server 2017 RTM support
  • Added 14 new analysis rules
  • Fixed installer issue related with SQL Server Management Studio 17 integration
  • Fixed installer issue related with  with Visual Studio 2017 integration
  • Improvements in standard analysis rules

These are the newly added rules:

  • [SA0066B : Check all Columns for following specified naming convention.(Batch)]- https:/sqlenlight.com/help_19/html/960ca950-1553-498a-a8fd-8887824e4d17.htm)
  • [SA0067B : Check all Unique Key Constraints in the current database for following specified naming convention.(Batch)]- https:/sqlenlight.com/help_19/html/03d7e81c-9458-4cc9-846c-d5be495db81d.htm)
  • [SA0068B : Check all Check Constraints in the current sql script for following specified naming convention.(Batch)]- https:/sqlenlight.com/help_19/html/7b5fa36e-8162-4e12-801c-8bdc0a2b2013.htm)
  • [SA0069B : Check all Default Constraints in the current script for following specified naming convention.(Batch)]- https:/sqlenlight.com/help_19/html/b83eeffe-2f8c-4b17-8b5d-3bf184bf955b.htm)
  • [SA0070B : Check all Primary Key Constraints in the current sql script for following specified naming convention.(Batch)]- https:/sqlenlight.com/help_19/html/713d36d5-bf82-48da-9ae4-2dabf390647e.htm)
  • [SA0071B : Check all Foreign Key Constraints for following specified naming convention.(Batch)]- https:/sqlenlight.com/help_19/html/86dd25e5-6ee0-4064-8c1e-89cb0259bf48.htm)
  • [SA0072B : Check all Non-Key Index for following specified naming convention. (Batch)]- https:/sqlenlight.com/help_19/html/41ddf132-c05c-418f-a17f-4b63bf2436b0.htm)
  • [SA0073B : Check all User-Defined Types for following specified naming convention. (Batch)]- https:/sqlenlight.com/help_19/html/02bc2d8e-de13-4ec5-9a50-7f6e3d3ba89b.htm)
  • [SA0074B : Check all Schema-s for following specified naming convention. (Batch)]- https:/sqlenlight.com/help_19/html/303af93a-5004-4a01-80f4-ccf1bd878e6b.htm)
  • [SA0075B : Avoid adding constraints with default system generated name]- https:/sqlenlight.com/help_19/html/073a3040-cbba-4b30-aa73-f23721c7237a.htm)
  • [SA0165 : TOP (100) PERCENT found]- https:/sqlenlight.com/help_19/html/8769459a-5e67-45f8-a94f-c87f99e4ed25.htm)
  • [SA0166 : Avoid altering security within stored procedures]- https:/sqlenlight.com/help_19/html/58cf1ebb-41c7-4eec-8a3c-c043d3cf454a.htm)
  • [SA0167 : Non-ISO standard comparison operator found]- https:/sqlenlight.com/help_19/html/0cd4143e-d9a8-40b9-8f3f-a418de1d8439.htm)
  • [SA0168 : Possible division by zero not handled according the practice]- https:/sqlenlight.com/help_19/html/5b9bb13c-fd16-42dd-bbb8-cf315e85cab2.htm)
Back to Blog