SQL Server 2019 Revealed: Including Big Data Clusters and Machine Learning

Ward, Bob

  • 出版商: Apress
  • 出版日期: 2019-10-19
  • 售價: $1,670
  • 貴賓價: 9.5$1,587
  • 語言: 英文
  • 頁數: 421
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 148425418X
  • ISBN-13: 9781484254189
  • 相關分類: MSSQLSQL大數據 Big-dataMachine 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.

商品描述(中文翻譯)

《SQL Server 2019揭秘》讓您了解SQL Server 2019中的重大變革。SQL Server 2019不再是您祖父母的資料庫引擎,它支援人工智慧(AI)、機器學習(ML)、大數據性能和分析、Java以及與Azure IOT Edge的連接,處於尖端地位。這不是一本關於傳統資料庫管理和SQL的書籍,它專注於介紹這個最佳資料庫系統中的所有新功能和尖端技術。這本書適合已經知道如何建立表格的SQL Server專業人士,他們希望通過在技術領域中一些最熱門的新領域中提升自己的技能。

《SQL Server 2019揭秘》首先介紹了Big Data Clusters,這是2019年的一個重要功能,它們用於創建與Oracle、MongoDB和Hadoop等不同數據源的連接的統一數據中心。您將學習如何構建涉及Spark、SQL和HDFS的端到端數據虛擬化解決方案。

書中還介紹了使用SQL和Spark構建人工智慧應用的機器學習平台。書中還深入探討了性能、安全性和可用性方面的新功能,例如智能查詢處理、安全飛地和Always On可用性組的增強功能。

本書還探討了SQL Server在Linux、容器上的增強功能,並詳細介紹了在Kubernetes集群上部署和管理SQL Server。您將了解SQL Server 2019中資料庫引擎的一系列新增功能,包括如何在IOT Edge場景中利用SQL Server。

《SQL Server 2019揭秘》還介紹了使用SQL、Spark和HDFS實現Big Data Clusters、創建與MongoDB、Hadoop、Oracle和其他數據源的統一數據中心、結合SQL和Spark構建人工智慧應用的機器學習平台、通過飛地、靜態數據遮罩和數據分類提高安全性、使用容器和Kubernetes在Linux上部署的能力、利用SQL Graph、Java和其他新的開發者功能、從持久內存、查詢分析和智能查詢處理中獲得性能提升。

本書適合IT專業人士和開發人員,他們了解SQL Server的基礎知識,並希望專注於學習SQL Server 2019的新功能,如Big Data Clusters和AI功能集、對IOT Edge和Java的支援以及在性能、安全性和高可用性方面的增強功能。

作者簡介

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).

 

 

作者簡介(中文翻譯)

Bob Ward是Microsoft Azure Data SQL Server團隊的首席架構師,該團隊負責所有SQL Server版本的開發。他在Microsoft工作超過26年,參與了從OS/2 1.1到SQL Server 2019以及Azure的每個版本的開發。Bob是SQL Server領域中知名的演講者,經常在PASS Summit、SQLBits、SQLIntersection、Red Hat Summit、Microsoft Inspire和Microsoft Ignite等活動上演講,內容涵蓋新版本、內部結構和性能等方面。您可以在Twitter上關注他的@bobwardms或訪問linkedin.com/in/bobwardms。他還是書籍《Pro SQL Server on Linux》(Apress)的作者。