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

📰
In Pursuit of the Ideal Developer Experience
Learn how to create an ideal developer experience by leveraging terminal-first tools and distributed issue trackers to boost productivity
Dev.to · Jonatan Lampa
📰
Why AWS CodePipeline + ECS falls short for production-grade microservices (and how EKS fixes it)
Learn why AWS CodePipeline + ECS may not be suitable for production-grade microservices and how EKS can address these limitations
Dev.to · Arnab Adhikary
📰
The Right Way to Pair AI With Terraform Plans
Learn to effectively pair AI with Terraform plans to streamline infrastructure management and reduce verbosity
Dev.to · James Joyner
📰
A 2-minute pre-commit hook that stops you from committing API keys
Learn to create a 2-minute pre-commit hook to prevent accidental API key commits and protect your project's security
Dev.to · Cửu thiên vũ đế review

Chapters (3)

Introduction
2:13 Demos
12:00 What's next
Up next
Containers on Amazon ECS with Mama J
AWS Developers
Watch →