BRK363 Breakout Tue 17 Nov 16:30 PST
Less hunting, more building: Database agents in a unified estate
Patrick LeBlanc, Charles Webb
Summary
From the recording / Microsoft AI summary
Database Hub shows Azure SQL, SQL Server, PostgreSQL and Cosmos DB in one view. Speakers said any Arc-enabled SQL Server works, telemetry is kept for 28 days, and Database Hub is free and works with a free Fabric or Power BI licence. Database agents support only Azure SQL and Hyperscale today, with other databases and VMs coming. Speakers said agents go GA at FabCon US, with no date given. The Book of News says Database Hub is GA and agents are in preview.
Session description
Microsoft's catalogue description
Growing data estates create fragmented tools, limited visibility, and operational complexity that slows innovation. See how database hub in Fabric and database agents work with the tools your teams already use—SSMS and the MSSQL extension for VS Code—to surface the issues that matter, explain the likely cause, recommend a fix, and act with your approval. Come away with practical ways to reduce risk, cut operational overhead, and boost productivity, no matter where your data lives.
Demo timestamps
Microsoft's player does not support links to a specific time, so open the recording and skip to the time shown.
- Skip to 0:04:01
Turning on Database Hub in Fabric
Database Hub is enabled in the Fabric admin settings and pinned to the left rail; databases appear automatically.
- Skip to 0:07:35
Arc requirement and telemetry store
Arc is needed for on-premises, hybrid or multicloud databases. Telemetry lands in a Kusto store with 28 days of queryable history.
- Skip to 0:09:57
Estate view filtering and sharing
Filters by engine and role, saves and shares views, and filters to security issues such as exposed public endpoints; custom real-time dashboards can be built on top.
- Skip to 0:34:31
Database agent in VS Code and SSMS
In VS Code the database agent flags CPU spikes on a PostgreSQL database and recommends an index; in SSMS, GitHub Copilot answers "how's my database doing?".