#dacfx
LightNews LightNews
alvinashcraft.com
Introducing MSBuild.Sdk.SqlProj 3.0 - create, build, validate, analyze, pack and deploy SQL database projects with .NET 9.

https://erikej.github.io/dotnet/dacfx/azuresql/2025/01/14/dacfx-msbuild-sdk-sqlproj-3.html
#visualstudio #dotnet #sqlserver #msbuild #data #deployment
Introducing MSBuild.Sdk.SqlProj 3.0 - create, build, validate, analyze, pack and deploy SQL database projects with .NET 9
In this blog post I will introduce you to a .NET build SDK, that I help maintain.
erikej.github.io
January 15, 2025 at 6:00 PM
erikej.bsky.social
You can now very easily deploy your SQL Database project in your .NET Aspire 9 AppHost - provision your database schema! Try the preview now: www.nuget.org/packages/Com...
#dotnet #aspire #dacfx
CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects 9.0.0-beta.63
An Aspire hosting integration capable of deploying SQL Server Database Projects as part of your AppHost.
www.nuget.org
November 12, 2024 at 4:46 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
erikej.bsky.social
Next-gen SQL Database projects with Microsoft. Build.Sql - from .NET Conf 2024 with @dzsquared
#dotnet #dacfx #sqlserver https://buff.ly/3CIcit6
Next-gen SQL projects with Microsoft.Build.Sql
Your database objects are stored as code for development in Visual Studio or VS Code with Microsoft.Build.Sql SDK-style SQL projects, but the advantages don’...
buff.ly
November 23, 2024 at 9:22 AM
alvinashcraft.com
Presenting T-SQL Analyzer CLI - identify anti-patterns in SQL Server scripts with 140+ rules by Erik EJ.

https://erikej.github.io/sql/dacfx/2025/02/17/sql-dacfx-analyzer.html

#sqlserver #tsql #cli #commandline #scripting
Presenting T-SQL Analyzer CLI - identify anti-patterns in SQL Server scripts with 140+ rules
T-SQL Analyzer is a free, open-source new command line tool for identifying, and reporting the presence of anti-patterns in SQL Server T-SQL scripts.
erikej.github.io
February 18, 2025 at 6:00 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
Our community SDK MSBuild. Sdk.Sqlproj for building, analyzing and testing SQL Database Projects has just been updated to support .NET 9, better code analysis and much more.
#dotnet #dacfx #sqlserver
Release notes:
Release v3.0.0 · rr-wfm/MSBuild.Sdk.SqlProj
What's Changed New features Use .NET 9 and remove .NET 6 BREAKING by @ErikEJ in #634 SqlCmdVariable DefaultValue should not be written to .dacpac as per docs BREAKING by @ErikEJ in #656 Enable sup...
buff.ly
November 23, 2024 at 2:36 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
erikej.bsky.social
New release of T-SQL Analyzer CLI - adds the ability to analyze a .dacpac or a live database!! 🥳 🤯

To install:
dotnet tool install -g ErikEJ.DacFX.TSQLAnalyzer.Cli

erikej.github.io/sql/dacfx/20...
Presenting T-SQL Analyzer CLI - identify anti-patterns in SQL Server scripts with 140+ rules
T-SQL Analyzer is a free, open-source new command line tool for identifying, and reporting the presence of anti-patterns in SQL Server T-SQL scripts.
erikej.github.io
February 23, 2025 at 4:29 PM
erikej.bsky.social
Just blogged: Introducing MSBuild.Sdk.SqlProj 3.0 - create, build, validate, analyze, pack and deploy SQL database projects with .NET 9
#dotnet #sqlserver #dacfx
Introducing MSBuild.Sdk.SqlProj 3.0 - create, build, validate, analyze, pack and deploy SQL database projects with .NET 9
In this blog post I will introduce you to a .NET build SDK, that I help maintain.
buff.ly
January 15, 2025 at 9:22 AM
erikej.bsky.social
I maintain a free Visual Studio extension to improve the workflow for SQL Database projects of any variety. In the latest release I have added support for creating seed data (merge scripts) to populate tables as part of your .dacpac package.

#sqlserver #visualstudio #dacfx
SQL Database Project Power Tools - Visual Studio Marketplace
Extension for Visual Studio - Tools to enhance the SQL Database Projects developer experience, including Project and Item templates, Import existing databases, create E/R diagrams and much more.
buff.ly
November 16, 2025 at 8:22 AM
erikej.bsky.social
I have a session 🥳 - at the free, online EightKB SQL Server internals conference on August 21 - "Fix your SQL database design with T-SQL static code analysis" - I am sure you will find that and the other awsome sessions useful.

