Deploying SQL Server Automatically

Question

Deploying SQL Server Automatically

Steve Jones - SSC Editor

SSC Guru

Points: 736478
More actions
July 31, 2021 at 12:00 am

#3915528

Comments posted to this topic are about the item Deploying SQL Server Automatically
September 25, 2021 at 10:32 am

This was removed by the editor as SPAM
September 25, 2021 at 10:33 am

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

pauls 72822 Ten Centuries Points: 1049 More actions · Answer 1

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.

rdeheld-535532 SSC Veteran Points: 208 More actions · Answer 2

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

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 3

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?

pauls 72822 Ten Centuries Points: 1049 More actions · Answer 4

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