SQL Server 2016 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. Emphasizing SQL Server 2016’s newest features, four leading Microsoft database experts share insider techniques, solutions, advice, and troubleshooting tips for maximizing efficiency and effectiveness in all facets of deployment and day-to-day administration, and performance optimization.
The authors tour a wide array of tools and features available in the SQL Server 2016 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.