SQL Server 2019 فاش شده: شامل خوشه‌های داده بزرگ و یادگیری ماشین

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-critical availability, 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-critical availability, 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-critical availability, 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. You will: 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 chang es 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 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. Front Matter ....Pages i-xxii Why SQL Server 2019? (Bob Ward)....Pages 1-17 Intelligent Performance (Bob Ward)....Pages 19-85 New Security Capabilities (Bob Ward)....Pages 87-114 Mission-Critical Availability (Bob Ward)....Pages 115-145 Modern Development Platform (Bob Ward)....Pages 147-174 SQL Server 2019 on Linux (Bob Ward)....Pages 175-194 Inside SQL Server Containers (Bob Ward)....Pages 195-247 SQL Server on Kubernetes (Bob Ward)....Pages 249-295 SQL Server Data Virtualization (Bob Ward)....Pages 297-329 SQL Server Big Data Clusters (Bob Ward)....Pages 331-382 The Voice of the Customer and Migration (Bob Ward)....Pages 383-412 Back Matter ....Pages 413-422