book

SQL Server 2022 Administration Inside Out

by Randolph West, Melody Zacharias, William Assaf, Deepthi Goguri, Elizabeth Noble, Meagan Longoria, Joseph D'Antoni, Louis Davidson

May 2023

Intermediate to advanced

992 pages

31h 14m

English

Microsoft Press

Read now

Unlock full access

Randolph WestWilliam AssafElizabeth NobleMeagan LongoriaJoey D’AntoniLouis DavidsonMelody ZachariasWilliam CarterJosh Smith

Who this book is forHow this book is organizedConventionsErrata, updates, and book support
SQL Server setupTools and services installed with the Database EnginePerformance and reliability monitoring toolsSQL Server Reporting Services (SSRS)SQL Server Management Studio (SSMS)Azure Data StudioSQL Server Data ToolsSQL Server on Azure Arc–enabled serversMicrosoft PurviewDiscontinued and deprecated features
MemoryCentral processing unitData storageConnect to SQL Server over the networkHigh-availability conceptsSecure SQL ServerUnderstand virtualization and containers
Introduction to SQL Server database architectureData files and filegroupsRecord changes in the transaction logPartition tablesCompress dataManage the temporary databaseConfiguration settings
What to do before installing SQL ServerInstall a new instanceSQL Server on Azure virtual machinesPost-installation server configurationPost-installation configuration of other featuresContainer orchestration with Kubernetes
What is Linux?Considerations for installing SQL Server on LinuxInstall SQL Server on LinuxConfigure SQL Server on LinuxCaveats of SQL Server on Linux
Add databases to a SQL Server instanceMove and remove databases
Review table structuresSpecial table typesStore large binary objectsTable partitionsCapture modifications to dataBenefits of PolyBase for external data sources and external tables
Detect, prevent, and respond to database corruptionMaintain indexes and statisticsManage database file sizesMonitor activity with DMOsMonitor with the SQL Assessment APIUse Extended EventsCapture performance metrics with DMOs and data collectorsProtect important workloads with Resource GovernorUnderstand the SQL Server servicing model
Foundations of SQL Server automated administrationMaintain SQL ServerUse SQL Server maintenance plansStrategies for administering multiple SQL ServersUse PowerShell to automate SQL Server administration
Prepare for data recoveryRansomware attacksUnderstand different types of backupsUnderstand backup devicesCreate and verify backupsRestore a databaseDefine a recovery strategy
Overview of high-availability and disaster-recovery technologiesConfigure failover cluster instancesDesign availability groups solutionsUnderstand the Azure SQL Managed Instance link featureConfigure availability groups in SQL Server on LinuxAdminister availability groups
Understand authentication modesGrasp security principalsUnderstand permissions and authorizationPerform common security administration tasks
Privacy in the modern eraMicrosoft Purview overviewIntroduction to security principles and protocolsProtect the data platformLedger overviewAudit with SQL Server and Azure SQL DatabaseSecure Azure infrastructure as a service
Understand isolation levels and concurrencyUnderstand durability settings for performanceHow SQL Server executes a queryUse advanced engine features to tune queries
Design clustered indexesDesign rowstore nonclustered indexesUnderstand columnstore indexesUnderstand indexes in memory-optimized tablesUnderstand index statisticsUnderstand other types of indexes
Cloud computing and Microsoft AzureCloud models and SQL ServerCloud securityOther data services in Azure
Provision an Azure SQL Database logical serverProvision a database in Azure SQL DatabaseProvision an elastic poolManage database spaceSecurity in Azure SQL DatabasePrepare Azure SQL Database for disaster recovery
What is Azure SQL Managed Instance?Create a SQL managed instanceDelete a SQL managed instanceEstablish a connection to a SQL managed instanceMigrate data to Azure SQL Managed InstanceAzure SQL Managed Instance administration featuresAzure SQL Managed Instance security featuresAzure SQL Managed Instance data protection features
Migration services optionsResolve common migration failures using Database Migration ServiceMigrate with Azure Data FactoryBest practices for security and resilience during migration

Content preview from SQL Server 2022 Administration Inside Out

Chapter 6

Provision and configure SQL Server databases

This chapter reviews various strategies for creating new databases and adding existing databases to a SQL Server. It covers considerations for database migrations, including key points to remember when moving databases from instance to instance and various strategies for moving databases. It also reviews the creation of new user databases and discusses important database properties to be aware of throughout the application development lifecycle.

All scripts for this book are available for download at https://www.MicrosoftPressStore.com/SQLServer2022InsideOut/downloads.

Add databases to a SQL Server instance

Chapter 3, “ ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Start your free trial

SQL Server 2019 Administration Inside Out

Randolph West, Melody Zacharias, William Assaf, Sven Aelterman, Louis Davidson, Joseph D’Antoni

SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, 4th Edition

John L. Viescas

SQL Server Advanced Troubleshooting and Performance Tuning

Dmitri Korotkevitch

T-SQL Querying

Itzik Ben-Gan, Adam Machanic, Dejan Sarka, Kevin Farlee

Publisher Resources

ISBN: 9780137899845