How can SQLClue help you? Here are a few of the possibilities:
Do you need to identify the structural differences between two Microsoft SQL Server database instances? Are those SQL Servers in different software lifecycle environments and/or securely isolated such that you cannot access both at the same time to complete the comparison?
Use SQLClue Workstation's powerful and highly configurable compare capabilities to identify differences in the configuration settings and objects on any two SQL Servers. Compare all configurable SQL Server database engine values including:
- database objects (tables, stored procedures, functions, views, CLR assemblies, etc.)
- database security setting (users, permissions, roles, etc.)
- server side services (full text search, service broker etc.)
- server security setting (logins, roles, credentials, keys, certificates, audits, etc.)
- server configuration settings (sp_configure, Policies, Audits, Mail, Alerts, SQL Agent Jobs, etc.)
When the SQL Server targets are insulated from one from the other on the network, use SQLClue Server's SQL Configuration Archive data store to bring the settings and scripts from one of the SQL Servers into proximity to the other, or alternately move the settings and scripts of both SQL Servers to any location convenient to the person or group(s) that are interested in the comparison results. Because SQLClue data is stored in SQL Server any method of copying or accessing SQL Server data that is supported by the existing infrastructure can be used to move the lightweight SQLClue operational data stores including the SQLClue UI, OLEDB (linked servers) LAN or WAN replication, backup/restore, mirroring/log shipping, SSIS, etc.
When using SQLClue, a wide variety of structural comparisons scenarios are possible. The never a need to expose sensitive data, scrub large databases or move large amounts of data to verify or compare configurations between SQL Servers is safely eliminated.
Learn more about SQLClue Workstation Configuration Compare Capabilities.
Do you need to automatically capture all changes made to the settings and objects of one or more SQL Server 2005 and/or SQL Server 2008 instance in your data center? Will you want to identify who made the changes, the settings changed or script used to make the changes, and quickly access the setting value or script for the previous state if a revert is necessary?
Use SQLClue Server's SQL Configuration Archive engine with event notifications enabled to passively monitor, document and store all the same items as can be compared using the Workstation Edition to a complete and versioned central SQL Server database of configuration change history.
SQLClue Server includes exactly the same powerful compare capabilities as SQLClue Workstation so there is no need have two applications installed or mess with complex licensing requirements when you need both change monitoring and comparison capabilities. Use a central repository for as many SQL Servers as can be accessed from the repository and as many free to use Workstation clients as you need to compare and verify configurations.
Learn More about SQLClue's SQL Configuration Archive.
Do you have a mixed environment of SQL Server 2000, SQL Server 2005 and SQL Server 2008 instances? Do you need a complete catalog of daily changes on each of those SQL Servers that can be used to understand what changes occurred on any particular day to help troubleshoot and isolate a performance, stability, or data integrity issue; maybe even have a reference copy if the previous version of a database object script in the event a rollback is needed?
Use SQLClue Server's SQL Configuration Archive engine to compare all settings and scriptable objects on the server with the known values and scripts of those settings and objects. Instances of SQL Server 2005 and SQL Server 2008 can be configured to do a complete comparison or to use more scalable event notification when a change occurs for significant performance improvements over the full comparison of each object and setting option.
SQLClue also works with SQL Server 2000. Unfortunately, SQL Server 2000 provides no event based mechanism for notification of changes. Obviously the event based asynchronous method provides a higher level of safety and a much nicer performance profile. Nonetheless, SQLClue will still keep track of the changes on a scheduled basis when events are not enabled and will still quickly and easily provide the previous days configuration values and object scripts - assuming a once a day archive schedule - should a rollback be necessary regardless the release version of the SQL Server. With notifications the rollback options can include the ability to know exactly what changed in the last few minutes.
Learn more about SQLClue's SQL Configuration Archive.
Learn more about SQLClue's built-in reporting capabilities.
Do you have a great deal of documentation and knowledge that is captured on the hard drives and in the minds of the highly skilled experts within your data center yet have no effective way for others to locate and benefit from that documentation and knowledge? Is interruption the only way to get input from your IT experts?
Use SQLClue Server's Data Center Runbook to effortlessly mirror the documentation from any number of hard drive locations into a central, full text indexed library without the need to move any of that documentation from its current location. Then, simply by giving the otherwise unpriviledged SQLClue Automation Controller's service account access to the catalogued documents, continually update the central catalog with never the need to remember to synchronize the catalog and the documents file system location.
There is more. As if the now searchable and shared documentation were not enough to give everyone in the data center access to the best available information; as information provided by others is viewed, the viewer is able to rate and provide feedback to help validate and improvement the documentation as necessary. Once feedback is sent, the author can view the feedback and make revisions at an appropriate and convenient time. There is no need for inefficient and time wasting interruptions. Both the viewer and the author are afforded the productivity boosting benefits that come when work is mostly planned.
Learn more about SQLClue's innovative Data Center Runbook.
Are you the lead or manager of a team of highly skilled data center staff in need of better tools to measure the effectiveness of individual team members? Perhaps the measurements will be used as feedback during annual reviews or perhaps as a routinely monitored activity barometer or maybe both. The data may be used to confirm that the team is giving adequate attention to business continuity requirements, to verify that team members remain on task, and even to quantify the team's view of work produced by one another.
Use SQLClue Server's Data Center Runbook built in reports to measure the amount of documentation contributed, the ratings of that documentation by other teams, and the improvements as a result of peer-review. In addition, use these preconfigured reports to measure the amount of review feedback an individual has contributed while helping to raise the over-all quality of the teams' operational and business continuity deliverables.
The Data Center Runbook is primarily a tool to help the team work together. It fosters information sharing by providing improved access to documentation and fosters knowledge sharing by capturing peer-review feedback. The value of the Data Center Runbook as a measurement tool for team leaders and managers is ultimately a derived benefit of the documentation and review efforts. To reap the measurable fruit, the primary object of the team lead or manager must be to impart on all team members that the information sharing and peer review facilities will be used by all without excuse or exception.
Learn more about SQLClue's innovative Data Center Runbook.
Learn more about SQLClue's built-in reporting capabilities.
Download the Free SQLClue Workstation Now!
Includes an option for a free 14 day trial of SQLClue Server.
This page was last modified on Saturday, February 13, 2010 10:01:10 AM