SQL Server 2019 Administration Inside Out (Inside Out) by West, Randolph

Description: Conquer SQL Server 2019 administration-from the inside out Dive into SQL Server 2019 administration-and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of time-saving solutions, tips, and workarounds-all you need to plan, implement, manage, and secure SQL Server 2019 in any production environment: on-premises, cloud, or hybrid. SQL Server experts offer a complete tour of DBA capabilities available in SQL Server 2019 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 2019'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 The definitive one-stop SQL Server 2019 database administration resource for all working DBAsIncludes coverage of features introduced in SQL Server 2019 Serves as a complete reference for the modern SQL DBA Readers can upgrade SQL Server Administration skillset to SQL Server 2019, plus Azure SQL Databases, Azure SQL Database Managed Instances, and SQL on Linux Covers Migration strategies, automation with PowerShell, and proven implementation strategies for High Availability solutions Part I Introduction Chapter 1 Getting started with SQL Server tools Chapter 2 Introducing database server components Chapter 3 Designing and implementing an on-premises database infrastructure Part II Deployment Chapter 4 Installing and Configuring SQL Server Instances and Features Chapter 5 Installing and configuring SQL Server on Linux Chapter 6 Provisioning and Configuring SQL Server Databases Chapter 7 Understanding Table Features Part III SQL Server Management Chapter 8 Maintaining and monitoring SQL Server Chapter 9 Automating SQL Server administration Chapter 10 Developing, deploying, and managing data recovery Chapter 11 Implementing high availability and disaster recovery Part IV Security Chapter 12 Administering security and permissions Chapter 13 Protecting data through encryption, privacy and auditing Part V Performance Chapter 14 Performance tuning SQL Server Chapter 15 Understanding and designing indexes Part VI Cloud Chapter 16 Designing and implementing hybrid and Azure database infrastructure Chapter 17 Provisioning Azure SQL Database Chapter 18 Provisioning Azure SQL Database managed instance Chapter 19 Migrating to SQL Server solutions in Azure Part VII Big Data and Machine Learning Leveraging Big Data and Machine Learning

Price: 110 AUD

Location: Hillsdale, NSW

End Time: 2024-12-20T08:29:33.000Z

Shipping Cost: 31.33 AUD