Pro SQL Server on Linux: Including Container-Based Deployment with Docker and Kubernetes

Bob Ward

  • 出版商: Apress
  • 出版日期: 2018-10-28
  • 售價: $2,430
  • 貴賓價: 9.5$2,309
  • 語言: 英文
  • 頁數: 636
  • 裝訂: Paperback
  • ISBN: 1484241274
  • ISBN-13: 9781484241271
  • 相關分類: DockerKubernetesLinuxMSSQLSQL
  • 海外代購書籍(需單獨結帳)

買這商品的人也買了...

商品描述

Get SQL Server up and running on the Linux operating system and containers. No database professional managing or developing SQL Server on Linux will want to be without this deep and authoritative guide by one of the most respected experts on SQL Server in the industry. Get an inside look at how SQL Server for Linux works through the eyes of an engineer on the team that made it possible.

Microsoft SQL Server is one of the leading database platforms in the industry, and SQL Server 2017 offers developers and administrators the ability to run a database management system on Linux, offering proven support for enterprise-level features and without onerous licensing terms. Organizations invested in Microsoft and open source technologies are now able to run a unified database platform across all their operating system investments. Organizations are further able to take full advantage of containerization through popular platforms such as Docker and Kubernetes. 

Pro SQL Server on Linux walks you through installing and configuring SQL Server on the Linux platform. The author is one of the principal architects of SQL Server for Linux, and brings a corresponding depth of knowledge that no database professional or developer on Linux will want to be without. Throughout this book are internals of how SQL Server on Linux works including an in depth look at the innovative architecture.

The book covers day-to-day management and troubleshooting, including diagnostics and monitoring, the use of containers to manage deployments, and the use of self-tuning and the in-memory capabilities. Also covered are performance capabilities, high availability, and disaster recovery along with security and encryption. The book covers the product-specific knowledge to bring SQL Server and its powerful features to life on the Linux platform, including coverage of containerization through Docker and Kubernetes.


What You'll Learn

  • Learn about the history and internal of the unique SQL Server on Linux architecture.
  • Install and configure Microsoft’s flagship database product on the Linux platform
  • Manage your deployments using container technology through Docker and Kubernetes
  • Know the basics of building databases, the T-SQL language, and developing applications against SQL Server on Linux
  • Use tools and features to diagnose, manage, and monitor SQL Server on Linux
  • Scale your application by learning the performance capabilities of SQL Server
  • Deliver high availability and disaster recovery to ensure business continuity
  • Secure your database from attack, and protect sensitive data through encryption
  • Take advantage of powerful features such as Failover Clusters, Availability Groups, In-Memory Support, and SQL Server’s Self-Tuning Engine
  • Learn how to migrate your database from older releases of SQL Server and other database platforms such as Oracle and PostgreSQL
  • Build and maintain schemas, and perform management tasks from both GUI and command line

Who This Book Is For

Developers and IT professionals who are new to SQL Server and wish to configure it on the Linux operating system. This book is also useful to those familiar with SQL Server on Windows who want to learn the unique aspects of managing SQL Server on the Linux platform and Docker containers. Readers should have a grasp of relational database concepts and be comfortable with the SQL language. 

商品描述(中文翻譯)

在 Linux 作業系統和容器上運行 SQL Server。沒有一位在 Linux 上管理或開發 SQL Server 的資料庫專業人士會想錯過這本由業界最受尊敬的 SQL Server 專家之一撰寫的深入權威指南。透過這本書,您可以從實現 SQL Server for Linux 的團隊工程師的角度深入了解 SQL Server for Linux 的運作方式。

Microsoft SQL Server 是業界領先的資料庫平台之一,而 SQL Server 2017 提供開發人員和管理員在 Linux 上運行資料庫管理系統的能力,並提供對企業級功能的成熟支援,而不需要繁瑣的授權條款。投資於 Microsoft 和開源技術的組織現在能夠在所有操作系統投資中運行統一的資料庫平台。組織還能夠通過 Docker 和 Kubernetes 等流行平台充分利用容器化。

《Pro SQL Server on Linux》將引導您在 Linux 平台上安裝和配置 SQL Server。作者是 SQL Server for Linux 的主要架構師之一,擁有相應的深度知識,任何在 Linux 上的資料庫專業人士或開發人員都不會想錯過。本書涵蓋了 SQL Server on Linux 的內部運作方式,包括對創新架構的深入研究。

本書涵蓋了日常管理和故障排除,包括診斷和監控、使用容器管理部署以及自我調整和內存功能的使用。還介紹了性能能力、高可用性和災難恢復,以及安全性和加密。本書涵蓋了將 SQL Server 和其強大功能應用於 Linux 平台的產品特定知識,包括 Docker 和 Kubernetes 的容器化。

您將學到什麼:
- 了解獨特的 SQL Server on Linux 架構的歷史和內部運作方式。
- 在 Linux 平台上安裝和配置 Microsoft 的旗艦資料庫產品。
- 使用容器技術通過 Docker 和 Kubernetes 管理部署。
- 了解建立資料庫、T-SQL 語言和對 SQL Server on Linux 開發應用程序的基礎知識。
- 使用工具和功能診斷、管理和監控 SQL Server on Linux。
- 通過了解 SQL Server 的性能能力來擴展應用程序。
- 提供高可用性和災難恢復,確保業務連續性。
- 通過加密保護資料庫免受攻擊,保護敏感數據。
- 利用強大功能,如故障轉移叢集、可用性組、內存支援和 SQL Server 的自我調整引擎。
- 學習如何從舊版 SQL Server 和其他資料庫平台(如 Oracle 和 PostgreSQL)遷移資料庫。
- 從圖形用戶界面和命令行執行管理任務,建立和維護架構。

本書適合對 SQL Server 新手和希望在 Linux 作業系統上配置 SQL Server 的開發人員和 IT 專業人員。對於熟悉 Windows 上的 SQL Server 並希望了解在 Linux 平台和 Docker 容器上管理 SQL Server 的獨特方面的讀者也很有用。讀者應該對關聯式資料庫概念有一定了解,並熟悉 SQL 語言。