Introducing SQL projects in SSMS | Data Exposed

Microsoft Developer · Beginner ·☁️ DevOps & Cloud ·3mo 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

📰
Is Multi-AZ Enough for Disaster Recovery? What DORA Actually Asks of Your Application
Learn why Multi-AZ may not be enough for disaster recovery and what DORA asks of your application to ensure resilience
Dev.to · Alex
📰
When fastembed silently rotted my worker: anchor your caches, don't trust /tmp
Learn how to prevent worker crashes by anchoring caches and avoiding trust in /tmp, a crucial lesson for DevOps and software engineers
Dev.to · yogeshchavan2008
📰
Turn redacted HarnessDelta findings into native CI review artifacts
Learn to convert redacted HarnessDelta findings into native CI review artifacts for GitHub Actions and GitLab Code Quality
Dev.to · Nekoautomata Miki
📰
100 Days of DevOps and Cloud (AWS), Day 11: A WAR File Deploys Itself, and an ENI Is a Network Card You Can Move
Learn to deploy a Java web app to Tomcat without a deploy tool and understand the concept of an Elastic Network Interface (ENI) on AWS
Dev.to · Nnamdi Felix Ibe

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 →