Skip to content
Status: Preview

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

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.

  1. 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.

  2. 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.

  3. 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.

  4. 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?".

Watch on-demand (opens in a new tab)

More in this area

← All announcements