Majestic view of Sky before rain: Near Nandi Hills Bangalore

SQL Analyzer - Part II

To my previous post on SQL Analyzer tool, here are the sample screens of the tool

Tool allows user to select file either from file directory or copy past the script.   And user has option to select rules required to be run against the script.

On analyzing the script the tool will display the number of errors and warning on the script. Errors are to be mandatory fixed whereas warnings are nice to fix,  The tool also displays the recommendations on each error or warning for correction.  For usability and easy tracking of the error, tool displays the line number and also highlights the line with red color text. 

Keep looking for this space for more updates on the tool ....

Tool based MS SQL Script review for Performance, Design and Naming rules

Do you have a store procedure which is running longer duration than expected? Do you have a database with performance issues? Are you not sure whether script written is in line with Microsoft best practices ?

Here is the answer , SQL Analyzer tool from HappiestMinds will analyze the sql script for Microsoft best practices and also identifies queries which will have performance issues and provide you the recommendation.  The tool can be launched from the mutliple channels such as Visual studio, console, web, windows application.

Tool has 65 rules built in based on Microsoft best practices and also from experience of team.  Rules are spread across performance, design and naming convention.

Tool is extremely helpful if you are DBA and managing Production database, it will do review of the script against the rules and provide you the report to deciede for production release.  As a DBA you can also define custom rules which needs to be validated for every script release or you can choose to run only required rules for every script release.