Azure SQL Database Hyperscale - Now for any size workload
Start small and scale up to your most demanding workloads on Azure SQL Database Hyperscale. Run serverless compute that scales with demand and auto-pauses, so you stop paying for idle compute. Pool databases across tenants or business units and run cross-database joins and transactions natively.
Build AI apps on the same SQL engine. Store relational data, JSON and vectors together, run hybrid vector search across more than 1 billion rows with DiskANN indexes, and move read-heavy workloads to named replicas with no data copy. Connect Foundry agents through a SQL MCP Server, control their access down to the individual cell, and turn on automatic index compaction to keep queries running at speed.
Bob Ward, Principal Architect, SQL, shares how to size and deploy the right Hyperscale configuration from a single prompt with a GitHub Copilot skill in VS Code.
👥 Who it's for:
DBAs, database developers and app developers building on Azure SQL, plus solution architects planning multi-tenant, high-scale or AI-powered workloads.
⏱️ Chapters:
00:00 Run small to massive workloads on Hyperscale
00:56 How Hyperscale's distributed layers scale independently
02:01 No separate SQL Server license required
02:37 Size and deploy with a GitHub Copilot skill
03:27 Serverless compute scales up and down
03:58 Auto-pause stops billing for idle compute
04:34 Share capacity across databases with elastic pools
06:28 Cross-database joins and remote transactions
07:15 Store relational data, JSON and vectors together
07:38 Hybrid vector search with reciprocal rank fusion
08:38 Search 1 billion+ rows in milliseconds
09:12 Offload reads to named replicas, no data copy
10:04 Build Foundry agents with a SQL MCP Server
11:07 Control agent access down to the cell
11:36 Automatic index compaction for faster queries
13:16 Try the Copilot skill and go deeper
Azure SQL Database Hyperscale is a fully managed, cloud-native SQL database built on the familiar SQL Database engine. Compute, page servers, a log service and long-term Azure Storage each run as separate layers that scale independently, with storage up to 128 TB and zone redundancy for automatic failover. The name describes room to grow, not a minimum size. Hyperscale provisions in minutes, updates continuously and needs no separate SQL Server license.
The demo takes a patient scheduling app from a single serverless database to a three-clinic elastic pool sharing 24 vCores. Cross-database views find open appointments across every clinic, and remote transactions keep bookings consistent end to end.
On the AI side, a biomedical evidence explorer runs hybrid vector and keyword search, merges the results with reciprocal rank fusion, and then scales to 192 vCores and about 8 TB. Up to 30 named replicas share the primary's page servers and vector index, spin up in minutes, and take search and reporting load off the primary. A research agent in the Foundry Agent Service uses a SQL MCP Server to search evidence, compare sources and write up a briefing.
Automatic index compaction, which you enable with ALTER DATABASE in SSMS, uses background tasks to compact sparse index pages. The result is fewer logical reads and faster dashboards.
🔗 Related links:
— Try the Azure SQL Hyperscale configuration skill at https://aka.ms/SQLHyperscaleMechanics
— Get started at https://aka.ms/SQLHyperscale
— Read Bob Ward's book on Hyperscale at https://aka.ms/sqlhyperscaleunveiled
► Unfamiliar with Microsoft Mechanics?
Microsoft's Official Video Series for IT
— Subscribe https://www.youtube.com/c/MicrosoftMechanicsSeries
— Microsoft Tech Community: https://techcommunity.microsoft.com/t5/microsoft-mechanics-blog/bg-p/MicrosoftMechanicsBlog
— Podcast: https://microsoftmechanics.libsyn.com/podcast
►Join us on social:
— https://twitter.com/MSFTMechanics
— https://www.linkedin.com/company/microsoft-mechanics/
— https://www.instagram.com/msftmechanics/
— https://www.tiktok.com/@msftmechanics
Published on:
Learn moreWe can help you with Azure SQL Database Hyperscale - Now for any size workload
If you want help implementing, troubleshooting, or improving this product, contact us and we’ll point you in the right direction.
Made for tech enthusiasts and IT professionals. Expanded coverage of your favorite technologies across Microsoft; including Office, Azure, Windows and Data Platforms. We'll even bring you broader topics such as device innovation with Surface, machine learning, and predictive analytics.
Related posts
New Microsoft Copilot Harness | More power, token efficiency & control for agents in Foundry
Build agents you can trust with your company's data, apps, and resources using Microsoft Foundry. Start with a fully managed prompt agent and ...
New Conditional Access policy plans in Microsoft Entra
Group related Conditional Access policies into policy plans and define users, apps and conditions once for every rule in the plan. Add a rule ...
Fight AI with AI | Multi-Agent Security Defense
Match AI-powered attacks at machine speed with Project Perception. Point red, blue, and green AI agent teams at a known threat actor, confirm ...
Build Automated Agents, Workflows, and Apps - New in Copilot Studio
Take a business process from prompt to production by building agents, workflows, and apps in one place with Copilot Studio. Describe the agent...
Create agents fast with Agent Builder in Copilot
Build a specialist AI agent without writing a line of code. Describe what you want in one prompt, and Copilot Agent Builder generates the name...
New Agent 365 controls for Microsoft admins
Govern every AI agent running across your organization with Agent 365. Track agents from Microsoft, Amazon, Google, and Salesforce in one regi...
Windows 365: Five Years In, See What's New
An AI agent works inside your Windows 365 Cloud PC from a Teams chat on your phone — finding downloaded files, editing documents, and drafting...
Build your first Power App from data in seconds
Build a fully working model-driven app from your existing Dataverse, SharePoint, or SQL data in under a minute — screens, navigation, and form...
Microsoft Entra Suite hands-on tour of identity and network access protections
Unify identity and network access controls. Enforce least privilege access across every app and resource. Wire lifecycle workflows directly to...
New agentic platform in Dynamics 365 for Sales and Service
Qualify a lead, close a case, or walk into a renewal meeting fully briefed, all from the sales and service agents built into Dynamics 365. Ask...