SQL Server 2017 Administration Inside Out | First Edition| By Pearson Paperback – 1 February 2022

Description

“SQL Server 2017 Inside Out is the authoritative in-depth reference for every working database administrator responsible for planning, implementing, or managing SQL Server in any production environment — on-premises, cloud, or hybrid.Emphasising SQL Server 2017’s newest features, including running SQL Server on Linux, four leading Microsoft database experts share insider techniques, solutions, advice, and troubleshooting tips for maximising efficiency and effectiveness in all facets of deployment and day-to-day administration, and performance optimisation.The authors tour a wide array of tools and features available in the SQL Server 2017 database engine, SQL Server Data Tools, SQL Server Management Studio, and PowerShell. Throughout, they offer clear overviews, detailed explanations, step-by-step demonstrations, and practical scripts — all drawing on their extensive in-the-trenches experience.” Features” Fully explore all new DBA-related features of SQL Server 2017, learning from practical examples and sample code Start using and managing SQL Azure and SQL Server running in IaaS Understand and master SQL Server security, high availability, and disaster recovery capabilities Effectively implement SQL Server 2017 in on-premises and cloud-based architectures Discover time-saving solutions, troubleshooting tips, and workarounds that supercharge your effectiveness in production environments Written by a world-class team of SQL Server MVP experts, insiders, and consultants”