SQL Server on Linux Operations in Practice

Name: SQL Server on Linux Operations in Practice
ISBN: 9787115502421

黄钊吉 / 熊章立Posts & Telecom Press · ChinaJul 2019

3.5

Word count: 389K words
Chapters: 150
ISBN: 9787115502421

Report an error Find this book

Summary

As Microsoft deepens its open-source strategy, SQL Server—its flagship database product—can now run not only on Windows but, after a series of product iterations, stably on mainstream Linux platforms, gaining growing recognition among enterprises. To keep pace with the times, practitioners need to master the use of SQL Server on Linux as soon as possible. This is an introductory technical book aimed primarily at database practitioners who have a basic understanding of Microsoft SQL Server and wish to master SQL Server operations and performance optimization on Linux. It is also suitable for students to lay a solid foundation for future employment. Focusing on hands-on practice, the book covers installation, configuration, monitoring, and high-availability setup of SQL Server on Linux, and incorporates the author's decade of experience in Linux and SQL Server performance optimization to help readers get started faster. The book consists of five parts—fundamentals, management, performance, architecture, and case studies—each containing several chapters, with each chapter striving to explain one technical point thoroughly. In writing, the author attends to both systematicity and practicality, aiming to make the book a frequently consulted reference. All cases are drawn from practice and are intended to help readers learn the key points and appreciate the author's approach to operations and optimization.

Editor's review

SQL Server On Linux in Practice is one of the few technical monographs in recent years dedicated to cross-platform SQL Server operations. As Microsoft embraces the open-source ecosystem, deploying SQL Server on Linux has become a new trend in enterprise database architecture, and this book fills the gap for systematic practical guidance in this area. Drawing on years of frontline operations experience, the author Huang Zhaozhe goes beyond conceptual introductions to dissect the entire workflow from planning and deployment to performance tuning and high-availability architecture.\n\nThe book's most prominent value lies in its practice orientation—it includes numerous validated configuration scripts and troubleshooting cases and, more importantly, provides solutions tailored to Linux environment characteristics (such as systemd service management and XFS file system optimization). Compared with traditional Windows-platform SQL Server materials, the chapter on containerized deployment is particularly noteworthy, keeping pace with cloud-native trends and offering reliable reference for modern data center architectures.\n\nIn terms of depth, the book balances basic operations with advanced optimization, making it suitable both for Windows DBAs transitioning smoothly to Linux and for Linux operations staff supplementing database-specific knowledge. The discussion of implementing AlwaysOn availability groups in cross-platform environments reflects the author's deep understanding of hybrid architecture complexity. Note, however, that some content involving the latest version features may require supplementary reading of official documentation.\n\nOverall, this is a timely technical manual with outstanding practical value, reflecting the latest practices in database technology convergence in the cloud computing era. For teams implementing or planning cross-platform database architectures, the systematic methodology and troubleshooting guidance offer significant reference value.

Who it's for

A good fit for

Database administrators transitioning from Windows to Linux
Enterprise IT operations staff managing mixed-OS environments
Technical architects seeking in-depth understanding of SQL Server mechanisms specific to Linux
DevOps engineers preparing to deploy SQL Server in containerized environments

Not a good fit for

Beginners who only need basic SQL syntax or database theory
Technicians concerned only with traditional SQL Server usage on Windows

Reading tips

Read the environment planning section in Chapter 2 first to build a basic understanding of Linux–SQL Server interaction
During hands-on practice, verify with the PowerShell scripts provided in the book, noting minor differences across Linux distributions
For production issues, consult the troubleshooting chapter (Chapter 6), but rehearse in a test environment first

About the publisher

Posts & Telecom Press China · Founded in 1953

Posts & Telecom Press is known for its strengths in science and technology, computing, and information and communications titles, and has extended its publishing into photography, art, software learning, and inspirational growth, giving it a fairly diverse range. Its catalog includes computing and communications works such as Refactoring and Patterns (Revised Edition) and Huawei Switch Learning Guide (Second Edition), alongside bilingual collector's editions such as The Little Prince (Chinese-English-French illustrated collector's edition), The Great Gatsby, and Three Days to See. Beijing Ten Years: 1980-1990 and Ghost Blade: WLOP Personal Illustration Collection reflect its presence in photography and art. Its authors include Antoine de Saint-Exupéry, Helen Keller, Joshua Kerievsky, Wang Da, Zhang Zhaozeng, and WLOP.

