SQL Server 2022 Administration Inside Out

Chapter 3

Design and implement an on-premises database infrastructure

• Introduction to SQL Server database architecture

• Data files and filegroups

• Record changes in the transaction log

• Partition tables

• Compress data

• Manage the temporary database

• Configuration settings

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 and file system settings that are most appropriate for ...