Drew Skwiers-Koballa

The evolution of SQL projects continues with expanded IDE support and deeper integration in the Fabric platform. Using the latest in VS Code and SSMS, we’ll walk through keeping our database in source control, integrating changes made in another database, and evaluating deployment plans.

Databases and technology are evolving quickly, and the tools you use every day are evolving with it. In this session, we’ll take a tour of what’s new and what’s next across Microsoft’s SQL tooling ecosystem, with plenty of demos from SQL Server Management Studio (SSMS) and Visual Studio Code.

The evolution of SQL projects continues with expanded IDE support and deeper integration in the Fabric platform. Using the latest in VS Code and SSMS, we’ll walk through keeping our database in source control, integrating changes made in another database, and evaluating deployment plans.

How quickly can you take your database and examine its code? Database-as-code is not a new concept, but all too often we focus only on being able to apply changes to the database instead of having a development process that ensures that we’re making good database changes.

With Microsoft.Build.Sql SDK-style SQL projects, your database objects are stored as code for seamless development in Microsoft Fabric and client tools like VS Code and Visual Studio, but the advantages don’t stop there. The modernized SQL projects format backs Fabric’s git integration and deployment pipelines for…

This workshop is a deep dive on database DevOps centered on the SQL database projects format, where you will learn practical techniques for managing database changes whether your workload is operational, analytical, or somewhere in between.

With Microsoft.Build.Sql SDK-style SQL projects, your database objects are stored as code for seamless development in Microsoft Fabric and client tools like VS Code and Visual Studio, but the advantages don’t stop there.

Cross-platform and approachably extensible, Azure Data Studio is a new application for database development and management. Azure Data Studio extensions can create efficiencies by automating a workflow or integrating with an external system.