版权信息
内容提要
前言
资源与支持
第1篇基础篇
第1章 SQL Server On Linux简介
1.1 为何选择Linux平台的SQL Server
1.2 SQL Server关键组件简介
1.3 SQL Server On Linux新特性简介
1.4 SQL Server On Linux新玩法
1.5 SQL Platform Abstraction Layer
1.6 本书结构
1.7 总结
第2章 Linux基础及安装部署
2.1 背景介绍
2.2 前期规划
2.3 基础框架
2.4 部署
2.5 预配置
2.6 总结
第3章安装配置SQL Server On Linux
3.1 安装前的准备工作
3.2 安装攻略
3.3 环境配置
3.4 注意事项
3.5 安装示例数据库
3.6 总结
第2篇管理篇
第4章 Linux基础运维
4.1 常用指令
4.2 基础运维
4.3 总结
第5章 Linux基础监控
5.1 分布式监控系统Zabbix
5.2 Grafana展现
5.3 SQL Server监控
5.4 总结
第6章服务及空间管理
6.1 服务器的服务及空间管理
6.2 SQL Server服务及空间管理
6.3 SQL On Linux备份还原
6.4 总结
第7章 SQL Server On Linux数据库安全
7.1 安全概念
7.2 始终加密
7.3 动态数据屏蔽
7.4 行级安全性
7.5 时态表
7.6 总结
第8章 Linux自动化运维演示
8.1 expect
8.2 Ansible入门
8.3 总结
第9章数据库监控
9.1 监控理论
9.2 监控工具
9.3 监控分析
9.4 监控展示
9.5 总结
第3篇性能篇
第10章 SQL Server性能优化方法论
10.1 性能简介
10.2 性能优化的误区
10.3 常见影响因素
10.4 常规性能优化流程
10.5 扩充阅读
10.6 优化Checklist
10.7 总结
第11章 SQL Server On Linux故障侦测
11.1 SQL Server查询生命周期
11.2 常用故障侦测手段
11.3 总结
第12章 SQL Server性能优化新工具
12.1 简介
12.2 查询存储
12.3 自动优化
12.4 自适应查询处理
12.5 实时查询统计信息
12.6 总结
第13章 SQL Server索引优化
13.1 简介
13.2 索引基础
13.3 统计信息基础
13.4 索引种类
13.5 索引分析与优化
13.6 索引建议
13.7 总结
第14章 SQL Server等待信息
14.1 我们在等待什么
14.2 简介
14.3 等待信息元数据
14.4 并行执行
14.5 多任务等待
14.6 I/O等待
14.7 备份和还原等待
14.8 锁定等待
14.9 数据库日志等待
14.10 外部资源等待
14.11 其他常见等待类型
14.12 案例
14.13 总结
第15章事务与阻塞
15.1 环境准备和术语介绍
15.2 事务与ACID
15.3 阻塞
15.4 死锁
15.5 锁升级
15.6 事务设计建议
15.7 总结
第16章 In-Memory OLTP简介
16.1 案例演示
16.2 技术简介
16.3 快速上手
16.4 注意事项
16.5 最佳实践
16.6 总结
第4篇架构篇
第17章 SQL Server On Linux高可用介绍
17.1 简介
17.2 安装过程
17.3 警报
17.4 读写分离
17.5 常见故障侦测手段
17.6 总结
第5篇案例篇
第18章 Linux运维案例
18.1 被黑
18.2 内存溢出
18.3 打开过多文件
18.4 从删库到“跑路”
18.5 总结
第19章数据库运维案例
19.1 简介
19.2 案例分享
19.3 其他案例
19.4 总结
附录
附录A SQL Server DBA及Linux管理员面试题分析
A.1 SQL Server DBA面试题分析
A.2 Linux管理员面试题分析
附录B DBA与Linux管理Checklist
B.1 运维/优化思想
B.2 DBA运维Checklist
B.3 Linux运维Checklist
附录C SQL Server表关联细节
C.1 嵌套循环连接
C.2 合并关联
C.3 散列关联
C.4 3种关联方式的对比
附录D Linux内核参数说明

FAQ

How much Linux background does this book require?

Basic Linux command-line operations and system administration concepts are required. Key chapters supplement necessary Linux knowledge but do not teach it from scratch. Readers unfamiliar with systemd, SELinux, and other core components are advised to study them beforehand.

Does the content apply to all Linux distributions?

Demonstrations are mainly based on the two mainstream distributions Red Hat/CentOS and Ubuntu. Most configuration solutions are general, but details such as package management and path conventions must be adjusted to the actual distribution.

Does the book cover deployment practices on cloud platforms?

The focus is on local deployment on physical machines or virtual machines, but the containerization chapter applies directly to cloud environments. The book does not specifically address AWS RDS or Azure SQL managed services and is better suited to scenarios requiring self-managed infrastructure.

Comments

Find this book

This site is an index: you start “Search all sources” in your browser, and the entries it lists all point to third-party sites; please judge their availability yourself.

About the author

黄钊吉 Author

Huang Zhaoji is an author of computer technology books about whom limited public information is available. One work by this author is held in the collection: SQL Server On Linux Operations in Practice. Judging from the subject matter, Huang Zhaoji focuses on the practical deployment and day-to-day operations of database technology on the Linux platform, writing for technical personnel who need hands-on guidance rather than general conceptual introductions. Writing of this kind usually emphasizes reusable practical steps such as environment setup, configuration tuning, and troubleshooting, with a style that favors clear procedures and problem-oriented explanations, making it suitable for database administrators and operations engineers. Because the author's biography, education, and professional experience have not been publicly disclosed, the writing style and impact can only be assessed from the work itself: the book is oriented toward hands-on practice, reflects the author's effort to organize and share experience in cross-platform SQL Server operations, and offers Chinese readers a usable introduction and reference for this specialized field.

熊章立 Author

Xiong Zhangli is an author about whom limited public information is available; he is currently known only for SQL Server Operations and Maintenance in Practice on Linux, a work classified under general computer science. The title indicates that the author focuses on the intersection of database technology and system operations—specifically, the day-to-day maintenance, configuration management, and troubleshooting involved after Microsoft's SQL Server database is migrated to the Linux platform. This topic responds to the growing prevalence of heterogeneous environments in enterprise IT architecture, and offers some reference value for technicians who need to deploy and operate SQL Server on Linux systems. In terms of writing style, the book is a hands-on technical work that emphasizes practical methods and steps in concrete scenarios rather than abstract theoretical discussion. Because the author's own background, identity, and further writings remain unclear, a fuller picture of his work and its academic influence still awaits additional information.