DB Assessor

Best practices evaluation and implementation for Microsoft SQL Server databases.


Select the version that provides you with the functionality you need. The following table shows a feature matrix:



FeatureTrialStandardDeveloper
Database Assessment
HTML Reporting
Knowledge Base Access
Script Generation
Configured Scan Scripts
Semi-Automatic Update
Rules SDK


Revision History

  • 1.0.0.0 - 29-Jun-2008
    • Developers Edition documentation finished
  • 0.9.9.0 - 1-Jun-2008
    • Created EULA document and placed it in the setup
    • Made some minor stored procedure parsing bug fixes
  • 0.9.5.0 - 22-May-2008 PRE-RELEASE
    • Initial publishing at www.AcuteDevTools.com
  • 0.9.0.0 - 2-May-2008 PRE-RELEASE
    • Created DBDom
    • Created Tests, Issues, and Fixes
    • Created initial SQL Server scans
    • Created basic reporting

Database Assessment

DB Assessor scans your database, looking for best practices in areas like table design and key references. It then provides you with a list of concerns that you can filter by severity.


HTML Reporting

Once a list of concerns is generated, you can export the list to a simple HTML document for review.


Knowledge Base Access

Registered members get access to a SQL knowledge base.


Script Generation

Some issues can generate script for you that will fix the issue. You can save the script and review it before executing it in your database management console of choice.


Configured Scan Scripts

With the SQL strings used for scanning your database placed in configuration, you can change them to add filters or simply read through them to see exactly what the scans read.


Semi-Automatic Updates

Check for updates and automatically install them on startup .


Rules SDK

Don't see the rule you want/need? Code your own! Read the provided documentation and use the development library to create your specific rules and execute them in the Assessment Engine as if they were native.



How it works

After opening a connection to the database, DB Assessor loads and parses the database schema and performs several tests on the resulting DOM.
Issues, details, and a fix.
 
Select the issues to fix, and generate the scripts for them. Multiple issues can be fixed at once. Once the script is generated, it can be previewed and saved for execution against the database.
Fix script ready to save

Pricing

Trial Version
FREE

TRIAL VERSION

Assess your database and generate reports

Standard Version
ONLY
$45.99

STANDARD VERSION

Generate fixes and deploy change scripts

Developer Version
ONLY
$95.99

DEVELOPER VERSION

Create rules and deploy updates