Nevarez Benjamin Books

Tagline: Bringing consistent response time to mission-critical applications

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Essential Microsoft® SQL Server® 2017 installation, configuration, and management techniques for Linux Foreword by Kalen Delaney, Microsoft SQL Server MVP This comprehensive guide shows, step-by-step, how to set up, configure, and administer SQL Server 2017 on Linux for high performance and high availability. Written by a SQL Server expert and respected author, Microsoft SQL Server 2017 on Linux teaches valuable Linux skills to Windows-based SQL Server professionals. You will get clear coverage of both Linux and SQL Server and complete explanations of the latest features, tools, and techniques. The book offers clear instruction on adaptive query processing, automatic tuning, disaster recovery, security, and much more. •Understand how SQL Server 2017 on Linux works•Install and configure SQL Server on Linux•Run SQL Server on Docker containers•Learn Linux Administration•Troubleshoot and tune query performance in SQL Server•Learn what is new in SQL Server 2017•Work with adaptive query processing and automatic tuning techniques•Implement high availability and disaster recovery for SQL Server on Linux•Learn the security features available in SQL Server

Focusing on high-throughput, mission-critical applications, this updated edition provides comprehensive guidance on designing and configuring SQL Server instances and databases to ensure consistent performance amid varying user loads and query volumes. With over 100 pages of new content, it reflects the latest features of SQL Server 2019, including updates to all original chapters. Additionally, two new chapters explore SQL Server on Linux and Intelligent Query Processing, enhancing the book's relevance for modern database management.

Understanding the SQL Server Query Optimizer is crucial for enhancing database performance. This book demystifies its complex processes, equipping DBAs and developers with the knowledge to optimize queries and ensure efficient execution plans. It covers core concepts and practical insights gained from over 15 years of experience, enabling readers to troubleshoot and refine their SQL queries effectively. With this foundational knowledge, users can significantly improve their applications' performance and unlock the full potential of the Query Optimizer.