System Databases

2022

TL; DR

In Codd We Trust: Understand how SQL Server builds uses its system databases, all 5 of them.

Session Details

We all know about the System Databases, but often sort of ignore them other than backups. If we do pay attention, often it's only the tempdb. But there's plenty of other things to know about the system databases, all 5 of them. And learn why it's "tables all the way down."

3 things you'll get out of this session

Speaker

Greg Moore's previous sessions

Flying the Plane - 2022

Introducing Powershell for DBAs - 2022

System Databases - 2022

Using Powershell to build a Quick and Dirty ETL Process - 2022