7 Generic TSQL Scripts to Troubleshoot SQL Performance Problems
"It's not a tool, which fixes a problem, but the fool using it!" (Jörg Stryk)
The M7 bunch of scripts should help the EXPERIENCED Troubleshooter to quickly identify bottlenecks
and to develop/implement appropriate solutions.
"With great power comes great responsibility" (Uncle Ben)
Model driven code generation can improve coding standards, speed, quality of development and reduce your costs. From my experience generating code from XML using XSLT is one of the best and fastest solutions.
This is just the base of the framework presenting the idea, any code template can be implemented upon request.
Some sample generators are present for SQL / PLSQL / C# / AnsiC / Java
The main target is to generate DTO/BDO/POJO objects based on the database definitions in...
ANY Database employing SQL, any system, any task
TRANSFORM Your SQL between DBMS, different languages and from slow SQL to fast one, transform any of Your redundant task to work in organized and sustainable manner.
This browser-based tool is a flexible solution for documenting both logical and physical database schema designs. It supports simple version tracking concepts to document schema changes in varying stages of planning and implementation.
FlashTestXpress is a tool to help on performing repeated tests of applications using Oracle as a database backend. Thus it can be used in regression testing scenarios.