Azure SQL Dev Corner

Voices from the Azure SQL PM Team, focusing on development and developers

Latest posts

Nov 17, 2026
Post comments count 0
Post likes count 0

New Create and Apply wizards in SSMS (Preview)

Matt Hyon

Need to save a database schema, move schema and data to another environment, or deploy a DACPAC to an existing database but find the existing options confusing? SQL Server Management Studio (SSMS) has new preview wizards that streamlines those tasks: Create bacpac/dacpac and Apply bacpac/dacpac. The Create wizard guides you through the process of generating a bacpac or dacpac with straightforward steps based on your goal.  The Apply wizard uses the package format to show the options for a schema deployment or a schema-and-data import. You can also create a new database and go straight into Apply. Preview: The...

Nov 17, 2026
Post comments count 0
Post likes count 0

Build locally with Azure SQL Database container, now in public preview

Vandana Mahtani

Azure SQL Database container: build locally, test continuously, ship to Azure. Today at Microsoft Ignite, we’re announcing the public preview of Azure SQL Database container—bringing the Azure SQL Database engine into your local development workflow. Build and test applications without provisioning a cloud database for every developer or test run. Run natively on x64 or ARM64, including Apple Silicon, and keep working offline after downloading the image. No Azure subscription is required for local development. Learn more, find commands, coding-agent prompts, and application templates on the Azure SQL Dev...

Nov 17, 2026
Post comments count 0
Post likes count 0

MSSQL Extension for VS Code: Local Azure SQL Database Provisioning, Query Performance Dashboard, and more

Yo-Lei Chen

A local database is a useful starting point, but deploying it and understanding how queries behave should fit into the same development workflow. The MSSQL extension for VS Code v1.48 brings three new public previews: Azure SQL Database local container provisioning, a local-to-cloud deployment wizard, and the Query Performance Dashboard. This November release also expands the preview query results experience and includes improvements to connection organization and Data API builder. 🎬 Watch YouTube demo: What's new in MSSQL extension for VS Code v1.48 Here's a summary of the key features in this...

Nov 17, 2026
Post comments count 0
Post likes count 1

Fuzzy string matching is now generally available across Microsoft SQL

Abhiman Tiwari

Four native T-SQL functions that tell you how close two strings are, not just whether they're equal.  isn't .  isn't .  isn't . To an equality check, each pair is simply different. To your business, each is a near miss worth catching. Today, fuzzy string matching is generally available in Microsoft SQL.  tells you  is one edit from .  scores  and  at 96 out of 100. It all runs in T-SQL, right where your data lives, with no external libraries, models, or custom code. Available across all SKUs of: What fuzzy string matching actually means Fuzzy string matching measures how closely two str...

Nov 16, 2026
Post comments count 0
Post likes count 0

SqlPackage Deployment History and Fast Comparison Preview

Matt Hyon

Database deployments should be repeatable. A SQL database project describes the desired schema, its build produces a , and SqlPackage compares that model with a target database to work out the changes to apply. But what happens when a pipeline publishes the same database model again? Even when nothing needs to change, determining that can still involve a full schema comparison. The SqlPackage 170.6 preview introduces two complementary capabilities: Let's look at what these options do and try them out. Preview scope: This walkthrough targets the NuGet package version . Its executable repor...

Nov 16, 2026
Post comments count 0
Post likes count 0

What’s new across Microsoft SQL at Microsoft Ignite 2026

Anna Hoffman

From Microsoft Ignite I’m here in San Francisco enjoying specialty lattes, fall-ish weather (I guess?), and all the excitement around Microsoft announcements at Ignite 2026. It’s a cool energy to be surrounded by so many people at organizations that are trying to innovate with AI for the era of AI. These applications are the apps that run our world, and how they advance (or don’t) will change their trajectories at those companies as well as likely have real impact on our day-to-day lives. At Microsoft Ignite, our Microsoft SQL announcements focus on making the innovation path simpler: modernize existing app...

Nov 11, 2026
Post comments count 0
Post likes count 1

Resources for the SQL AI Developer

Jerry Nixon

I see three agentic stories shaping SQL’s future. Here’s how DP-800 connects the pieces and helps you build the skills to put SQL’s AI capabilities to work.

Nov 11, 2026
Post comments count 0
Post likes count 2

What’s new across Microsoft SQL in 2026 so far: the PASS Summit West roundup

Anna Hoffman

[almost] A year of building on Microsoft SQL - 2026 I'm back with a really long and exhaustive list of updates across Microsoft SQL in 2026. This time I'm tuning in from PASS Summit West, and I actually did this blog as a session with other members from the Microsoft SQL team. I'll put a link to that here once it's live. At PASS Summit West, it's a good time to take stock of what changed this year. From SQLCon/FabCon in Atlanta to Microsoft Build and SQLCon/FabCon Europe in Barcelona, the SQL team has shipped updates across SQL Server, Azure SQL, SQL database in Microsoft Fabric, and the tools you use every...

Nov 9, 2026
Post comments count 0
Post likes count 0

How do you run a query against data the database can’t read?

Anna Hoffman

Under the Hood: The Research Behind Microsoft SQL, part 3 Encryption at rest solves one threat. It stops someone who walks off with the disk. It does nothing about someone with administrative access to the running server, because the database decrypts data into memory to do anything useful with it. For a lot of workloads that gap doesn’t matter. For health records, financial data, or anything where the customer’s threat model includes the cloud operator, it matters a great deal. Azure SQL Database Always Encrypted (SIGMOD 2020) describes how SQL Server runs real queries, including range comparisons and L...