SQL Server 2019 Administration Inside Out by William Assaf (English) Paperback B

Back Cover

The definitive one-stop SQL Server 2019 database administration resource for all working DBAs Includes coverage of features introduced in SQL Server 2019 Serves as a complete reference for the modern SQL DBA Readers can upgrade SQL Server Administration skillset to SQL Server 2019, plus Azure SQL Databases, Azure SQL Database Managed Instances, and SQL on Linux Covers Migration strategies, automation with PowerShell, and proven implementation strategies for High Availability solutions Microsoft SQL server; SQL Server; SQL Server 2019; database administration; DBA; sql server training; sql server guide; sql server book; sql server reference; learning sql server; Azure

Table of Contents

Chapter 1 Getting started with SQL Server tools
Chapter 2 Introducing database server components
Chapter 3 Designing and implementing a database infrastructure
Chapter 4 Installing and Configuring SQL Server Instances and Features
Chapter 5 Installing and Leveraging Machine Learning Services
Chapter 6 Provisioning and Configuring SQL Server Databases
Chapter 7 Provisioning Azure SQL Database
Chapter 8 Provisioning Azure SQL Database Managed Instances
Chapter 9 Administering security and permissions
Chapter 10 Securing and Auditing SQL Instances.
Chapter 11 Securing Data
Chapter 12 Understanding and designing tables
Chapter 13 Performance tuning SQL Server
Chapter 14 Understanding and designing indexes
Chapter 15 Developing, deploying, and managing data recovery
Chapter 16 Implementing high availability and disaster recovery
Chapter 17 Managing and monitoring SQL Server
Chapter 18 Automating SQL Server administration
Chapter 19 Migrating to SQL Server Solutions in Azure
Chapter 20 SQL on Linux install and configuration
Chapter 21 SQL in Containers

Long Description

Conquer SQL Server 2019 administration-from the inside out Dive into SQL Server 2019 administration-and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of time-saving solutions, tips, and workarounds-all you need to plan, implement, manage, and secure SQL Server 2019 in any production environment: on-premises, cloud, or hybrid. SQL Server experts offer a complete tour of DBA capabilities available in SQL Server 2019 Database Engine, SQL Server Data Tools, SQL Server Management Studio, and via PowerShell. Discover how experts tackle today's essential tasks-and challenge yourself to new levels of mastery. Install, customize, and use SQL Server 2019's key administration and development tools Manage memory, storage, clustering, virtualization, and other components Architect and implement database infrastructure, including IaaS, Azure SQL, and hybrid cloud configurations Provision SQL Server and Azure SQL databases Secure SQL Server via encryption, row-level security, and data masking Safeguard Azure SQL databases using platform threat protection, firewalling, and auditing Establish SQL Server IaaS network security groups and user-defined routes Administer SQL Server user security and permissions Efficiently design tables using keys, data types, columns, partitioning, and views Utilize BLOBs and external, temporal, and memory-optimized tables Master powerful optimization techniques involving concurrency, indexing, parallelism, and execution plans Plan, deploy, and perform disaster recovery in traditional, cloud, and hybrid environments For Experienced SQL Server Administrators and Other Database Professionals Your role: Intermediate-to-advanced level SQL Server database administrator, architect, developer

Feature

The definitive one-stop SQL Server 2019 database administration resource for all working DBAs Includes coverage of features introduced in SQL Server 2019 Serves as a complete reference for the modern SQL DBA Readers can upgrade SQL Server Administration skillset to SQL Server 2019, plus Azure SQL Databases, Azure SQL Database Managed Instances, and SQL on Linux Covers Migration strategies, automation with PowerShell, and proven implementation strategies for High Availability solutions

New Feature

Coverage of new features introduced in SQL Server 2019 such as Azure SQL Database Managed Instance, as well as coverage on On-Prem to Azure Migrations, On-Prem to PaaS Migrations. More new features to be named later.

Details