Chef Progress Primary Logo

Best Practices for Simplifying and Automating Microsoft SQL Updates

Application Delivery User Guide

User Guide: Best Practices for Simplifying and Automating Microsoft SQL Updates

Chef Habitat provides automation capabilities for defining, packaging and delivering applications to almost any environment regardless of operating system or deployment platform.

Updating Microsoft SQL can be a complex and time consuming task. This guide shows how Chef Habitat can be used to streamline and dramatically decrease the time required to configure and update Microsoft SQL.

Key topics covered in the guide include:

  • Microsoft SQL Key Considerations
  • Getting Started Packaging Microsoft SQL Server with Chef Habitat
  • Installing SQL Server via the install Hook
  • Setting the Port and Opening the Firewall
  • Running the SQL Server Service
  • Setting up Logins and Users
  • Exporting SQL Server to a Docker Image
  • Testing Connectivity to a “Habitized” SQL Server
  • Using a Habitat Update strategy to patch SQL Server
  • Exploring a plan for SQL Server High Availability

New to Chef Habitat? If you are new to Chef Habitat we recommend viewing the free introductory course, Deliver Applications with Chef Habitat, on Learn Chef.

Download User Guide

<div class="-tac -pt1 -pb2"> <img data-sf-ec-immutable="" src="/images/default-source/default-album/landing-pages/thank-you-message.svg?sfvrsn=134c2aec_2" alt="thank-you-message" class="-w18 -ma -mb2" sfref="[images%7COpenAccessDataProvider]8b5b7c4c-9e32-4534-95e6-df35187a304e" /> <h3>Thank You</h3> <p>If your download hasn't started in 5 seconds please <br> <a href="/docs/default-source/guides/habitatguide_best-practicesmicrosoftsql.pdf?sfvrsn=17e114fc_4" target="_blank" rel="nofollow" class="-i-next">Click here to download</a></p> </div> <script>var"/docs/default-source/product-and-user-guides/habitatguide_best-practicesmicrosoftsql.pdf", '_blank');win.focus()</script><script>var header = document.getElementsByClassName('-c-black js-form-header')[0]; if(header){ = 'none'; }</script><script>if (typeof (window.dataLayer) !== 'undefined') { window.dataLayer = window.dataLayer || []; dataLayer.push({'event': 'custom.successMessageShown'}); } </script> Loading animation