13 Install and update SQL Server

Installing new SQL Servers can help you modernize your entire estate and prepare a new standardized environment. Automated updates can help keep your estate secure by streamlining the process.

In this chapter, we’ll learn how to install and update SQL Server for Windows from the command line. You’re probably familiar with installing SQL Server on-premises using the GUI. If you are a developer, you may even have installed SQL Server containers. Containers and SQL Server on Linux are basically automated right out of the box, whereas Windows isn’t command-line first. For this reason, dbatools focuses on automating the Windows-based installer.

After working through this chapter, you will be able to easily deploy several ...

Get Learn dbatools in a Month of Lunches now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.