Chapter 3Designing and implementing an on-premises database infrastructure

This chapter covers the architecture of an on-premises database infrastructure, including the differences between data and transaction log files, and how certain features work to ensure durability and consistency even during unexpected events.

We cover what certain important configuration settings mean, both from a performance and best practice perspective. We also go into detail about the different kinds of data compression ...

Get SQL Server 2019 Administration Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.