book

SQL Server 2019 Administration Inside Out

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

March 2020

Intermediate to advanced

992 pages

30h 7m

English

Microsoft Press

Read now

Unlock full access

AcknowledgmentsErrata, updates, & book support
SQL Server setupTools and services installed with the SQL Server Database EnginePerformance and reliability monitoring toolsSQL Server Reporting ServicesSQL Server Management Studio (SSMS)Azure Data StudioSQL Server Data ToolsA note on discontinued and deprecated features

MemoryCentral Processing UnitStoring your dataConnecting to SQL Server over the networkHigh availability conceptsSecuring SQL ServerUnderstanding virtualization and containers
Introduction to SQL Server database architectureData files and filegroupsRecording changes in the transaction logTable partitioningCompressing dataManaging the temporary databaseConfiguration settingsContainer orchestration with Kubernetes
What to do before installing SQL ServerInstalling a new instancePost-installation server configurationPost-installation configuration of other features
What is Linux?Considerations for installing SQL Server on LinuxInstalling SQL Server on LinuxConfiguring SQL Server for LinuxCaveats of SQL Server on Linux
Adding databases to a SQL Server instanceMoving and removing databases
Reviewing table designSpecial table typesStoring BLOBsTable partitioningCapturing modifications to data
Detecting, preventing, and responding to database corruptionMaintaining indexes and statisticsManaging database file sizesMonitoring activity by using DMOsMonitoring with the SQL Assessment APIUtilizing extended eventsCapturing performance metrics with DMOs and Data CollectorsProtecting important workloads by using Resource GovernorUnderstanding the new servicing model
Components of SQL Server automated administrationMaintaining SQL ServerUsing SQL Server Maintenance PlansStrategies for administering multiple SQL ServersUsing PowerShell to automate SQL Server administration
Preparing for data recoveryUnderstanding different types of backupsUnderstanding backup devicesCreating and verifying backupsRestoring a databaseDefining a recovery strategy
Overview of high availability and disaster recovery technologies in SQL ServerConfiguring failover cluster instancesDesigning availability groups solutionsConfiguring availability groups in SQL Server on LinuxAdministering availability groups
Authentication modesSecurity principalsPermissionsCommon security administration tasks
Privacy in the modern eraIntroducing security principles and protocolsProtecting the data platformAuditing with SQL Server and Azure SQL DatabaseSecuring Azure infrastructure as a service
Understanding isolation levels and concurrencyUnderstanding durability settings for performanceUnderstanding how SQL Server executes your queryUnderstanding advanced engine features for tuning queries
Designing clustered indexesDesigning rowstore nonclustered indexesUnderstanding columnstore indexesUnderstanding indexing in memory-optimized tablesUnderstanding index statisticsUnderstanding other types of indexes
Cloud computing and Microsoft AzureCloud models and SQL ServerCloud securityOther data services in Azure
Provisioning a logical SQL serverProvisioning a database in Azure SQL DatabaseProvisioning an elastic poolManaging database spaceSecurity in Azure SQL DatabasePreparing Azure SQL Database for disaster recovery
What is a Managed Instance?Creating a managed instanceEstablishing a connectionMigrating data to Managed InstanceDeleting a Managed InstanceNetwork requirements for Managed InstancesManaged Instance administration featuresAzure SQL AnalyticsSecurity of Managed InstanceData protection features
Migration Services OptionsCommon causes for migration failuresIntegration Runtime options for Migration ServicesBest Practices for security and resiliency during migration
A big data primerIntroducing Big Data ClustersDeploying Big Data ClustersBenefits of PolyBaseOperationalizing analytics with Machine Learning ServerLaunchpad service

Content preview from SQL Server 2019 Administration Inside Out

Chapter 13Protecting data through encryption, privacy and auditing

Privacy in the modern era

Introducing security principles and protocols

Protecting the data platform

Auditing with SQL Server and Azure SQL Database

Securing Azure infrastructure as a service

Security has become incredibly important to private industry and the public sector. The news shows that the number of leaks and hacks of sensitive information is increasing almost daily, and we data professionals are at the forefront of securing this information. Along with the technical features built into SQL Server and Azure SQL Database, organizations should embrace the guidelines in privacy laws worldwide for handling and managing customer information.

Continuing on from Chapter 12 ...

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 2022 Administration Inside Out

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

Microsoft SQL Server 2012 Internals

Bob Beauchemin Kalen Delaney Conor Cunningham, Jonathan Kehayias, Benjamin Nevarez, and Paul S. Randal

SQL Server 2017 Administration Inside Out

Eric Johnson

T-SQL Querying

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

Publisher Resources

ISBN: 9780135561034