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

Book Description

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.

Table of Contents

Chapter 1: Why SQL Server on Linux?
Chapter 2: Install and Configuration
Chapter 3: Building a Database and T-SQL Fundamentals
Chapter 4: Building an Application and Advanced T-SQL
Chapter 5: SQL Server Tools
Chapter 6: Performance Capabilities
Chapter 7: Security in SQL Server
Chapter 8: High Availability and Disaster Recovery for SQL Server
Chapter 9: Managing and Monitoring SQL Server
Chapter 10: Migrating to SQL Server on Linux
Chapter 11: SQL Server and Containers
Chapter 12: Epilogue

中文：

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

在Linux操作系统和容器上启动并运行SQL Server。任何在Linux上管理或开发SQL Server的数据库专业人员都不会希望没有这位业内最受尊敬的SQL Server专家之一提供的深入而权威的指导。通过团队中的一名工程师深入了解SQL Server for Linux是如何工作的。

Microsoft SQL Server是业界领先的数据库平台之一，SQL Server 2017为开发人员和管理员提供了在Linux上运行数据库管理系统的能力，为企业级功能提供了成熟的支持，并且没有繁琐的许可条款。投资于微软和开源技术的组织现在能够在其所有操作系统投资中运行统一的数据库平台。各组织还能够通过Docker和Kubernetes等流行平台充分利用集装箱化。

Linux上的Pro SQL Server将指导您在Linux平台上安装和配置SQL Server。作者是SQL Server for Linux的主要架构师之一，他带来了相应的深入知识，这是任何Linux数据库专业人员或开发人员都不想缺少的。本书贯穿了SQL Server on Linux的工作原理，包括对创新体系结构的深入了解。

这本书介绍了日常管理和故障排除，包括诊断和监控，使用容器来管理部署，以及使用自调优和内存功能。此外，还包括性能功能、高可用性和灾难恢复以及安全和加密。这本书涵盖了将SQL Server及其强大的功能引入Linux平台的特定产品知识，包括通过Docker和Kubernetes实现的容器化。

你会学到什么？

• 了解独特的SQL Server on Linux体系结构的历史和内部信息。
• 在Linux平台上安装和配置微软的旗舰数据库产品
• 通过Docker和Kubernetes使用容器技术管理您的部署
• 了解在Linux上针对SQL Server构建数据库、T-SQL语言和开发应用程序的基础知识
• 使用工具和功能诊断、管理和监控Linux上的SQL Server
• 通过了解SQL Server的性能功能来扩展您的应用程序
• Deliver high availability and disaster recovery to ensure business continuity
• 保护您的数据库免受攻击，并通过加密保护敏感数据
• 充分利用故障转移群集、可用性组、内存支持和SQL Server自调优引擎等强大功能
• 了解如何从旧版本的SQL Server和其他数据库平台(如Oracle和PostgreSQL)迁移数据库
• 构建和维护架构，并从图形用户界面和命令行执行管理任务 

这本书是为谁写的

不熟悉SQL Server并希望在Linux操作系统上配置它的开发人员和IT专业人员。这本书对那些熟悉Windows上的SQL Server的人也很有用，他们想要了解在Linux平台和Docker Containers上管理SQL Server的独特方面。读者应该掌握关系数据库的概念，并熟悉SQL语言。

目录表

第1章：为什么选择在Linux上运行SQL Server？
第2章：安装和配置
第三章：构建数据库和T-SQL基础知识
第4章：构建高级应用程序和高级T-SQL
Chapter 5: SQL Server Tools
第6章：性能能力
第7章：SQL Server的安全性
第8章：SQL Server的高可用性和灾难恢复
Chapter 9: Managing and Monitoring SQL Server
第10章：在Windows Linux上迁移到SQL Server
第11章：SQL Server和30个容器
第十二章：结语