SQL Server 2022 Administration Inside Out,9780137899883

SQL Server 2022 Administration Inside Out

by ; ; ; ; ;
Edition: 1st
ISBN13: 9780137899883
ISBN10: 0137899882
Format: Paperback
Pub. Date: 2023-05-11
Publisher(s): Microsoft Press
  • Complimentary 7-Day eTextbook Access - Read more
    When you rent or buy this book, you will receive complimentary 7-day online access to the eTextbook version from your PC, Mac, tablet, or smartphone. Feature not included on Marketplace Items.
  • eCampus.com Device Compatibility Matrix

    Click the device icon to install or view instructions

    Apple iOS | iPad, iPhone, iPod
    Apple iOS | iPad, iPhone, iPod
    Android Devices | Android Tables & Phones OS 2.2 or higher | *Kindle Fire
    Android Devices | Android Tables & Phones OS 2.2 or higher | *Kindle Fire
    Windows 10 / 8 / 7 / Vista / XP
    Windows 10 / 8 / 7 / Vista / XP
    Mac OS X | **iMac / Macbook
    Mac OS X | **iMac / Macbook
    Enjoy offline reading with these devices
    Apple Devices
    Android Devices
    Windows Devices
    Mac Devices
    iPad, iPhone, iPod
    Our reader is compatible
     
     
     
    Android 2.2 +
     
    Our reader is compatible
     
     
    Kindle Fire
     
    Our reader is compatible
     
     
    Windows
    10 / 8 / 7 / Vista / XP
     
     
    Our reader is compatible
     
    Mac
     
     
     
    Our reader is compatible
List Price: $64.82

Buy New

Usually Ships in 2-3 Business Days
$61.73
Add to Cart

Rent Book

Select for Price
Add to Cart
There was a problem. Please try again later.

Rent Digital

Rent Digital Options
Online:1825 Days access
Downloadable:Lifetime Access
$69.59
Online:1825 Days access
Downloadable:Lifetime Access
$69.59
*To support the delivery of the digital material to you, a digital delivery fee of $3.99 will be charged on each digital item.
$69.59*
Add to Cart

Used Book

We're Sorry
Sold Out

Buy from our Marketplace starting at $53.13

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

Conquer SQL Server 2022 administration—from the inside out

Dive into SQL Server 2022 administration—and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds—all you need to plan, implement, manage, and secure SQL Server 2022 in any production environment: on-premises, cloud, or hybrid. Seven experts thoroughly tour DBA capabilities available in SQL Server 2022 Database Engine, SQL Server Data Tools, SQL Server Management Studio, PowerShell, and Azure Portal. You'll find extensive new coverage of Azure SQL, big data clusters, PolyBase, data protection, automation, and more. Discover how experts tackle today's essential tasks–and challenge yourself to new levels of mastery.

  • Explore SQL Server 2022's toolset, including the improved SQL Server Management Studio, Azure Data Studio, and Configuration Manager
  • Design, implement, manage, and govern on-premises, hybrid, or Azure database infrastructures
  • Install and configure SQL Server on Windows and Linux
  • Master modern maintenance and monitoring with extended events, Resource Governor, and the SQL Assessment API
  • Automate tasks with maintenance plans, PowerShell, Policy-Based Management, and more
  • Plan and manage data recovery, including hybrid backup/restore, Azure SQL Database recovery, and geo-replication
  • Use availability groups for high availability and disaster recovery
  • Protect data with Transparent Data Encryption, Always Encrypted, new Certificate Management capabilities, and other advances
  • Optimize databases with SQL Server 2022's advanced performance and indexing features
  • Provision and operate Azure SQL Database and its managed instances
  •  Move SQL Server workloads to Azure: planning, testing, migration, and post-migration

Table of Contents

Chapter 1 Get started with SQL Server tools

Chapter 2 Introduction to database server components

Chapter 3 Design and implement an on-premises database infrastructure

Chapter 4 Install and Configure SQL Server instances and features

Chapter 5 Install and Configure SQL Server on Linux

Chapter 6 Provision and Configure SQL Server databases

Chapter 7 Understand table features

Chapter 8 Maintaining and monitoring SQL Server

Chapter 9 Automating SQL Server administration

Chapter 10 Develop, Deploy, and Manage data recovery

Chapter 11 Implement high availability and disaster recovery

Chapter 12 Administering security and permissions

Chapter 13 Protecting data through classification, encryption, and auditing

Chapter 14 Performance tuning SQL Server

Chapter 15 Understand and Design indexes

Chapter 16 Design and Implement hybrid and Azure database infrastructure

Chapter 17 Provision Azure SQL Database

Chapter 18 Provision Azure SQL Database managed instance

Chapter 19 Migrating to SQL Server solutions in Azure

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.