Microsoft Developer: Tackle real database changes with SQL projects in VS Code | Data Exposed

In this Data Exposed episode, we go beyond SQL projects setup and into the day-to-day challenges of making deployable database changes in VS Code. See how IntelliSense catches errors quickly, how refactoring safely propagates renaming and moving objects, and how publish profiles let you target different environments with confidence. Whether you're renaming a table or rolling out schema changes across dev, test, and production, SQL projects in VS Code give you the guardrails to make changes your way without breaking things.



✅ Chapters:

0:28 Database changes and how SQL projects can help

1:00 Demo starts to alter a view

1:31 Intro to intellisense within the SQL project (disconnected)

2:32 How to rename a table - new and improved

3:45 Refactor log file

4:50 Generating the publish script for the changes

5:15 Publish profiles for custom settings remembered

6:40 Tips and tricks



✅ Resources:

https://devblogs.microsoft.com/azure-sql/refactor-your-database-with-sql-projects-in-vs-code/

https://aka.ms/sqlprojects





📌 Let's connect:

LinkedIn - Drew Skwiers-Koballa https://www.linkedin.com/in/drew-skwiers-koballa/

Twitter - Anna Hoffman, https://twitter.com/AnalyticAnna

Twitter - AzureSQL, https://aka.ms/azuresqltw



🔴 Watch even more Data Exposed episodes: https://aka.ms/dataexposedyt



🔔 Subscribe to our channels for even more SQL tips:

Microsoft Azure SQL: https://aka.ms/msazuresqlyt

Microsoft SQL Server: https://aka.ms/mssqlserveryt

Microsoft Developer: https://aka.ms/microsoftdeveloperyt



#AzureSQL #SQL #LearnSQL