22-25 April 2026
SQLBits 2018

SQL Server Administration on Linux

Come learn how to set up a production-grade SQL Server on Linux environment!
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.

Speakers

Bob Pusateri

bobpusateri.com

Bob Pusateri's previous sessions

Relational or Non-Relational? Choosing the Best Database for the Task
Relational databases are excellent tools that can solve many data problems...but not all of them. The same can be said for non-relational databases. This session will showcase the strengths and weaknesses of both relational and non-relational databases with a particular focus on the best use cases for each. Attendees will see real-world examples of what they may - or may not - want to store in a particular database type, and why.
 
Maximizing Database Performance With Isolation Levels
How does a database handle multiple processes all trying to read and write at the same time? The answer is transaction isolation levels, and Azure SQL Database and SQL Server offer several to choose from depending on your workload's needs. Attend this session to understand how they work, why they matter, and how proper concurrency settings can result in great performance improvements!
 
Relational or Non-Relational? Choosing the Best Database for the Task
Relational databases are excellent tools that can solve many data problems...but not all of them. The same can be said for non-relational databases. This session will showcase the strengths and weaknesses of both relational and non-relational databases with a particular focus on the best use cases for each. Attendees will see real-world examples of what they may - or may not - want to store in a particular database type, and why.
 
Select Stars: A SQL DBAs Introduction to Azure Cosmos DB
Are you curious about Azure Cosmos DB? This is the session for you! Join us to find out what it is, how it compares to other database platforms, and what all the hype is about!
 
SQL Server Administration on Linux
Come learn how to set up a production-grade SQL Server on Linux environment!
 
VLDBs: Lessons Learned
Maintaining very large databases (VLDBs) can involve a lot more creativity and bending of the rules than their smaller brethren. Attend this session to learn tips and tricks amassed from years of managing them.