Deploying SQL Server Automatically

  • Comments posted to this topic are about the item Deploying SQL Server Automatically

  • Automated deployments, particularly for dev/test is increasing, and is one of the main drivers for containers.   Fully configured, identical, and delivered in seconds, with a complete audit log.  CI pipelines benefit with a pristine environment for each run.  A secondary benefit is simplified infrastructure, with a modest VM supporting up to 20 or even 50 containerized environments.

  • I tried solutions as Fine build as well. but now completely shifted to  Powershell Desired State Configuration DSC. This also allows  to check if your server has drifted from its original config.

    https://github.com/dsccommunity/SqlServerDsc

  • Thanks, good to know about other solutions.

    One question. If you want things to change, do you have a separate config for each instance that you update? Do you store this centrally or on the instance?

  • Custom images capture the configuration desired.  In the case of SQL Server that also includes which SQL Server services are provisioned.

  • This was removed by the editor as SPAM

  • This was removed by the editor as SPAM

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply