Home > Store

SQL Server 2019 Administration Inside Out

Register your product to gain access to bonus material or receive a coupon.

SQL Server 2019 Administration Inside Out

Best Value Purchase

Book + eBook Bundle

  • Your Price: $64.79
  • List Price: $107.98
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

More Purchase Options

Book

  • Your Price: $47.99
  • List Price: $59.99
  • Estimated Release: Mar 16, 2020

eBook (Watermarked)

  • Your Price: $38.39
  • List Price: $47.99
  • Estimated Release: Mar 16, 2020
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

About

Features

  • 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

Description

  • Copyright 2020
  • Dimensions: 7-3/8" x 9-1/8"
  • Pages: 864
  • Edition: 1st
  • Book
  • ISBN-10: 0-13-556108-6
  • ISBN-13: 978-0-13-556108-9

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

Sample Content

Table of Contents

Chapter 1 Getting started with SQL Server tools Chapter 2 Introducing database server components Chapter 3 Designing and implementing a database infrastructureChapter 4 Installing and Configuring SQL Server Instances and FeaturesChapter 5 (temporary chapter label) Installing and Leveraging Machine Learning Services Chapter 6 Provisioning and Configuring SQL Server Databases Chapter 7 Provisioning Azure SQL Database 197Chapter 8 (temporary Chapter Label) 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 ServerChapter 14 Understanding and designing indexes Chapter 15 Developing, deploying, and managing data recoveryChapter 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 AzureChapter 20 SQL on Linux install and configurationChapter 21 SQL in Containers

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership