Overview
- Provides in-depth insider content on cutting-edge 2019 capabilities
- Is comprehensive with deep examples and references
- Covers the most up-to-date details of the SQL Server 2019 release
- Includes behind-the-scenes background information from members of the SQL Engineering team
- Guides SQL Server professionals toward modern career-building skills
Access this book
Tax calculation will be finalised at checkout
Other ways to access
Table of contents (11 chapters)
Keywords
About this book
SQL Server 2019 Revealed begins with a look at the project's team goal to integrate the world of big data with SQL Server into a major product release. The book then dives into the details of key new capabilities in SQL Server 2019 using a “learn by example” approach for Intelligent Performance, security, mission-criticalavailability, and features for the modern developer. Also covered are enhancements to SQL Server 2019 for Linux and gain a comprehensive look at SQL Server using containers and Kubernetes clusters.
The book concludes by showing you how to virtualize your data access with Polybase to Oracle, MongoDB, Hadoop, and Azure, allowing you to reduce the need for expensive extract, transform, and load (ETL) applications. You will then learn how to take your knowledge of containers, Kubernetes, and Polybase to build a comprehensive solution called Big Data Clusters, which is a marquee feature of 2019. You will also learn how to gain access to Spark, SQL Server, and HDFS to build intelligence over your own data lake and deploy end-to-end machine learning applications.
What You Will Learn
- Implement Big Data Clusters with SQL Server, Spark, and HDFS
- Create a Data Hub with connections to Oracle, Azure, Hadoop, and other sources
- Combine SQL and Spark to build a machine learning platform for AI applications
- Boost your performance with no application changes using Intelligent Performance
- Increase security of your SQL Server through Secure Enclaves and Data Classification
- Maximize database uptime through online indexing and Accelerated Database Recovery
- Build new modern applications with Graph, ML Services, and T-SQL Extensibility with Java
- Improve your ability to deploy SQL Server on Linux
- Gain in-depth knowledge to run SQL Server with containers and Kubernetes
- Know all the new database engine features for performance, usability, and diagnostics
- Use the latest tools and methods to migrate your database to SQL Server 2019
- Apply your knowledge of SQL Server 2019 to Azure
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, modern capabilities of SQL Server 2019. The book is for those who want to learn about SQL Server 2019 and the new Big Data Clusters and AI feature set, support for machine learning and Java, how to run SQL Server with containers and Kubernetes, and increased capabilities around Intelligent Performance, advanced security, and high availability.
Authors and Affiliations
About the author
Bibliographic Information
Book Title: SQL Server 2019 Revealed
Book Subtitle: Including Big Data Clusters and Machine Learning
Authors: Bob Ward
DOI: https://doi.org/10.1007/978-1-4842-5419-6
Publisher: Apress Berkeley, CA
eBook Packages: Professional and Applied Computing, Apress Access Books, Professional and Applied Computing (R0)
Copyright Information: Bob Ward 2019
Softcover ISBN: 978-1-4842-5418-9Published: 19 October 2019
eBook ISBN: 978-1-4842-5419-6Published: 18 October 2019
Edition Number: 1
Number of Pages: XXII, 422
Number of Illustrations: 128 b/w illustrations
Topics: Database Management, Microsoft and .NET