24 Hours of PASS: Cross-Platform SQL Server Management

24 Hours of PASS

The Windows DBA’s Jump Start for SQL Server on Linux

Michael Otey
60 minutes
Evolve
Database Administration and Development
DBA, Database Developer, IT Pro
200
This session is intended for Windows DBAs who want to get a jump start with SQL Server on Linux. First, you’ll learn about the feature set supported by SQL Server on Linux and how it’s different from Windows. Then you’ll get a quick cheat sheet and see examples of running the essential Linux management commands like finding your IP address and host name, navigating directories and using Bash. Next, I’ll walk through the SQL Server on Linux installation and connection process and then jump into showing how you can migrate databases and manage SQL Server on Linux using both SQL Server Management Studio (SSMS) as well as SQL Operations Studio. You’ll see how to use the SSMS Dashboard and Query Store to get performance data. Finally, you’ll learn how to install and use SQL Agent and SQL Server Integration Services as well as the new cross platform tools like mssql-cli and mssql-scripter.
Basic knowledge of SQL Server

View Recording

To access the session recording, please login or register first:

Sign In


Not a PASS member? Click here to register.

Michael Otey
Journalist, Sql Server Magazine

Michael Otey is a senior contributing editor for Windows IT Pro and SQL Server Pro and is president of TECA a technical writing, software-development and consulting company. Michael is a former SQL... View More

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids