You're reading from Introducing Microsoft SQL Server 2019 Reliability, scalability, and security both on premises and in the cloud

Product type Paperback

Published in Apr 2020

Publisher Packt

ISBN-13 9781838826215

Length 488 pages

Edition 1st Edition

Languages

SQL

Tools

SQL Server

Concepts

Database Administration

Authors (8):

Allan Hirt

Dustin Ryan

Mitchell Pearson

Kellyn Gorman

Dave Noderer

Buck Woody

Arun Sirpal

James Rowland-Jones

+4 more

View More author details

Table of Contents (15) Chapters

Preface

About Microsoft SQL Server 2019

1. Optimizing for performance, scalability and real‑time insights

2. Enterprise Security FREE CHAPTER

3. High Availability and Disaster Recovery

4. Hybrid Features – SQL Server and Microsoft Azure

5. SQL Server 2019 on Linux

6. SQL Server 2019 in Containers and Kubernetes

7. Data Virtualization

8. Machine Learning Services Extensibility Framework

9. SQL Server 2019 Big Data Clusters

10. Enhancing the Developer Experience

11. Data Warehousing

12. Analysis Services

13. Power BI Report Server

14. Modernization to the Azure Cloud

Programming SQL Server 2019 big data clusters

After you install your SQL Server 2019 big data cluster, it's time to put it to use. While the options for applications using big data clusters range from almost anything you can do with SQL Server to working with Spark, there are four general areas for using the system, with all ranges of data sizes: Online Transactional Processing (OLTP)/standard queries, data virtualization, as a data mart, and as a data lake with Spark processing capabilities.

Note

It's helpful to refer back to the complete architecture diagram to understand the flow of each of the following operations.

With all of these features in a single location, you can query across multiple systems, in multiple databases and formats, using Transact-SQL. It makes SQL Server your organization's data hub.

Let's start with an examination of the Azure Data Studio tool that you can use to work with big data clusters.