In this blog series, I’ll talk about SQL Server on Linux for the Business Intelligence Professional. You’ll need some prequisites, and this blog post edition is dedicated to helping you to get set up.
It’s assumed that you have set up a SQL Server on Linux Virtual Machine on Azure.
To connect to it, you will need an SSH client. SSH stands for Secure Shell. SSH is used to log into a remote machine and execute commands. It also supports other features, such as tunneling, forwarding TCP ports and X11 connections. It can transfer files using the associated SSH file transfer (SFTP) or secure copy (SCP) protocols. SSH uses the client-server model.
I’ve put some instructions here so you have an SSH client installed. The options are below:
Installing an SSH Client
If you don’t have a client installed, you have a lot of options for SSH Clients. For our purposes, there are no differences although I recommend Chocolatey because it has some great package features. These choices are listed here:
- Choose Git for Windows I will go through the examples using this client
- Use Chocolatey. SSH is also part of Chocolatey
- PuTTY is featured in the Microsoft documentation
Git for Windows
Chocolatey
@"%SystemRoot%\System32\WindowsPowerShell\v1.0\powershell.exe" -NoProfile -InputFormat None -ExecutionPolicy Bypass -Command "iex ((New-Object System.Net.WebClient).DownloadString('https://chocolatey.org/install.ps1'))" && SET "PATH=%PATH%;%ALLUSERSPROFILE%\chocolatey\bin"
choco install chocolateygui
3 thoughts on “SQL Server on Linux for the Business Intelligence Professional: Prerequisites”