If you’ve installed SQL Server on your SUSE machine, you’ll need some tools to connect to it and run queries, etc.
The sqlcmd and bcp utilities are good options for performing the most common tasks.
Continue readingTag: install
How to Install sqlcmd & bcp on Ubuntu
If you’ve installed SQL Server on your Ubuntu machine, you’ll need some sort of tool to connect to it.
Installing the sqlcmd and bcp utilities is good place to start.
Continue readingHow to Install SQL Server on Windows
In this article, I show you how to install SQL Server on a Windows machine (screenshots included).
In this case I used the installation wizard to install SQL Server 2019 onto a Windows 10 machine, using the Basic installation option, which uses the default configuration.
Continue readingHow to Install SSMS
SSMS (SQL Server Management Studio) is a graphical tool that you can use to administer SQL Server.
SSMS used to be bundled with SQL Server, but that is no longer the case. You must now install it separately.
This article shows you how to install SSMS (including screenshots).
Note that SSMS is only available for Windows machines. If you’re using a non-Windows machine (such as Mac or Linux), try Azure Data Studio or perhaps DBeaver.
Also note that Azure Data Studio is now included when you install SSMS (starting with SSMS 18.7).
Continue readingHow to Install SQL Server on SUSE 12
This article provides step-by-step instructions for installing SQL Server 2019 for Linux on SUSE Linux Enterprise Server 12.
These steps should work on SUSE Linux Enterprise Server 12, SP2, SP3, SP4, and SP5.
You should have at least 2GB of memory before you install SQL Server on your SUSE machine. If you’re installing this on a virtual machine, you should have at least 2GB of memory allocated to it.
The file system must be XFS or EXT4.
Continue readingHow to Install SQL Server on Red Hat 8
This article provides step-by-step instructions for installing SQL Server 2019 for Linux on Red Hat Enterprise Linux (RHEL) 8.
I performed these steps using RHEL 8.3, but they should also work on RHEL editions 7.3 to 7.8, and 8.0 to 8.2.
You should have at least 2GB of memory before you install SQL Server on your Red Hat machine. If you’re installing this on a virtual machine, you should have at least 2GB of memory allocated to it.
Continue readingHow to Install SQL Server on Ubuntu 18.04
This article provides step-by-step instructions for installing SQL Server 2019 for Linux on Ubuntu 18.04.
It should also work with Ubuntu 16.04 (just change the path as instructed).
You should have at least 2GB of memory before you install SQL Server on your Ubuntu machine.
Continue readingInstall Postgres.app on a Mac
The easiest way to install PostgreSQL on a Mac is by installing Postgres.app. Postgres.app is a full-featured PostgreSQL installation packaged as a standard Mac application.
You simply download it and drag it to your Applications folder, just like with any other application.
Continue readingInstall SQL Server 2019 on a Mac
I previously explained how to install SQL Server on a Mac via a Docker container. When I wrote that, SQL Server 2017 was the latest version of SQL Server, and it had just been made available for Linux and Docker (which means that you can also install it on MacOS systems).
In late 2018, Microsoft announced SQL Server 2019 Preview, and subsequently announced general release in late 2019. The installation process for SQL Server 2019 is exactly the same as for SQL Server 2017. The only difference is that you need to use the container image for SQL Server 2019 instead of the 2017 image. Here I show you how to do that.
Also, if you already have SQL Server 2017 installed, and you want to install SQL Server 2019 without removing the 2017 version, you’ll need to allocate a different port number on your host. I show you how to do that too.
But first… if you’re using a Mac with the M1 chip, see How to Install SQL Server on an M1 Mac (ARM64).
How to Install Azure Data Studio on a Mac
Azure Data Studio (previously known as SQL Operations Studio) is a free tool that you can use to manage SQL Server. It uses a graphical user interface (GUI) that helps you view the various databases and objects within a SQL Server instance. It can run on Windows, macOS, and Linux, and it’s also designed to be used with Azure SQL Database, and Azure SQL Data Warehouse.
Here I explain how to install Azure Data Studio onto a Mac, then how to use it to connect to SQL Server.