SQL Server on Linux

There are already some templates that are available in Azure that run SQL Server on Linux. This tip describes the step by step process to quickly set it up.

In this tip, I will show you how to change the default backup location on a Linux based SQL Server instance compared to a Windows based SQL Server.

You are a SQL Server DBA and you are new to Linux. You know that Microsoft has decided to expand SQL Server to Linux servers and you need to know how to check for network latency and I/O. In this tip I will show you some tools that will help you.

Learn the step by step process to change the SQL Server Port Number running on a Linux Server and the corresponding validation steps.

In this tip I will explain how to create and run SQL Server Agent jobs using T-SQL commands on a Linux based SQL Server.

With the upcoming release of SQL Server, Microsoft has decided to expand operating systems to support Linux servers. We as Database Administrators need to know how the underlying disks subsystems are performing. Since most of the SQL Server Administrators

I have written several tips about SQL Server vNext running on Linux based operating systems and in this tip I will explain how to uninstall SQL Server vNext from a Linux server.

In this tip I will show you how to check file sizes and disk space usage when using SQL Server on Linux.

Microsoft released SQL Server to run on Linux servers and some of the administration tasks on Linux are different than on Windows. One thing you may need to do is change the SQL Server collation and in this tip we walk through how this can be done.

In this tip I will explain how to install SQL Server Agent on an Ubuntu server, so that we can create SQL Server jobs to schedule repetitive tasks.

In a previous tip we described the installation steps to install SQL Server vNext CTP 1 on Ubuntu. In this tip we cover how to update an existing installation of SQL Server vNext running on Ubuntu.

In this tip learn about some important Linux commands to help you administer SQL Server on Linux.

Learn how to enable and disable SQL Server traceflags globally for instances running on Linux.

Learn about the mssql-conf tool to set parameters, traceflags, the sa password, validate SQL Server configuration and accept the license agreement.

Learn the step by step process to restore a SQL Server database on a Linux based instance from a backup on a Windows instance with SQL Server Management Studio.

You want to run SQL commands with the sqlcmd tool on a Linux terminal, but you don't want to have to change to the tools folder for every terminal window you open. In this tip I will show you how to set the $PATH environment variable on Linux.

Learn how to change default data and log file directory for SQL Server running on Linux with the mssql-conf command.

Microsoft released an update for SQL Server on Linux from CTP 1 to CTP1.1. In his tip I will let you know how to upgrade to CTP 1.1 for SQL Server vNext on Linux.

Learn how to configure SQL Server on Linux including the default port, instance collation or even add trace flags.

Microsoft released SQL Server to run on Linux servers. To secure the database environment, DBA's often change the SQL Server port from its default port 1433 to another available port number. In this tip we will see how can we make this change.

In this tip, I will show you how to restore a database on a Linux based SQL Server instance from a backup taken on Windows based SQL Server.

Microsoft has recently released SQL Server to run on Linux servers. Once installed, we may need to stop, start, enable or disable the services. In this tip we will see how to do it in Linux.

In this tip we look at SQL Server vNext for Linux and how to get started.

I explained how to install SQL Server vNext on Ubuntu in my last tip and in this tip we will look at how to install SQL Server tools on the Ubuntu server.