SQL and PostgreSQL database agents in Database Hub and PostgreSQL VS Code extension
SQL and PostgreSQL database agents in Database Hub and the PostgreSQL VS Code extension are in preview.
Sources
Related sessions
BRK363 Breakout Tue 17 Nov 16:30 PST
Less hunting, more building: Database agents in a unified estate
Patrick LeBlanc, Charles Webb
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.
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?".
More in this area
- Status: Generally available Azure Arc: GCP connector, automatic agent upgrade and CIS Windows audit
- Status: Generally available Azure SQL Managed Instance link for multi-database Always On availability groups
- Status: Generally available Confidential VMs (AMD SEV-SNP) on Azure Local
- Status: Generally available Database Hub in Fabric