You're reading from SQL Server 2019 Administrator's Guide A definitive guide for DBAs to implement, monitor, and maintain enterprise database solutions

Product type Paperback

Published in Sep 2020

Publisher Packt

ISBN-13 9781789954326

Length 522 pages

Edition 2nd Edition

Languages

SQL

Tools

SQL Server

Concepts

Database Administration

Authors (2):

Marek Chmel

Vladimír Mužný

View More author details

Table of Contents (17) Chapters

Preface

1. Section 1: Provisioning the SQL Server Environment

2. Chapter 1: Setting Up SQL Server 2019 FREE CHAPTER

3. Chapter 2: Keeping Your SQL Server Environment Healthy

4. Section 2: Server and Database Maintenance

5. Chapter 3: Implementing Backup and Recovery

6. Chapter 4: Securing Your SQL Server

7. Chapter 5: Working with Disaster Recovery Options

8. Chapter 6: Indexing and Performance

9. Section 3: High Availability and the Cloud with SQL Server 2019

10. Chapter 7: Planning Migration and Upgrade

11. Chapter 8: Automation – Using Tools to Manage and Monitor SQL Server 2019

12. Chapter 9: Configuring Always On High Availability Features

13. Chapter 10: In-Memory OLTP – Why and How to Use it

14. Chapter 11: Combining SQL Server 2019 with Azure

15. Chapter 12: Taming Big Data with SQL Server

16. Other Books You May Enjoy

Leave a review - let other readers know what you think

Explaining the SQL Server Big Data Clusters architecture and deployment

SQL Server Big Data Clusters (BDC) is a piece of technology – a combination of three distinct services – available in the latest release of SQL Server. The BDC combine SQL Server, Apache Spark, and the HDFS filesystem to store data. All three components run in the Kubernetes environment. These three components run side-by-side to provide you with the capability to process and analyze big data, as well as combine a relational workload with a big data workload.

The BDC heavily rely on numerous open source technologies, which are used together for deploying, maintaining, and monitoring the solution.

BDC deployment is based on a full installation of SQL Server 2019 running in a container based on a Linux OS image, orchestrated via the Kubernetes engine. You can use various Kubernetes environments, such as the following: