SQL Server 2017 Developer's Guide

Dejan Sarka, Milos Radivojevic, William Durkin

  • 出版商: Packt Publishing
  • 出版日期: 2018-03-15
  • 定價: $1,650
  • 售價: 6.0$990
  • 語言: 英文
  • 頁數: 826
  • 裝訂: Paperback
  • ISBN: 1788476190
  • ISBN-13: 9781788476195
  • 相關分類: MSSQLSQL
  • 立即出貨 (庫存=1)



Build smarter and efficient database application systems for your organization with SQLServer 2017 About This Book * Build efficient database applications by utilizing the efficient development features of SQL Server 2017 * Work with temporal tables to get information stored in a table at any time and use adaptive querying to enhance the performance of your queries * A detailed guide for developers looking to master SQL Server 2017's new features and enhancements Who This Book Is For Database developers and solution architects looking to design efficient database applications using SQL Server 2017 will find this book very useful. Some basic understanding of database concepts and T-SQL is required to get the best out of this book. What You Will Learn * Explore the new development features introduced in SQL Server 2017 * Identify opportunities for In-Memory OLTP technology, significantly enhanced in SQL Server 2017 * Use columnstore indexes to get significant storage and performance improvements * Extend database design solutions using temporal tables * Exchange JSON data between applications and SQL Server in a more efficient way * Migrate historical data transparently and securely to Microsoft Azure by using Stretch database * Use the new security features to encrypt (or to have more granular control over) access to rows in a table * Simplify performance troubleshooting with Query Store * Discover the potential of R and Python integration with SQL Server * Model data and complex relationships with the help of graph databases in SQL Server 2017 * Experience the speed and automation offered by SQL Server containers and SQL on Linux for Dev and QA In Detail Microsoft SQL Server 2017 is the next big step in the data platform history of Microsoft as it brings in the power of R and Python for machine learning and containerization-based deployment on Windows and Linux . Compared to its predecessor, SQL Server 2017 has evolved into Machine Learning with R services for statistic analysis and Python packages for analytical processing. This book prepares you for more advanced topics by starting with a quick introduction to SQL Server 2017's new features and a recapitulation of the possibilities you may have already explored with previous versions of SQL Server. The next part introduces you to small delights in the form of the Transact-SQL language and then switches to a completely new technology inside SQL Server: JSON support. We also take a look at the Stretch database, security enhancements, and temporal tables. Furthermore the book focuses on implementing advanced topics, including Query Store, columnstore indexes, and In-Memory OLTP. Towards the end of the book, you'll be introduced to R and how to use the R language with Transact-SQL for data exploration and analysis. You'll also learn to integrate Python packages in SQL Server and graph database implementations along with deployment options on Linux and SQL Server in containers for development and testing. By the end of this book, you will have the required information to design efficient, high-performance database applications without any hassle.


使用SQL Server 2017為您的組織建立更智能和高效的數據庫應用系統 關於本書 * 通過利用SQL Server 2017的高效開發功能來構建高效的數據庫應用程序 * 使用時間表來獲取在任何時間存儲在表中的信息,並使用自適應查詢來提高查詢性能 * 面向開發人員的詳細指南,旨在掌握SQL Server 2017的新功能和增強功能 本書適合尋求使用SQL Server 2017設計高效數據庫應用程序的數據庫開發人員和解決方案架構師。需要對數據庫概念和T-SQL有一定的基本理解,以充分利用本書的內容。 您將學到什麼 * 探索SQL Server 2017中引入的新開發功能 * 確定In-Memory OLTP技術的機會,在SQL Server 2017中得到顯著增強 * 使用列存儲索引獲得顯著的存儲和性能改進 * 使用時間表擴展數據庫設計解決方案 * 以更高效的方式在應用程序和SQL Server之間交換JSON數據 * 通過使用Stretch數據庫將歷史數據透明且安全地遷移到Microsoft Azure * 使用新的安全功能對表中的行進行加密(或更精細地控制) * 使用查詢存儲簡化性能故障排除 * 了解R和Python與SQL Server的集成潛力 * 使用SQL Server 2017中的圖形數據庫對數據和複雜關係進行建模 * 通過SQL Server容器和Dev和QA中的Linux上的SQL獲得的速度和自動化 在詳細介紹中,Microsoft SQL Server 2017是Microsoft數據平台歷史上的下一個重要步驟,它引入了R和Python的機器學習和基於容器化的Windows和Linux部署。與前身相比,SQL Server 2017已發展成為具有R服務的機器學習和具有Python包的分析處理的統計分析。本書通過快速介紹SQL Server 2017的新功能和對以前版本的SQL Server已經探索過的可能性的回顧,為您準備更高級的主題。下一部分向您介紹了以Transact-SQL語言為基礎的小技巧,然後轉向SQL Server內部的全新技術:JSON支持。我們還研究了Stretch數據庫、安全增強功能和時間表。此外,本書還關注實施高級主題,包括查詢存儲、列存儲索引和In-Memory OLTP。在本書的最後,您將介紹R以及如何使用R語言與Transact-SQL進行數據探索和分析。您還將學習將Python包集成到SQL Server中,以及在Linux上的SQL Server和SQL Server容器中的部署選項進行開發和測試。通過本書,您將獲得設計高效、高性能數據庫應用程序所需的信息,無需任何麻煩。