Skip to main content

Posts

Showing posts from December, 2025

Connect and Execute T-SQL from VS Code

The MSSQL Extension for Visual Studio Code is designed to empower developers by providing a seamless and modern database development experience. The goal is to make SQL development more productive and intuitive by integrating essential features such as schema management, query execution, and AI-powered assistance. Agents Inside VS Code One of the most underrated strengths of the MSSQL Extension is how it leverages agents directly within Visual Studio Code. This isn’t just about running queries—it’s about having intelligent helpers embedded in your workflow. Write Queries Faster: Agents can scaffold queries from natural language, explain stored procedures, and even suggest optimizations. Instead of memorizing syntax, you focus on intent, and the agent translates it into SQL. Spot Performance Bottlenecks: Agents don’t just execute queries—they help you understand them. With execution plan insights and AI-driven recommendations, you can identify bottlenecks like slow joins or missing ind...