If we want to avoid the cloud and stick to an "old-school" approach, we can choose to install a SQL Server Express (or Developer) on-premise instance on our development (and later, on our production) machine.
To do that, perform the following steps:
- Download the SQL Server 2019 on-premise installation package (arguably the Windows build, but the Linux installer is also available) from the following URL: https://www.microsoft.com/en-us/sql-server/sql-server-downloads.
- Double-click to the executable file to start the installation process. When prompted for the installation type, select the Default option (unless we need to configure some Advanced options to accommodate specific needs, providing that we know what ...