Last few posts we looked into SQL Server Free tools. In this post we will look at SQLCop. Auditing your database for SQL Server Best practices. Pretty simple to use and powerful tool, Let's get started.
Step 1. Download SQLCop from link
Step 2. Install the tool
Step 3. Provide database name, server name to connect. Snapshot provided below
Step 4. You would see results displayed. Red is violation of best practice, Also suggested solution for the same is displayed.
Step 5. Range of issue that is detected / analyzed by the tool are provided in link. Detected Issues
Step 6. I have not checked on SQL Best Practices Analyzer. I need to give it a try to compare both the tools.
Awesome tool, easy installation and very useful results along with suggestions for fixing identified issues.
More Reads - Custom SQL Stored Procedure Best Practices Analyzer - SQL Cop, Maybe?
Visual Studio Database Edition 2010 – Static Code Analysis Review (Part 1)
Visual Studio Database Edition 2010 – Static Code Analysis Review (Part 2)
Happy Reading!!!
June 24, 2011
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment