#dacfx
LightNews LightNews
erikej.bsky.social
I've updated DacDeploySkip with improvements that make SQL database deployments easier:

• Simpler CI/CD configuration
• Support for publish profiles

This makes deployment settings easier to manage across environments.

Read more: buff.ly/6oztrUo

#SQLServer #DacFx #SqlPackage #DevOps #DotNet
DacDeploySkip update: simpler CI and publish profile support
If you deploy .dacpac files frequently, you know how much time is wasted when nothing has actually changed.
erikej.github.io
September 13, 2026 at 12:36 PM
dustin.nz
Whoops. Microsoft accidently leaked the name of the next version of #SQLServer.

github.com/microsoft/Da...
DacFx/release-notes/Microsoft.SqlPackage/170.5/170.5.38-preview.md at main · microsoft/DacFx
DacFx, SqlPackage, and other SQL development libraries enable declarative database development and database portability across SQL versions and environments. Share feedback here on dacpacs, bacpacs...
github.com
September 10, 2026 at 2:42 AM
erikej.bsky.social
Microsoft SQL Bacpac and Dacpac, the similarities and differences - from Drew Skwiers-Koballa
#sqlserver #dacfx #dotnet
devblogs.microsoft.com/azure-sql/ba...
Bacpac and Dacpac, the similarities and differences - Azure SQL Dev Corner
When you need to move an entire database or move the objects in a database, bacpac and dacpac files often come up because of all of the tooling options to
devblogs.microsoft.com
September 2, 2026 at 7:22 AM
azureweekly.info
Launch: T-SQL Analyzer live analysis now in VS Code by Erik Ejlskov Jensen
https://erikej.github.io/sql/dacfx/vscode/2026/08/12/tsql-analyzer-vscode.html?utm_source=bluesky&utm_medium=social&utm_campaign=newsletter
Launch: T-SQL Analyzer live analysis now in VS Code by Erik Ejlskov Jensen
I'm excited to announce that the T-SQL Analyzer is now available for Visual Studio Code! You can now catch T-SQL mistakes as you type, directly in the VS Code editor — no build step required.
erikej.github.io
August 27, 2026 at 10:55 PM
robrich.bsky.social
erikej.github.io/sql/dacfx/vs... - #mssql #analyzer in #VSCode
Launch: T-SQL Analyzer live analysis now in VS Code
I'm excited to announce that the T-SQL Analyzer is now available for Visual Studio Code! You can now catch T-SQL mistakes as you type, directly in the VS Code editor — no build step required.
erikej.github.io
August 24, 2026 at 9:59 PM
erikej.bsky.social
🚀 T-SQL Analyzer is now available for VS Code!

Get real-time feedback on your .sql files — design, naming & performance issues highlighted as you type, powered by 140+ open-source DacFX rules.
Works on any SQL script
Read more 👉 buff.ly/2AQVKfq
#SQLServer #TSQL #VSCode #dotnet
Launch: T-SQL Analyzer live analysis now in VS Code
I'm excited to announce that the T-SQL Analyzer is now available for Visual Studio Code! You can now catch T-SQL mistakes as you type, directly in the VS Code editor — no build step required.
erikej.github.io
August 12, 2026 at 1:24 PM
azureweekly.info
From 20+ seconds to 2 - faster SQL Database Project .dacpac deployments are finally here (preview) by Erik Ejlskov Jensen
https://erikej.github.io/dotnet/dacfx/sqlserver/sqlpackage/2026/08/06/faster-dacpac-deployments.html?utm_source=bluesky&utm_medium=social&utm_campaign=newsletter
From 20+ seconds to 2 - faster SQL Database Project .dacpac deployments are finally here (preview) by Erik Ejlskov Jensen
If you have ever deployed a SQL Database Project (.sqlproj) or a .dacpac with SqlPackage, you know the drill: you kick off a publish against an empty or near-empty database, grab a coffee, and wait. Even for tiny schemas, every single publish reliably took 20+ seconds before anything actually happened on the server.
erikej.github.io
August 10, 2026 at 2:15 AM
erikej.bsky.social
🚀 Faster .dacpac deployments are finally here (preview)!
That reliable ~20 second "startup tax" on every SqlPackage publish is gone — warm publishes now run in ~2 seconds. A 10x win for inner-loop dev and CI. ⚡
How to grab the preview: buff.ly/I62FLbK
#dotnet #SQLServer #DacFx #SqlPackage
From 20+ seconds to 2 - faster SQL Database Project .dacpac deployments are finally here (preview)
If you have ever deployed a SQL Database Project (.sqlproj) or a .dacpac with SqlPackage, you know the drill: you kick off a publish against an empty or near-empty database, grab a coffee, and wait.…
erikej.github.io
August 6, 2026 at 3:41 PM
erikej.bsky.social
Recently released: Updates to SQL projects in SSMS, VS Code, and SqlPackage - nice to see the continued focus and roadmap updates to keep the DacFX eco system alive and well
#sqlserver #sql #dacfx #vscode
Recently released: Updates to SQL projects in SSMS, VS Code, and SqlPackage | Microsoft Community Hub
Your database should be part of the same development process as the rest of your application, with source control and automation for validation and...
buff.ly
July 21, 2026 at 12:36 PM
azureweekly.info
Visual Schema Compare for SDK Style SQL Database Projects in Visual Studio and SSMS by Erik Ejlskov Jensen #Azure erikej.github.io/dotnet/dacfx...
Visual Schema Compare for SDK Style SQL Database Projects in Visual Studio and SSMS
Keeping your SQL database project in sync with a live database is one of the most common — and most tedious — challenges in database development. If you have ever manually compared CREATE TABLE scripts...
erikej.github.io
April 27, 2026 at 8:45 PM
jonsagara.com
Visual Schema Compare for SDK Style SQL Database Projects in Visual Studio and SSMS erikej.github.io/dotnet/dacfx...
Visual Schema Compare for SDK Style SQL Database Projects in Visual Studio and SSMS
Keeping your SQL database project in sync with a live database is one of the most common — and most tedious — challenges in database development. If you have ever manually compared CREATE TABLE script...
erikej.github.io
April 20, 2026 at 2:20 PM
erikej.bsky.social
New blog post ✍️
I’ve built SQL Projects Rule Manager – a simple way to manage SQL code analysis rules for SQL Database Projects directly in Visual Studio and SSMS.
If you use DacFx or SQL projects, this one’s for you 👇
buff.ly/jqYjy6d
#SQLServer #DatabaseTools #DotNet
New Visual Rule Manager: Configure SQL Code Analysis Without Editing XML
Configuring SQL static code analysis rules just got easier. The latest release of SQL Database Project Power Tools includes a visual Rule Manager — a settings dialog that lets you enable, disable,…
buff.ly
April 13, 2026 at 12:36 PM
datachick.bsky.social
github.com/microsoft/Da...

Are you a SQL developer? Find out what’s coming in sqlprojects in the 2026 roadmap.
#SQLServer #AzureSQLDB
#DevOps
Q2 CY2026 Primary milestone: https://github.com/microsoft/DacFx/milestone/16 e SqlPackage SqlPackage config/environment file public preview & Microsoft.Build.Sql • Pre-plan script support in Microsoft.Build.Sql preview, GitHub issue VS Code SQL Database Projects extension • * Code analysis settings @ SSMS • % SQL projects public preview, Developer Community • * Schema compare public preview 2 Fabric CI/CD integration • Code analysis integration • Important but not yet scheduled @ SqlPackage Rebuilt Azure DevOps
March 25, 2026 at 9:37 PM
erikej.bsky.social
Batteries included: Database DevOps with SQL projects - long blog post explaining database DevOps and the latest updates for the SQL Server team
#sqlserver #devops #dacfx #dotnet
blog.fabric.microsoft.com/en-us/blog/b...
Batteries included: Database DevOps with SQL projects | Microsoft Fabric Blog | Microsoft Fabric
Database changes shouldn’t be the last manual step in your release process. As teams adopt DevOps practices to ship application code faster and more reliably, the database has remained a…
blog.fabric.microsoft.com
March 24, 2026 at 2:11 PM
erikej.bsky.social
Just blogged: "8 New T-SQL Analysis Rules to Catch Bugs Before They Reach Production" - the blog post explains the new rules, and the many ways you can take advantage of them.
#dotnet #sqlserver #dacfx
8 New T-SQL Analysis Rules to Catch Bugs Before They Reach Production
Static analysis catches an entire class of bugs and anti patterns during the build process, long before code ever runs in production. The SqlServer.Rules library has just grown with 8 new rules — 7…
buff.ly
March 4, 2026 at 2:33 PM
drewsk.bsky.social
Hi - not abandoned but no timeline to VS2026 support. VS Code now, SSMS soon, and based on interest maybe-to-likely VS in the future. aka.ms/sqlprojects-...
Am I understanding correctly that you're using the sqlproj unit test framework in VS?
Home
DacFx, SqlPackage, and other SQL development libraries enable declarative database development and database portability across SQL versions and environments. Share feedback here on dacpacs, bacpacs...
aka.ms
February 17, 2026 at 7:07 PM
robrich.bsky.social
erikej.github.io/dotnet/dacfx... - #SQL #Database project power tools for #dotNET and #MSSQL developers looking to version their data schema.
Getting Started with SQL Database Project Power Tools
SQL Database Project Power Tools is a free Visual Studio extension that makes working with SQL database projects easier and more productive. This guide will help you get started with the key features.
erikej.github.io
February 13, 2026 at 4:55 PM
drewsk.bsky.social
Yep, it has a limited scope of useful scenarios. If you're interested in a fully pre-plan script vote/comment on this item - github.com/microsoft/Da...
Add Pre-compare Script Option for DACPAC Publishing · Issue #482 · microsoft/DacFx
https://developercommunity.visualstudio.com/t/Add-Pre-compare-Script-Option-for-DACPAC/10594162 Bringing this item over from VS Developer Community since the core implementation would be in Microso...
github.com
February 13, 2026 at 2:46 PM
erikej.bsky.social
There is now a roadmap for sqlpackage / DacFX - note the plans to add support for SQL Database Projects in SSMS!
#dotnet #sqlserver
buff.ly/E8GDDQp
Home
DacFx, SqlPackage, and other SQL development libraries enable declarative database development and database portability across SQL versions and environments. Share feedback here on dacpacs, bacpacs...
github.com
February 11, 2026 at 5:27 PM
azureweekly.info
Getting Started with SQL Database Project Power Tools by Erik Ejlskov Jensen #Azure erikej.github.io/dotnet/dacfx...
Getting Started with SQL Database Project Power Tools
SQL Database Project Power Tools is a free Visual Studio extension that makes working with SQL database projects easier and more productive. This guide will help you get started with the key features.
erikej.github.io
February 3, 2026 at 8:40 AM
erikej.bsky.social
December .NET Data countdown 14: Awesome .NET Data command line tools - SqlPackage - extract, publish, script your database schema:
Microsoft.SqlPackage 170.2.70
SqlPackage is a command-line utility that automates database development tasks by exposing some of the public Data-Tier Application Framework (DacFx) APIs.
buff.ly
December 14, 2025 at 3:31 PM
erikej.bsky.social
December .NET Data countdown 11:

Reduce SQL Database Project deployment time from minutes to single digit seconds with DacDeploySkip | ErikEJ's blog
#sqlserver #pipelines #dacfx
Reduce SQL Database Project deployment time from minutes to single digit seconds with DacDeploySkip
Using SQL Database Projects for deployment of schema changes with a .dacpac file to SQL Server and Azure SQL Database is a great, free solution, supported by many tools, like SQL Server Data Tools…
buff.ly
December 11, 2025 at 4:23 PM
erikej.bsky.social
December .NET Data countdown 4:

Create a Custom Static Code Analysis Rule for Azure SQL Database / SQL Server with .NET
erikej.github.io/dacfx/dotnet...
How to: Code analyze your SQL Server T-SQL scripts in Visual Studio
Maybe you already take advantage of the C# code analyzers built into the .NET SDK, that help you improve code consistency, quality, security and avoid common mistakes and potential bugs.
erikej.github.io
December 4, 2025 at 6:34 PM
erikej.bsky.social
Dogfooding is the best 😅 - fixed a bug in my T-SQL Analyzer Visual Studio extension, where ignored rules were not respected - use it for live best practices analysis of your SQL scripts.
#sqlserver #dotnet #dacfx
buff.ly/hrOTHrH
T-SQL Analyzer - Visual Studio Marketplace
Extension for Visual Studio - T-SQL Analyzer, that analyzes your T-SQL object creation code for design, naming and performance issues using more than 140 rules.
marketplace.visualstudio.com
December 2, 2025 at 6:06 PM
erikej.bsky.social
"Azure SQL: Optimizing BACPAC Imports - SqlPackage Done Right!" - excellent post on how to make .bacpac imports run fast!
#azuresql #sqlserver #dacfx #sqlpackage
Azure SQL: Optimizing BACPAC Imports - SqlPackage Done Right! | Microsoft Community Hub
This is a frequent scenario, especially when migrating large databases to Azure. The truth is, the time taken for a BACPAC import depends on several factor:...
buff.ly
November 22, 2025 at 8:22 AM