SQL Server 2019 Revealed: Including Big Data Clusters and Machine Learning
Get up to speed on the game-changing developments in SQL Server 2019. No longer your grandparent's database engine, SQL Server 2019 is cutting edge with support for artificial intelligence (AI), machine learning (ML), big data performance and analysis, Java, and connections to Azure IOT Edge. This is not a book on traditional database administration and SQL. It focuses on all that is new and cutting edge in one of the best database systems available. This is a book for SQL Server professionals who already know how to create tables and want to up their game by building their skills in some of the hottest new areas in technology.
SQL Server 2019 Revealed begins with a look at Big Data Clusters--a marquee feature of 2019--and their use in creating a unified data hub with connections to disparate data sources such as Oracle, MongoDB, and Hadoop. You will learn to build end-to-end data virtualization solutions involving Spark, SQL, and HDFS.
Also covered in the book is the use of SQL and Spark to build a machine learning platform for artificial intelligence applications. The book also dives into the details of new capabilities in performance, security, and availability such as Intelligent Query Processing, Secure Enclaves, and enhancements for Always On Availability Groups.
The book explores enhancements for SQL Server on Linux, containers, and goes into detail covering deployment and management of SQL Server on Kubernetes clusters. You will learn about a range of new enhancements across the database engine for SQL Server 2019, including how to leverage SQL Server in IOT Edge scenarios.
What You Will Learn
- Implement Big Data Clusters with SQL, Spark, and HDFS
- Create a Unified Data Hub with connections to MongoDB, Hadoop, Oracle, and other sources
- Combine SQL and Spark to build a machine learning platform for AI applications
- Increase security through Enclaves, Static Data Masking, and Data Classification
- Improve your ability to deploy on Linux using containers and Kubernetes
- Take advantage of SQL Graph, Java, and other new developer features
- Reap performance gains from persistent memory, query profiling, and Intelligent Query Processing
Who This Book Is For
IT professionals and developers who understand the fundamentals of SQL Server and wish to focus on learning about the new, cutting-edge features in SQL Server 2019. The book is for those who want to learn about SQL Server 2019's new Big Data Clusters and AI feature set, support for IOT Edge and Java, and increased capabilities around performance, security, and high availability.
Bob Ward is Principal Architect for the Microsoft Azure Data SQL Server team, which owns the development for all SQL Server releases. He has worked for Microsoft for more than 26 years on every version of SQL Server shipped from OS/2 1.1 to SQL Server 2019 including Azure. Bob is a well-known speaker on SQL Server, often presenting talks on new releases, internals, and performance at events such as PASS Summit, SQLBits, SQLIntersection, Red Hat Summit, Microsoft Inspire, and Microsoft Ignite. You can follow him at @bobwardms or linkedin.com/in/bobwardms. He is the author of the book Pro SQL Server on Linux (Apress).