SQL Server on Linux Tips
All Tips
Administration
- How to Stop, Start, Enable and Disable SQL Server Services on Linux
- Linux Administration for SQL Server DBA’s: Checking CPU Usage
- Linux Administration for SQL Server DBA’s: Checking Disk I/O
- Linux Administration for SQL Server DBA’s: Checking Disk Space
- Renaming a Red Hat Linux System Hostname for SQL Server
Backups
- Automate SQL Server Backup and Restore Tasks in Linux
- How to change default backup directory in SQL Server on Linux
Command Line
Configuration
- Configure SQL Server on Linux
- How to Change Default Data and Log file directory for SQL Server running on Linux
- How to change SQL Server Collation on Linux
- How to Change SQL Server Instance Name Running on a Linux Server
- How to Change SQL Server Port Number for a Linux Server
- How to change the Default Dump File location of SQL Server running on Linux Server
- How to enable and disable SQL Server traceflags globally for Linux Instances
- SQL Server Configuration Manager for Linux
Connections
Installation
- Fixing dependency issues during installation of SQL Server Tools on Red Hat Linux Server
- Fixing error Failed to mount cd: devices when installing SQL Server tools on SUSE Linux Server
- How to install SQL Server on RHEL for Oracle VirtualBox - Part 1
- Install a Specific SQL Server Version on Linux Step by Step
- Installation of SQL Server 2017 on Oracle VM VirtualBox for Red Hat - Part 2
- Installing SQL Server Tools to make a Database Connection from Redhat Linux Server
- Installing SQL Server vNext CTP1 on Red Hat Linux 7.2
- Installing SQL Server vNext on SUSE Linux Server
- Installing SQL Server vNext on Ubuntu
- Run and Manage SQL Server 2019 CTP 2.0 RHEL Docker Container
- Run SQL Server vNext (CTP1) as a Docker Container on a Mac
- SQL Server 2017 installation on Ubuntu using Docker
Migration
Monitoring
Network
Overview
PowerShell
- Introduction to PowerShell Core on Linux for the SQL Server DBA - Part 3
- Introduction to PowerShell Core on Linux for the SQL Server DBA Part 1
- Learning PowerShell Core on Linux for the SQL Server DBA Part 2
Restore
- Automate SQL Server Backup and Restore Tasks in Linux
- Automate SQL Server multi-file database restores on Linux
- Restore a SQL Server database on a Linux based instance from a backup on a Windows instance
- Restore or Attach a Windows SQL Server Database Backup on a Linux Server
- Use SSMS to Restore a SQL Server database on a Linux based instance from a backup on a Windows instance
Scheduling
- Scheduling SQL Server Tasks on Linux
- Scheduling SQL Server Tasks on Linux Part 2: Advanced Cron Topics
- Scheduling SQL Server Tasks on Linux Part 3: Sending E-Mail Alerts with Cron
Scripting
- Introduction to Bash Scripting for SQL Server DBAs
- Introduction to Bash Scripting for SQL Server: Declaration of Variables and Constants
- Introduction to Bash Scripting: Conditional Statements
- Introduction to Bash Scripting: Display User Messages and Catch User Input
- Introduction to Bash Scripting: Functions
- Introduction to Bash Scripting: Iterative Statements Using Loops
- Introduction to Bash Scripting: Parameter Expansions
- Introduction to Bash Scripting: Pipes and Redirections
Security
- Configure SQL Server on Linux to Use Windows Authentication
- How to change default port for SQL Server on Linux
SQL Server Agent
- How to create SQL Server Agent Jobs on a Linux based instance using Management Studio
- How to schedule a SQL Server Agent Job on a Linux based instance using T-SQL
- Installing SQL Server Agent on Red Hat Linux based SQL Servers
- Installing SQL Server Agent on SUSE Linux
- Installing SQL Server Agent on Ubuntu Server
Storage
Template
Tools
- Adding SQL Server Tools to the PATH Environment Variable on Linux
- Install SQL Server Tools to Establish a Database Connection from an Ubuntu Server
- Installing SQL Server Tools on SUSE Linux
- Linux commands to assist with importing a CSV file into SQL Server
Trace Flags
Uninstall
- How to Uninstall SQL Server 2017 running on Ubuntu
- How to Uninstall SQL Server vNext from a Linux Server
- Remove SQL Tools sqlcmd and bcp from Ubuntu Linux Server
Upgrade
