Book description
Take a deep dive into the Azure SQL Database Hyperscale Service Tier and discover a new form of cloud architecture from Microsoft that supports massive databases. The new horizontally scalable architecture, formerly code-named Socrates, allows you to decouple compute nodes from storage layers. This radically different approach dramatically increases the scalability of the service. This book shows you how to leverage Hyperscale to provide next-level scalability, high throughput, and fast performance from large databases in your environment.The book begins by showing how Hyperscale helps you eliminate many of the problems of traditional high-availability and disaster recovery architecture. You’ll learn how Hyperscale overcomes storage capacity limitations and issues with scale-up times and costs. With Hyperscale, your costs do not increase linearly with database size and you can manage more data than ever at a lower cost.
The book teaches you how todeploy, configure, and monitor an Azure SQL Hyperscale database in a production environment. The book also covers migrating your current workloads from traditional architecture to Azure SQL Hyperscale.
What You Will Learn
- Understand the advantages of Hyperscale over traditional architecture
- Deploy a Hyperscale database on the Azure cloud (interactively and with code)
- Configure the advanced features of the Hyperscale database tier
- Monitor and scale database performance to suit your needs
- Back up and restore your Azure SQL Hyperscale databases
- Implement disaster recovery and failover capability
- Compare performance of Hyperscale vs traditional architecture
- Migrate existing databases to the Hyperscale service tier
Who This Book Is For
SQL architects, data engineers, and DBAs who want the most efficient and cost-effective cloud technologies to run their critical data workloads, and those seeking rapid scalability and high performance and throughput while utilizing large databases
Table of contents
- Cover
- Front Matter
- Part I. Architecture
-
Part II. Planning and Deployment
- 3. Planning an Azure SQL DB Hyperscale Environment
- 4. Deploying a Highly Available Hyperscale Database into a Virtual Network
- 5. Administering a Hyperscale Database in a Virtual Network in the Azure Portal
- 6. Configuring Transparent Data Encryption to Bring Your Own Key
- 7. Enabling Geo-replication for Disaster Recovery
- 8. Configuring Security Features and Enabling Diagnostic and Audit Logs
- 9. Deploying Azure SQL DB Hyperscale Using PowerShell
- 10. Deploying Azure SQL DB Hyperscale Using Bash and Azure CLI
- 11. Deploying Azure SQL DB Hyperscale Using Azure Bicep
- 12. Testing Hyperscale Database Performance Against Other Azure SQL Deployment Options
- Part III. Operation and Management
- Part IV. Migration
- Back Matter
Product information
- Title: Azure SQL Hyperscale Revealed: High-performance Scalable Solutions for Critical Data Workloads
- Author(s):
- Release date: March 2023
- Publisher(s): Apress
- ISBN: 9781484292259
You might also like
book
Azure SQL Revealed: A Guide to the Cloud for SQL Server Professionals
Access detailed content and examples on Azure SQL, a set of cloud services that allows for …
book
Pro Serverless Data Handling with Microsoft Azure: Architecting ETL and Data-Driven Applications in the Cloud
Design and build architectures on the Microsoft Azure platform specifically for data-driven and ETL applications. Modern …
book
SQL Server Data Automation Through Frameworks: Building Metadata-Driven Frameworks with T-SQL, SSIS, and Azure Data Factory
Learn to automate SQL Server operations using frameworks built from metadata-driven stored procedures and SQL Server …
book
Professional Azure SQL Managed Database Administration - Third Edition
Master data management by effectively utilizing the features of Azure SQL database. Key Features Learn to …
