Introducing SQL projects in SSMS | Data Exposed

Microsoft Developer · Beginner ·☁️ DevOps & Cloud ·2mo ago

Key Takeaways

Introducing SQL projects in SSMS for database source control and management

Original Description

You have a database in production. How do you get it into source control — and keep it there? With SSMS 22.5, you can now import your database into a SQL project — a code-based, human-readable definition of your schema — edit and validate without impacting the original database, and publish changes with confidence. In this Data Exposed episode, we introduce SQL projects in SSMS with the new Database DevOps workload in preview. We'll also show how the same project file works across VS Code, GitHub Actions, and Azure DevOps — so your database development process can grow with your team across any tool. ✅ Chapters: 0:00 Introduction 2:13 Demos 12:00 What's next ✅ Resources: https://aka.ms/sqlprojects https://aka.ms/ssms-sqlprojects 📌 Let's connect: 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
Watch on YouTube ↗ (saves to browser)
Sign in to unlock AI tutor explanation · ⚡30

Related Reads

📰
AWS CodePipeline Tutorial: Deploy to EC2 with CodeCommit, CodeBuild & CodeDeploy
Learn to deploy to EC2 using AWS CodePipeline with CodeCommit, CodeBuild, and CodeDeploy in this step-by-step tutorial
Dev.to · Guna SantoshDeep Srivastava
📰
Harbor HTTPS Setup Using a Self-Signed Certificate
Learn to set up Harbor with HTTPS using a self-signed certificate for secure access
Medium · DevOps
📰
Debug a Legacy Frontend-Backend Deployment With One Trace ID
Debug a legacy frontend-backend deployment by tracing one revision through all layers to identify issues
Dev.to · Odd_Background_328
📰
Four inspectable workflows for context, research, orchestration, and evaluation
Learn from inspectable workflows to improve technical skills and understanding of context, research, orchestration, and evaluation
Dev.to · Zain Dana Harper

Chapters (3)

Introduction
2:13 Demos
12:00 What's next
Up next
AWS, Azure, GCP: The One Thing Every Business Gets Wrong
AI Daily
Watch →