SSW SQL Auditor

Testimonials

See what people think about this product SSW SQL Auditor is a valuable tool for SQL Server developers and .NET development companies. It's an easy method to improve database design and performance. It's a great example of how tools built on the .NET Framework can provide power and performance for the individual developer. See what people think about this product
- Terry Clancy, SQL Server Product Manager, Microsoft Australia http://www.microsoft.com/
 

Awards

Shareware River

Core Download

SQL Server CategorySql CodeAuditor

This is 'FxCop' for your SQL database - Keep your SQL Server 7/2000/2005/2008 database free from design flaws with SSW SQL Auditor - The best SQL database auditing and optimization tool!

Are you looking for a consistent and optimized SQL Server database? Maintaining consistent quality code across a large team can be a challenge. Even when standards are in place, developers can make mistakes that will slip through Quality Assurance. SQL Auditor is a part of the range of database tools designed by SSW to help to check best practice standards and optimize SQL Server performance. SSW SQL Auditor supports SQL Server 7/2000/2005/2008.

SSW SQL Auditor not only reports on design issues and areas where SQL performance could be improved, it also has wizards that generate SQL scripts to correct common problems. It was developed to assist in performance tuning in SQL Server 7/2000/2005/2008 by performing a SQL Server audits on your database. It allows Developers to check their database design against common SQL Server design rules and report on the elements that do not conform to those rules.

If you are looking for a DB Auditing Tool that can perform a SQL database audit and assist with SQL Server performance tuning, download a trial of SSW SQL Auditor today.


Key Features and Benefits

SSW SQL Auditor is a solution that will globally change the data structure in a database or range of tables.

By using SSW SQL Auditor's simple wizard interface you can:

screen shot Great, user-friendly wizard style interface With our standards compliant user interface.
Partial Screen shot 2 Comprehensive rules to keep your database healthy Learn from the many SQL Rules.
Enable or disable the rules, and learn from the community of SQL developers which rules are popular and which convention is popular - see Rule Agreement Report
Partial Screen Shot 3 Customizable rules There is a detailed options form which helps you customize rules checking.

Partial Screen Shot 4 Automatically generates report of the violations for your database You can get detailed reports of all the violations by a simple click.
Partial Screen Shot 5 Automatically generates scripts SSW SQL Auditor will automatically generate scripts to correct most of the violations.

Partial Screen Shot 6 Wide-ranging wizards, easy to use There are 6 different wizards in SQL Auditor now, and there will be more in future, these wizards will guide you to complete some complicated tasks: e.g. adding foreign key relationships, adding clustered indexes or adding LastModified columns for appropriate tables.


More Technical Features include the ability to:

See more screenshots in the SQL Auditor User Guide.


Upcoming Features


How it Works

SSW SQL Auditor allows Developers to check their database design against common SQL Server design rules and report on the elements that do not conform to those rules.

SSW SQL Auditor not only reports on design issues and areas where SQL performance could be improved, it also has wizards that generate SQL scripts to correct common problems.


Predefined Rules - these are examples of the rules you use

General

  1. Object names should not contain spaces. See Object name should follow your company Naming Conventions.
  2. Database collation differs from SQL Server collation (server-wide check). See Do you make sure you use a consistent Collation server-wide?
  3. Usage of SQL Server reserved words. See Object name should follow your company Naming Conventions.

Data Structure

  1. Columns using the Unicode data type of nchar, nvarchar or ntext. See Only use Unicode datatypes (nchar, nvarchar and ntext) in special circumstances.
  2. Columns using datetime datatype when data could be stored in a smalldatetime column. See Use smalldatetime datatype, where possible, instead of datetime datatype.
  3. Columns using bit datatype and allowing NULL values. See Do you use Bit/Numeric data type correctly?
  4. Columns with RowGuid datatype and an Index. See Do not use indexes on RowGuid column.
  5. Tables missing Clustered Index. See Do you create clustered index on your tables?
  6. Every table should have Primary Key. See Do you create primary key on your tables?
  7. Tables missing Timestamp Column (configure Timestamp column name in the Timestamp Wizard). See Do you create primary key on your tables?
  8. Tables missing "Standard Columns" (user defined columns that all tables should have). It is definable in Tools -> Options
  9. Maximum row size for a table larger than SQL Server data page size (8060 bytes). See Maximum row size for a table.
  10. Table names longer than 24 characters. See Object name should follow your company Naming Conventions.
  11. Columns using bit datatype. Recommended to use smallint instead. See Do you use Bit/Numeric data type correctly?
  12. Indexes and constraints without a fill factor of 90%. See Use FillFactor of 90% for indexes and constraints.

Relationships

  1. Relationships not using ON UPDATE CASCADE. See Use ON UPDATE CASCADE clause when creating relationship.
  2. Relationships using ON DELETE CASCADE. See Do not use ON DELETE CASCADE clause when creating relationship.
  3. Relationships not using NOT FOR REPLICATION. See Use NOT FOR REPLICATION clause when creating relationship.

Data

  1. Data in character type columns having empty line (<Ctrl> + <Enter>) as the first character
  2. Data in character columns having empty string instead of NULL. See Don't allow Nulls in text fields.
  3. Data that violates referential integrity

Stored Procedures

  1. Stored procedures and Views with unsynchronized names in procedure/view definition and object name.
  2. Stored procedures missing "Standard Stored Procedure Description" (configure in Tools>Options)
  3. User-defined stored procedures starting with "sp_" or "dt_"

Sample Reports

The Database Optimization Report lists areas of the database that may be changed to improve SQL performance. It shows summary of violations for each rule database is checked against.  Here is a sample report:

PDF file Standard Report

System Requirements

PS: It is always recommended you can get all green ticks with SSW Diagnostics - the free utility to check you have all software patches

What does the unregistered version give me?

In respect to the unregistered version we know you want to see it working before you buy it. We aim for that.
Note: we also give free version targeted to the little guys
More details see http://www.ssw.com.au/ssw/KB/KB.aspx?KBID=Q658302

SSW provides free phone and email support to answer queries on registered products.


Getting Support

If you can't find it in the product documentation then check our knowledge base for further information and tips about this product.

Please send us bug reports and feedback so that we can evolve our software into a product that matches your requirements. We guarantee a response.


Links

 


I'm Sold... What's next?

Purchase Full Version
or

Download Free Trial Version
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.