Trending

#dacfx

Latest posts tagged with #dacfx on Bluesky

Latest Top
Trending

Posts tagged #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…

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

0 0 0 0
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…

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

1 0 0 0
Preview
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.

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

4 0 0 0
Preview
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:...

"Azure SQL: Optimizing BACPAC Imports - SqlPackage Done Right!" - excellent post on how to make .bacpac imports run fast!
#azuresql #sqlserver #dacfx #sqlpackage

1 1 0 0
Preview
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.

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

14 3 0 0
Post image

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

3 3 0 0
Preview
Design · Issue #1 · ErikEJ/SqlProjectPowerTools Possible features Feature will apply to both classic .sql proj and MsBuild.Sdk.SqlProj projects, unless noted Import database (for MsBuild.Sdk.SqlProj only) Analyze (html output, from EF Core Power...

I am planning a new Visual Studio extension for SQL Database Project users - let me know what you think?
#sql #sqlserver #ssdt #dacfx

2 2 2 0
Preview
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.

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

4 1 0 0
Preview
Fix your SQL database design with T-SQL static code analysis - Erik Ejlskov Jensen If you are a database developer looking for ways to improve your database design or you want help others avoid database design mistakes, this session is for you. You will learn - how to add build…

Fix your SQL database design with T-SQL static code analysis!

Watch the session recording from my talk at the EightKB conference last week
#dacfx #sqlserver #dotnet

1 0 0 0
Preview
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...

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

5 2 1 0
Preview
DacFx and SqlPackage Release Notes - SQL Server Release notes for Microsoft SqlPackage.

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

1 0 0 0
EIGHTKB - The SQL Server Internals Conference A virtual MS Data Platform conference focusing on SQL Server internals.

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

9 2 0 0
Preview
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…

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

9 2 0 0
Preview
Recently released: Updates to the SqlPackage and the DacFx ecosystem | Microsoft Community Hub The quarterly release cadence for SqlPackage and DacFx continues with the 170.0 release in mid-April 2025. Recent releases to SqlPackage and DacFx ecosystem...

Check out the recently released updates to the #SqlPackage and the #DacFx ecosystem! They're pretty cool!

techcommunity.microsoft.com/blog/azuresq...

#Microsoft #SQLServer #SSDT #AzureSQL #Azure #MadeiraData #DevOps

0 0 0 0
Preview
Recently released: Updates to the SqlPackage and the DacFx ecosystem | Microsoft Community Hub The quarterly release cadence for SqlPackage and DacFx continues with the 170.0 release in mid-April 2025. Recent releases to SqlPackage and DacFx ecosystem...

Reading: Recently released: Updates to the #SqlPackage and the #DacFx ecosystem #AzureData #AzureSQL #SQLServer

0 0 0 0
Use SQL Server .NET Framework CLR objects with SDK based cross platform .dacpac builds SQL CLR objects are assemblies that are created in .NET Framework languages and deployed to the SQL Server. The SQL CLR objects can be used to extend the functionality of the SQL Server by creating…

Use SQL Server .NET Framework CLR objects with SDK based cross platform .dacpac builds
#dotnet #sqlserver #dacfx

2 0 0 0
Preview
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

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

4 0 0 0
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.

Just blogged: Introducing MSBuild.Sdk.SqlProj 3.0 - create, build, validate, analyze, pack and deploy SQL database projects with .NET 9
#dotnet #sqlserver #dacfx

9 6 0 0
Preview
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...

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:

21 4 0 0
Preview
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’...

Next-gen SQL Database projects with Microsoft. Build.Sql - from .NET Conf 2024 with @dzsquared
#dotnet #dacfx #sqlserver https://buff.ly/3CIcit6

17 3 1 0
Preview
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.

How to: Code analyze your SQL Server T-SQL scripts in Visual Studio | ErikEJ's blog
#Dotnet #sql #dacfx

1 0 0 0
Preview
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.

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

19 5 1 1
Preview
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...

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/...

6 2 1 0
Preview
Reading Notes #76

Last Reading Notes of the year is out! http://bit.ly/W9Dks8 about #azure #Biztalk #cloud #dacfx #PowerShell #readingsnotes #servicebus

0 0 0 0