Entries by admin

, ,

SQL Enlight 1.9.5.764

We are happy to announce that the next update of SQL Enlight is already here. Here is a summary of what’s new in version 1.9.5.764: Support for SQL Server 2014 – T-SQL syntax enhancements and new schema features Support for analyzing SQL Azure databases The Command line tool, NAnt and MSBuild tasks can now accept […]

,

CR0002: Avoid altering security within stored procedures

Message Avoid altering security within stored procedures Description The rule checks and alerts for usage of GRANT, REVOKE, or DENY statements within the body of a stored procedure. Avoid altering security within stored procedures, functions, and triggers. This can lead to unnecessary database calls, or it can hinder troubleshooting security permissions. Author Jeff Foushee Example […]

,

CR0001: TOP (100) PERCENT

Message TOP (100) PERCENT found Description This rule checks for the phrase “TOP (100) PERCENT”. This phrase has no bearing unless the percentage is less than 100. This phrase is commonly generated by creating a view in the SQL Server View Designer. Author Jeff Foushee Example SELECT TOP 100 PERCENT LastName, FirstName, JobTitle, Department FROM       HumanResources.vEmployeeDepartment ORDER BY LastName ASC