SQL Server 2017 Administration Inside Out

**Conquer SQL Server 2017 administration--from the inside out**Dive into SQL Server 2017 administration--and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds--all you need to plan, implement, manage, and secure SQL Server 2017 in any production environment: on-premises, cloud, or hybrid. Four SQL Server experts offer a complete tour of DBA capabilities available in SQL Server 2017 Database Engine, SQL Server Data Tools, SQL Server Management Studio, and via PowerShell. Discover how experts tackle today's essential tasks--and challenge yourself to new levels of mastery. - Install, customize, and use SQL Server 2017's key administration and development tools - Manage memory, storage, clustering, virtualization, and other components - Architect and implement database infrastructure, including IaaS, Azure SQL, and hybrid cloud configurations - Provision SQL Server and Azure SQL databases - Secure SQL Server via encryption, row-level security, and data masking - Safeguard Azure SQL databases using platform threat protection, firewalling, and auditing - Establish SQL Server IaaS network security groups and user-defined routes - Administer SQL Server user security and permissions - Efficiently design tables using keys, data types, columns, partitioning, and views - Utilize BLOBs and external, temporal, and memory-optimized tables - Master powerful optimization techniques involving concurrency, indexing, parallelism, and execution plans - Plan, deploy, and perform disaster recovery in traditional, cloud, and hybrid environments**For Experienced SQL Server Administrators and Other Database Professionals**- Your role: Intermediate-to-advanced level SQL Server database administrator, architect, developer, or performance tuning expert - Prerequisites: Basic understanding of database administration procedures Conquer SQL Server 2017 administration--from the inside out Dive into SQL Server 2017 administration--and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds--all you need to plan, implement, manage, and secure SQL Server 2017 in any production environment: on-premises, cloud, or hybrid. Four SQL Server experts offer a complete tour of DBA capabilities available in SQL Server 2017 Database Engine, SQL Server Data Tools, SQL Server Management Studio, and via PowerShell. Discover how experts tackle today's essential tasks--and challenge yourself to new levels of mastery. - Install, customize, and use SQL Server 2017's key administration and development tools - Manage memory, storage, clustering, virtualization, and other components - Architect and implement database infrastructure, including IaaS, Azure SQL, and hybrid cloud configurations - Provision SQL Server and Azure SQL databases - Secure SQL Server via encryption, row-level security, and data masking - Safeguard Azure SQL databases using platform threat protection, firewalling, and auditing - Establish SQL Server IaaS network security groups and user-defined routes - Administer SQL Server user security and permissions - Efficiently design tables using keys, data types, columns, partitioning, and views - Utilize BLOBs and external, temporal, and memory-optimized tables - Master powerful optimization techniques involving concurrency, indexing, parallelism, and execution plans - Plan, deploy, and perform disaster recovery in traditional, cloud, and hybrid environments For Experienced SQL Server Administrators and Other Database Professionals - Your role: Intermediate-to-advanced level SQL Server database administrator, architect, developer, or performance tuning expert - Prerequisites: Basic understanding of database administration procedures "Published with the authorization of Microsoft Corporation"--Title page verso. 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