PASS Marathon: Linux Edition 2017
HiHo! HiHo! SQL Server on Linux, We Go!
Event Date: 13-12-2017 18:00 - Category: Breakout Session (60 minutes) - Track: Design
Speaker(s): Janis Griffin
Title: HiHo! HiHo! SQL Server on Linux, We Go!
SQL Server has been running on Windows for years. Now Microsoft is making it available on Linux in order to provide a consistent database platform across Window and Linux servers, as well as on-premises and in the cloud. In this presentation, Janis Griffin, database performance evangelist at SolarWinds, will discuss the advantages of using SQL Server on Linux, comparing architecture, cost and performance. Several demonstrations on installing and maintaining SQL Server on Linux will be shown along with an introduction of several useful Linux commands.
The participant will learn:
- The advantages of using SQL Server on Linux, comparing architecture, cost and performance to Window servers.
- How to install, maintain and backup SQL Server on Ubuntu Linux systems
- Several useful Linux commands to monitor/manage SQL Server
The SQL Server Availability Story on Linux
Event Date: 13-12-2017 19:00 - Category: Breakout Session (60 minutes) - Track: Analyze
Speaker(s): Allan Hirt
Title: The SQL Server Availability Story on Linux
SQL Server 2017 is here, and so is its arrival on Linux. That means you need to also make instances and databases highly available on this new variant of SQL Server. Covering the availability story for SQL Server on Linux, this session will provide the inside scoop on where it is similar and where it is very different from deploying under Windows Server. You will also get tips and tricks for SQL Server availability configurations from the guy who helped Microsoft write the availability documentation for SQL Server on Linux.
Monitoring Linux Performance for the SQL Server Admin
Event Date: 13-12-2017 20:00 - Category: Breakout Session (60 minutes) - Track: Perform
Speaker(s): Anthony Nocentino
Title: Monitoring Linux Performance for the SQL Server Admin
SQL Server on Linux: DBA Focused Lessons Learned from Early Deployments
Event Date: 13-12-2017 21:00 - Category: Breakout Session (60 minutes) - Track: Perform
Speaker(s): Denzil Ribeiro
Title: SQL Server on Linux: DBA Focused Lessons Learned from Early Deployments
Linux for the SQL Server DBA
Event Date: 13-12-2017 22:00 - Category: Breakout Session (60 minutes) - Track: Analyze
Speaker(s): David Klee
Title: Linux for the SQL Server DBA
Times are certainly changing with Microsoft’s recent announcement to adopt the Linux operating system with the SQL Server 2017 release, and you should be prepared to support it. But, what is Linux? Why run your critical databases on an unfamiliar operating system? How do I do the basics, such as backing up to a network share or add additional drives for data, logs, and tempdb files?
This introductory session will help seasoned SQL Server DBAs understand the basics of Linux and how it differs from Windows, all the way from basic management to performance monitoring. By the end of the session, you will be able to launch your own Linux-based SQL Server instance on a production ready VM.
Essential Linux for the SQL Server DBA
Event Date: 13-12-2017 23:00 - Category: Breakout Session (60 minutes) - Track: Analyze
Speaker(s): Kellyn Pot'Vin-Gorman
Title: Essential Linux for the SQL Server DBA
Linux has come to Microsoft! Do you want to gain the knowledge that Oracle DBAs have been using for years to manage their databases on this valuable OS?
This session is taught by a multi-platform DBA who specializes in Oracle and SQL Server with almost two decades on Unix/Linux experience. The goal is to give you the most valuable fundamentals and commands that are important to the DBA when managing a database in a Non-Windows environment.
- Linux history and concepts.
- Important differences between systems
- Crucial commands to get around
a. Navigating, searching and managing
b. Monitoring, tracing and updating
c. Editing and scripting
You’ll leave feeling more at ease with Linux and have plenty of content and links to continue the learning after the session!