SQLTools
SQLTools is a group of SQL utility applications from Atlantis Interactive. These are tools for SQL Server DBAs and developers alike - allowing both sets of users much easier access to the information they need. These tools all take the notion that a picture is worth 1000 words and apply them to the SQL Server community, giving visual representations of object index usage, data dependency and schema or sql dependency.
The following SQL utility applications form the members of the SQLTools family:
Data Space Analyser
Data Space Analyser was the first SQL utility to form part of the SQLTools family – it allows you to analyse the space used by the indexes in your databases visually, starting at the server level and drilling down to the partition level by interacting with a graph. Export the data, save images for use in reports or export the data into CSV format to use conveniently in Excel.
Data Surf
Next up in the SQLTools family is Data Surf - allowing you to ‘surf’ the data in your database by using foreign key relationships to navigate from rows in one table to the next by simply using the mouse and interacting with the surf graph. This SQL utility saves you having to perform repetitive ‘SELECT * FROM’ style queries to investigate data issues. Create template surfs and apply them to different surf start points quickly and easily.
Schema Surf
Our newest addition to the SQLTools family is Schema Surf – this SQL utility complements Data Surf by allowing you to ‘surf’ through your schema. Click on any object in the object tree and you are presented with a visualisation of all the dependencies of that object and their interconnections. Click on any node in the graph to re-focus the graph around the newly selected object.