Bob Ward: SQL Server 2019 Revealed

Get up to speed on the game-changing developments in SQL Server 2019. No longer just a database engine, SQL Server 2019 is cutting edge with support for machine learning (ML), big data analytics, Linux, containers, Kubernetes, Java, and data virtualization to Azure. This is not a book on traditional database administration for SQL Server. It focuses on all that is new for one of the most successful modernized data platforms in the industry. It is a book for data professionals who already know the fundamentals of SQL Server 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 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.

Get up to speed on the game-changing developments in SQL Server 2019. No longer just a database engine, SQL Server 2019 is cutting edge with support for machine learning (ML), big data analytics, Linux, containers, Kubernetes, Java, and data virtualization to Azure. This is not a book on traditional database administration for SQL Server. It focuses on all that is new for one of the most successful modernized data platforms in the industry. It is a book for data professionals who already know the fundamentals of SQL Server 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 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.

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 [...] or [...] He is the author of the book Pro SQL Server on Linux (Apress).

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

1. Why SQL Server 2019?.- 2. Intelligent Performance.- 3. New Security Capabilities.- 4. Mission Critical Availability.- 5. Modern Development Platform.- 6. SQL Server 2019 on Linux.- 7. Inside SQL Server Containers.- 8. SQL Server on Kubernetes.- 9. SQL Server Data Virtualization.- 10. SQL Server Big Data Clusters.- 11. The Voice of the Customer and Migration.

Erscheinungsjahr:	2019
Genre:	Importe , Informatik
Rubrik:	Naturwissenschaften & Technik
Medium:	Taschenbuch
Inhalt:	xxii 422 S. 128 s/w Illustr. 422 p. 128 illus.
ISBN-13:	9781484254189
ISBN-10:	148425418X
Sprache:	Englisch
Einband:	Kartoniert / Broschiert
Autor:	Ward, Bob
Auflage:	First Edition
Hersteller:	Apress Apress L.P.
Verantwortliche Person für die EU:	APress in Springer Science + Business Media, Heidelberger Platz 3, D-14197 Berlin, juergen.hartmann@springer.com
Maße:	254 x 178 x 24 mm
Von/Mit:	Bob Ward
Erscheinungsdatum:	22.10.2019
Gewicht:	0,829 kg