SQL Server Documentation Complete Transparency

Ever heard about CODE metadata? You already have metadata on objects and structures - we have uncovered the complexity of code to enable "Complete Automatic Transparency" for SQL Server!

o Determining LOE hours

o Getting new developers up-to-speed in half the time

o Documenting numerous aspects of your projects

Some of the features include:

o A step-by-step English language translation of what the code is doing

o A graphical depiction of how data moves through the code

o Precise detail of code dependencies for rapid impact analysis

o High quality documentation that can be used as project artifacts

Overview of the Source Code Unscrambler Automation:

Over the life of any software or project, developer positions open up through increased need or by attrition. Regardless, bringing new developers up to speed (“on boarding”) is a real COST issue which requires the new hires learning the process, the people and, most importantly, the code.

Understanding the code is clearly the most time-consuming of these tasks and typically can take weeks/months and, depending on the size of the code base, could take much longer. Anything that can help shorten that process, get the developers writing code, and being productive is a major cost savings to any organization.

As IBM Technical Validated Partners and for the first time in the Industry, GenesisOne has created a flagship tool, called the “Unscrambler”, for turning SQL Server code into diagrams, data tables and explanations. Instead of spending weeks/months learning the code, developers can spend a few days reviewing the output. Employees always need time for training once brought on board, but the real value comes from those developers being productive. The Unscrambler does just that.

As described by our customers, here are some of the Cost Savings benefits and features provided by the Unscrambler:

• Unscrambler saved me hours, and in some cases, even days of manually printing out and tracing code, in order to understand what some of the old legacy procedures were doing -BEFORE we could even start working on the new requirements.
• A Business Process owner can easily follow the Unscrambler Data Flow chart to help guide Developers when upgrading old procedures.
• The Unscrambler Dependency Diagram makes it easy for me to get the ‘big picture’ of how all the parts fit together before I start digging into the actual code. I can click on any dependent object to quickly jump into its’ code.
• Ability to standardize code documentation with zero effort.
• GenesisOne? enables your ability to browse database structures. The structures shown depends on the database, the minimum level of detail includes Stored Procedures, tables, indexes and constraints as well as displaying information such as column names, column data types, column lengths, column null ability, and primary and foreign key information.
• Rich set of output format (PDF, PNG, SVG).
• Display graphical view for object relations.
• It is easily understandable by non-developers.
• Display summary view for stored procedure and function analysis.
• Create time based snapshot of your Database objects.
• Keep your documentation up-to-date and in-sync with your development.
• Reduce the time and cost needed for documenting your databases.
• No more manual update or regeneration of Documents.
• Enable each database developer on the team to keep up-to-date with changes made by other team members.
• At each iteration, automatically print out full and standardized documentation of all database objects.
• PM’s and tech leads can review changes for adherence to requirements without reading code.
• Microsoft MVP Quote "Unscrambler accomplished a full day’s work in 5 minutes. Using Unscrambler on a single Stored Procedure pays the entire licensing cost –and still gives back a half a day’s labor costs. If a typical Stored Procedure is allocated at one week, including development and testing. Unscrambler just saved 20% of the costs".

For a free fully functional trial, please contact us at, [email protected]

www.GenesisOneSolutions.com

IBM Technical Validated Partners