SQL Server Management Studio 22.7 Unveils New “What’s New” Page

SQL Server Management Studio (SSMS) remains the go‑to IDE for developers building on Microsoft’s SQL platform, and the latest update—version 22.7.0—brings a host of refinements that sharpen the overall experience.

One of the most noticeable additions is a built‑in “What’s New” page that surfaces the newest features and bug fixes each time you install an update. The page is designed to be unobtrusive: it appears only once per release, and after you dismiss it, it won’t re‑pop up until the next version arrives.

In addition, Microsoft has unveiled a preview of Agent Mode, an AI‑powered assistant that can execute complex workflows automatically. By default, Agent Mode operates in read‑only mode, ensuring that the AI cannot inadvertently alter or delete data while it learns to streamline routine tasks.

Microsoft has finally unlocked a new level of control for GitHub Copilot users, letting them tailor the tool’s execution context on a per‑database basis. By editing the CONSTITUTION.md file, developers can now specify the user credentials that the agentic executor will adopt, providing a finer degree of security and customization.