Sign up today at buff.ly/SJ8mwJ2
#sqlserver #eightkb #dotnet #dacfx
EIGHTKB - The SQL Server Internals Conference
A virtual MS Data Platform conference focusing on SQL Server internals.
buff.ly
July 1, 2025 at 8:22 AM
erikej.bsky.social
Just blogged: Manage your SQL Server database lifecycle with .NET Aspire and the SQL Database Projects hosting extension
#dotnetaspire #dotnet #sqlserver #dacfx

buff.ly/SA3C0JO
Manage your SQL Server database lifecycle with .NET Aspire and the SQL Database Projects hosting extension
.NET Aspire provides tools, templates, and packages to help you build observable, production-ready apps. Delivered through NuGet packages, .NET Aspire simplifies common challenges in modern app…
erikej.github.io
May 18, 2025 at 12:48 PM
erikej.bsky.social
New release of DacFX and SqlPackage (for automating SQL Database Projects) - adds the ability to ignore post and pre deploy scripts during deployment
#dotnet #dacfx
DacFx and SqlPackage Release Notes - SQL Server
Release notes for Microsoft SqlPackage.
buff.ly
August 1, 2025 at 1:36 PM
erikej.bsky.social
Did you rely on the SDK style SQL project in Visual Studio 2022 (with the Microsoft. Build.Sql SDK) and realize this no longer works in VS 2026?

Fear not, you can use our community SDK MsBuild.Sdk.SqlProj in all your IDEs!
#dotnet #sqlserver #sqlprojects #dacfx #ssdt
buff.ly/5N5fLZD
September 22, 2025 at 1:36 PM
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
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
Any .NET devs out there interested in contributing (in close collaboration with me!) to a new VS extension for SQL developers? with the new .NET 8 based modern out of process SDK!
#dotnet #sqlserver #dacfx
buff.ly/KZCLysg
Add VS Extension - "SQL Analyzer" using new extensibility model · Issue #255 · ErikEJ/SqlServer.Rules
https://github.com/microsoft/VSExtensibility/tree/main/New_Extensibility_Model/Samples/MarkdownLinter Respect analysis settings from project file. Respect Sql SKU from project file Only run on MsBu...
github.com
August 6, 2025 at 10:08 AM
erikej.bsky.social
I am currently overhauling and modernizing the codebase for 120 .NET based T-SQL analyzer rules. If you would like to try to contribute, feel free to reach out via GitHub -
https://buff.ly/4akQctb #dotnet #sqlserver #dacfx #oss #github
GitHub - ErikEJ/SqlServer.Rules: SQL Server static code analysis rules for SQL Projects
SQL Server static code analysis rules for SQL Projects - ErikEJ/SqlServer.Rules
buff.ly
January 17, 2025 at 9:22 AM
erikej.bsky.social
Just blogged: Reduce SQL Database Project deployment time from minutes to single digit seconds with DacDeploySkip
#dotnet #sqlserver #deployment #devops
erikej.github.io/dacfx/perfor...
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 (SS...
erikej.github.io
October 22, 2025 at 2:58 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
Presenting T-SQL Analyzer - live best practices analysis of your SQL scripts in Visual Studio - analyze your SQL CREATE scripts for best practices relating to design, naming and performance as you author them in Visual Studio.
#sqlserver #dacfx #visualstudio
Presenting T-SQL Analyzer - live best practices analysis of your SQL scripts in Visual Studio
Analyze your SQL CREATE scripts for best practices relating to design, naming and performance as you author them in Visual Studio.
buff.ly
August 25, 2025 at 1:36 PM
erikej.bsky.social
Introducing the SDK-style SQL projects in Visual Studio - build everywhere, simpler, conflict free project files, PackageReferences to both .dacpacs and static analysis rules and more | Data Exposed with @drewsk.bsky.social
#dotnet #dacfx #visualstudio
learn.microsoft.com/en-us/shows/...
Introducing the SDK-style SQL projects in Visual Studio
Get to know SQL projects in their latest version with the Microsoft.Build.Sql project SDK. With SQL projects you can store your database definition in source control in addition to automating deployme...
learn.microsoft.com
November 6, 2024 at 7:42 AM
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
🚀 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