Refactor your database with SQL projects in VS Code
SQL database projects are a fundamental tool for keeping your database in source control, tracking changes and collaborating on quickly evolving database needs. Not to be forgotten, their superpower is being able to dynamically generate deployment scripts that match the declared state and the exact environment you’re deploying to. SQL project development becomes more challenging […]
The post Refactor your database with SQL projects in VS Code appeared first on Azure SQL Dev Corner.
Published on:
Learn moreRelated posts
Your best friend: BlockOnPossibleDataLoss=True
BlockOnPossibleDataLoss can frustrate developers, but it's one of the most important safeguards in database deployment. Here's how to keep you...
Build Locally, Ship to Cloud for $0: Azure SQL for Modern App Developers
As app developers, our primary focus is building great user experiences, designing APIs, and shipping features quickly. What we don’t wa...
Build locally, ship to Azure: meet Azure SQL Developer
Big news: Azure SQL Developer is here, in private preview. It’s the Azure SQL Database engine, on your laptop, in a container. Build aga...
T-SQL Hygiene: Introducing the Covering Index
Often in applications, we write database queries. And often, the same query is executed again and again. To make queries against large tables ...
T-SQL Hygiene: What’s the Big Deal with SET NOCOUNT ON?
Learn why SET NOCOUNT ON improves stored procedure efficiency, reduces unnecessary messages, and matters to .NET developers. The post T-SQL Hy...
MSSQL Extension for VS Code: Shortcuts Configuration, Enhanced Results Grid Experience, and More
The MSSQL extension for VS Code v1.44 continues to improve the SQL development experience with features that help you work faster and customiz...
Fundamentals of Azure DevOps with SQL projects
Building automated pipelines with your SQL database projects enables you to build a rich CI/CD ecosystem to ensure that your application is be...
Audit Frontier AI Agents with SQL MCP Server
With On-Behalf-Of authentication, SQL MCP Server lets agents access Microsoft SQL without losing the user identity behind the request. Azure S...
What’s new across Microsoft SQL in 2026 so far (SQL Server, Azure SQL, and SQL database in Fabric)
We’re halfway through 2026, and Microsoft SQL has not slowed down. Since SQLCon/FabCon in March (where we released a ton of things, and those ...
Compose your API surface with Data API builder custom paths
Data API builder (DAB) 2.0 adds compound paths for REST endpoints, giving developers more control over how their API surface is organized. Ins...