Azure SQL Hyperscale Revealed

High-performance Scalable Solutions for Critical Data Workloads

Zoran Barać, Daniel Scott-Raynsford (Autoren)

Buch | Softcover

472 Seiten

2023 | 1st ed.
Apress (Verlag)
978-1-4842-9224-2 (ISBN)

Artikel merken

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

Zoran Barać is a cloud architect and data specialist with more than 15 years of hands-on experience in data optimization, administration, and architecture. He is a Certified Microsoft Trainer (MCT) and Microsoft Certified Solutions Expert (MCSE) with a master‘s degree in Information Technology. Sharing knowledge and contributing to the SQL Server community is his passion. He is also an organizer of the Auckland SQL User Meetup Group, an active blogger, and speaker at different SQL events such as Data Summits, SQL Saturdays, SQL Fridays, Meetups, etc. Daniel Scott-Raynsford is a Partner Technology Strategist at Microsoft with 15 years of experience as a software developer and solution architect. He specializes in DevOps and continuous delivery practices. He was a Microsoft MVP in Cloud and Datacenter Management for three years before joining Microsoft and is an active PowerShell open source contributor and Microsoft DSC Community Committee member. He is also a contributor to the Azure Architecture Center on multi-tenant architecture practices.

Introduction.- Part I. Architecture.- 1. The Journey to Hyperscale Architecture in Azure SQL.- 2. Azure SQL Hyperscale Architecture: Concepts and Foundations.- 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.- 13. Monitoring and Scaling.- 14. Backup, Restore and Disaster Recovery.- 15. Security and Updating.- 16. Managing Costs.- Part IV. Migration.- 17. Determining whether Hyperscale is Appropriate.- 18. Migrating to Hyperscale.- 19. Reverse Migrating Away from Hyperscale.- Conclusion

Erscheinungsdatum	24.03.2023
Zusatzinfo	266 Illustrations, color; 22 Illustrations, black and white; XVI, 472 p. 288 illus., 266 illus. in color.
Verlagsort	Berkley
Sprache	englisch
Maße	178 x 254 mm
Themenwelt	Mathematik / Informatik ► Informatik ► Datenbanken
Themenwelt	Mathematik / Informatik ► Informatik ► Software Entwicklung
Schlagworte	Azure SQL • Azure SQL Hyperscale • data architecture • Disaster Recovery • Four-Tier Architecture • hadr • High Availability • hyperscale • Microsoft Azure • Socrates Architecture
ISBN-10	1-4842-9224-3 / 1484292243
ISBN-13	978-1-4842-9224-2 / 9781484292242
Zustand	Neuware