A guide to one of SQL Server 2019’s latest and most impactful features. Big Data Clusters are a feature set covering data virtualization and data lakes, and providing a complete AI platform within the SQL Server database engine. This book shows you how to use Big Data Clusters to combine large volumes of streaming data for analysis along with data stored relationally in a traditional database. For example, you can stream large volumes of data from Apache Spark in real-time while executing Transact-SQL queries to bring in relevant additional data from your corporate, SQL Server database. Filled with clear examples and use-cases, provides everything necessary to get started working with SQL Server Big Data Clusters. You’ll learn about the architectural foundations that are made from Spark, HDFS, and PolyBase. The book then shows you how to configure and deploy Big Data Clusters in SQL Server 2019. Next, you’ll learn about querying. You’ll learn to write queries in Transact-SQL – taking advantage of skills you have honed for years – and those queries are able to examine and analyze data from a wide variety of sources such as MongoDB, HDFS, Oracle, and yes, even SQL Server. Throughout this book you’ll gain a deeper understanding of SQL Server 2019’s marquee feature – Big Data Clusters. By combining the theoretical foundation with easy to follow example scripts and exercises, you will be ready to use and unveil the full potential in SQL Server 2019 of being able to simultaneously query streaming and static data, and to combine data from widely disparate sources into a single view that’s useful for business intelligence and machine learning analysis.  For data engineers, data scientists, data architects, and database administrators who want to employ data virtualization and big data analytics in their environment weiterlesen