With SSDSC, DBA’s and DevOps can automate their SQL installation and deployment tasks. DBAs will spend less time solving database incidents that arise because someone, somewhere has made a change to a SQL Server configuration. And, auditors can be certain that the SQL environment is exactly how it is designed.
SQLTreeo’s SQL Server Desired State Configurator (SSDSC) puts you in control. You design it how you want it and you schedule it to keep an eye on everything. You can even set it to automatically revert to your original configurations if someone made a change.Free trial Buy now
Our SSDSC enables you to automate deployment of any SQL server configuration from beginning to end, including implementing tasks, changes and updates to database settings and group and user accounts.
Simply define the configuration you want, schedule it and then leave it to the SSDSC to make it happen.
Your DBAs no longer have to spend valuable time keeping hundreds of servers aligned. Instead, they can rely on our SSDSC to keep an unlimited number of servers in their desired states.
Your auditors can be confident that updates have been automatically installed, even across thousands of servers, with no human errors.
You can even implement ‘Deployment on Demand’ as a Cloud strategy.
If someone changes the configuration, you no longer have to spend time putting it right. You can run the SQLTreeo SSDSC application to fix any changes back to your original configuration. For example, if you specify a specific mail configuration or back-up mechanism and someone tries to change it, the tool will automatically revert it to your original settings.
You can schedule this evaluation and enforcement to ensure that, at any given time, the configuration of a machine is always identical to its configuration. This avoids drift and means you can be 100% confident that your SQL Server and database settings haven’t changed.
You can choose to standardize your SQL Servers by configuring them identically. Alternatively, you can create new configuration files for different groups of SQL Servers with different purposes or for different business functions, such as OLTP, Data warehousing or Reporting.
You can set up our SSDSC application to cover any of the SQL configuration options available from Microsoft SQL Server. Everything you can imagine, from auditing and encryption to maintenance alerts and data masking for GDPR compliance, there is no limit to what you can set up in our SSDSC.
SQLTreeo’s SQL Server Desired State Configurator (SSDSC) puts you in control. You design it how you want it and you schedule it to keep an eye on everything. You can even set it to automatically revert to your original configurations if someone made a change.