How I install SQL Server

April 01, 2024 (Last Modified: October 07, 2024)

In todays post I will explain how I install SQL Server in my homelab. So it is by no means a guide to setup your production clusters.

How I install SQL Server in my homelab

# we need dbatools to install some stuff
Install-Module dbatools
# let's us ignore the certs in this session
Set-DbatoolsInsecureConnection -Session
# install Ola Hallengreens Maintenance Solution and setup jobs
Install-DbaMaintenanceSolution -SqlInstance localhost -CleanupTime 72 -InstallJobs -AutoScheduleJobs FifteenMinuteLog,DailyFull
# install Brent Ozars First Responder Kit
Install-DbaFirstResponderKit -SqlInstance localhost