A Day of SQL Server 2019 Big Data Cluster with Niels Berglund and Andrew Collier

By Johannesburg Data Platform User Group https://www.dataandaicommunity.co.za/events/JHB-202404.html#Agenda

Fri Sep 6, 08:00 - Fri Sep 6, 16:30

Microsoft SA Bryanston office

ABOUT

The new release of SQL Server; SQL Server 2019 includes Apache Spark and Hadoop Distributed File System (HDFS) for scalable compute and storage. This new architecture that combines together the SQL Server database engine, Spark, and HDFS into a unified data platform is called a “big data cluster.”

In this one day workshop you will learn the architecture of the Big Data Cluster (BDC), and the various components of a BDC. You will see how to create external tables against other data sources than SQL Server, and how to use Spark to run big queries over your data in HDFS or do data preparation. We also look at how to use Notebooks to run code for Spark as well as SQL.

To get the most out of the workshop, please bring a laptop with Azure Data Studio installed together with the "SQL Server 2019 (preview)" extension for Azure Data Studio.