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.
19 May 2019 - 06:34