Skip to content
Status: Generally available Connected and disconnected environments

SQL Server on Azure Local

SQL Server is generally available on Azure Local. It allows database workloads to run on customer-controlled infrastructure in both connected and disconnected environments.

Sources

BRK450 Breakout Tue 17 Nov 14:00 PST

No cloud required: Build AI apps with SQL Server on Azure Local

Bob Ward

From the recording / Microsoft AI summary

The session positioned Azure Local between self-managed Windows Server and Hyper-V or VMware, with a path for VMware customers. The demo was a care transfer app running SQL Server and Foundry Local models entirely on-premises, with GitHub Copilot in SSMS using a local model. Much works disconnected, managed through Arc, though some features are limited offline. Connected billing is per core per hour.

Demo timestamps

Microsoft's player does not support links to a specific time, so open the recording and skip to the time shown.

  1. Skip to 0:09:40

    Scenario: regional care transfer centre app on Azure Local

    An app that must run inside a compliant boundary with no cloud: Azure Virtual Desktop, SQL Server 2025 in Azure Local VMs, and Foundry Local on a GPU AKS cluster. Incoming ambulance patient data appears as a queue.

  2. Skip to 0:15:03

    SQL Server 2025 AI features in the app

    Shows semantic search with embeddings, JSON storage, regular expressions and a stored procedure that generates a receiving briefing using vector search over patient history.

  3. Skip to 0:24:25

    AI skills stored in a table, audited with Ledger

    Stores AI skills as JSON in a table, builds prompts and calls the local model over REST from SQL. Each request and response is recorded in a Ledger table that administrators cannot change.

  4. Skip to 0:31:10

    Local GitHub Copilot in SSMS and VS Code

    GitHub Copilot in SSMS analyses deadlocks from the System Health extended events session using a Foundry Local model. Copilot in VS Code explains the AI schema, with no cloud model.

Watch on-demand (opens in a new tab)

More in this area

← All announcements