With the Conductor4SQL Central Command and Query feature, the enormous task of auditing a large MS SQL environment and applying the necessary changes to ensure the entire environment is standardised, becomes simple and far less time consuming.
Business Scenario (Manager and DBA)
Ian, the IT Executive Manager, has been tasked by the company CIO to ensure that all the best practice MS SQL configurations settings are enforced, that the company database security practices are applied and that all MS SQL instances comply with the auditor’s guidelines across the entire organisations MS SQL Environment.
Ian approaches Joe, the company senior DBA, and asks him to gather all the necessary information. Ian would like a report showing all the MS SQL instances in the organisation that do not currently comply with the configuration including security and auditor’s best practices and recommendations.
Additionally Ian requests that Joe provide a timeline for how long it will take to gather the information and standardise the MS SQL environment to make sure it is compliant with the organisations guidelines.
As the organisation has over 1000 instances of MS SQL Server, Joe and his DBA team would need to spend many long nights gathering all the required information. It will also take them weeks of effort manually rectifying the issues they find.
With Conductor4SQL's distributed command and query features, and the use of intelligent MS SQL groupings, Joe is happy to report to Ian that gathering the required information and standardising the environment can be done in a fraction of the time.
Conductor4SQL is a cut above other competing products as all features work off a guaranteed message queue. To understand what this means and how it will benefit you refer to the Message Delivery feature page.