-
Book Overview & Buying
-
Table Of Contents
Introducing Microsoft SQL Server 2019
By :
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.
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.
You can...