Lightnews — Scholar-powered news

Presenting T-SQL Analyzer - live best practices analysis of your SQL scripts in Visual Studio

September 20, 2025 at 1:36 PM Everybody can reply

2 reposts 2 likes

2 2 2

Azure Weekly

@azureweekly.endj.in

Presenting T-SQL Analyzer - live best practices analysis of your SQL scripts in Visual Studio by Erik Ejlskov Jensen #dotnet #Azure erikej.github.io/sql/dacfx/vi...

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

September 11, 2025 at 6:35 AM Everybody can reply

ErikEJ

@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

Analyze your SQL CREATE scripts for best practices relating to design, naming and performance as you author them in Visual Studio.

Fix your SQL database design with T-SQL static code analysis - Erik Ejlskov Jensen

August 25, 2025 at 1:36 PM Everybody can reply

1 reposts 4 likes

1 4

ErikEJ

@erikej.bsky.social

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

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…

Add VS Extension - "SQL Analyzer" using new extensibility model · Issue #255 · ErikEJ/SqlServer.Rules

August 25, 2025 at 8:22 AM Everybody can reply

1 likes

1

ErikEJ

@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

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 Everybody can reply

2 reposts 5 likes

1 2 5

ErikEJ

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

EIGHTKB - The SQL Server Internals Conference

August 1, 2025 at 1:36 PM Everybody can reply

1 likes

1

ErikEJ

@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

A virtual MS Data Platform conference focusing on SQL Server internals.

Manage your SQL Server database lifecycle with .NET Aspire and the SQL Database Projects hosting extension

July 1, 2025 at 8:22 AM Everybody can reply

2 reposts 9 likes

2 9

Azure Weekly

@azureweekly.endj.in

Manage your SQL Server database lifecycle with .NET Aspire and the SQL Database Projects hosting extension by Erik Ejlskov Jensen #PowerShell #AzureDevOps erikej.github.io/sql/dacfx/as...

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

Presenting T-SQL Analyzer CLI - identify anti-patterns in SQL Server scripts with 140+ rules

June 11, 2025 at 12:05 AM Everybody can reply

2 likes

2

Jon Sagara

@jonsagara.com

A command line tool to analyze T-SQL #sqlserver erikej.github.io/sql/dacfx/20...

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.

Manage your SQL Server database lifecycle with .NET Aspire and the SQL Database Projects hosting extension

May 26, 2025 at 5:16 PM Everybody can reply

ErikEJ

@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

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

Recently released: Updates to the SqlPackage and the DacFx ecosystem | Microsoft Community Hub

May 18, 2025 at 12:48 PM Everybody can reply

2 reposts 9 likes

2 9

Eitan Blumin ⚡

@eitanblumin.bsky.social

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

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

Recently released: Updates to the SqlPackage and the DacFx ecosystem | Microsoft Community Hub

May 11, 2025 at 10:01 AM Everybody can reply

Azure Weekly

@azureweekly.endj.in

Recently released: Updates to the SqlPackage and the DacFx ecosystem by Drew Skwiers-Koballa #AzureSQLDatabase techcommunity.microsoft.com/t5/azure-sql...

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

Recently released: Updates to the SqlPackage and the DacFx ecosystem | Microsoft Community Hub

May 10, 2025 at 1:10 PM Everybody can reply

Bob Pusateri

@bobp.bsky.social

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

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

Recently released: Updates to the SqlPackage and the DacFx ecosystem | Microsoft Community Hub

May 7, 2025 at 4:41 PM Everybody can reply

ErikEJ

@erikej.bsky.social

Recently released: Updates to the SqlPackage and the DacFx ecosystem - JSON and VECTOR data types support, parquet support (still in progress), unpack and compare.
buff.ly/gqziNOk
#dotnet #sqlserver

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

Recently released: Updates to the SqlPackage and the DacFx ecosystem | Microsoft Community Hub

April 30, 2025 at 1:36 PM Everybody can reply

1 reposts

1

MS IT Tech News

@msittechnews.bsky.social

"Recently released: Updates to the SqlPackage and the DacFx ecosystem" techcommunity.microsoft.com/blog/AzureSQ... #Microsoft #techcommunity

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

Presenting T-SQL Analyzer CLI - identify anti-patterns in SQL Server scripts with 140+ rules

April 29, 2025 at 4:15 PM Everybody can reply

ErikEJ

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

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/sql/dacfx/20...

February 23, 2025 at 4:29 PM Everybody can reply

2 reposts 16 likes

2 16

David 🏳️‍🌈🦦🐈‍⬛🐧🎮🤠

@blue-labs.org

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.

Presenting T-SQL Analyzer CLI - identify anti-patterns in SQL Server scripts with 140+ rules

February 19, 2025 at 12:44 AM Everybody can reply

Alvin Ashcraft

@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

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.

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, and SQL projects.

February 18, 2025 at 6:00 PM Everybody can reply

2 reposts 5 likes

1 2 5

Alex Meyer-Gleaves

@alexmg.dev

Today's random GitHub ⭐!

microsoft/DacFx

Posted using Starrysky

GitHub - microsoft/DacFx

github.com

February 14, 2025 at 3:23 PM Everybody can reply

ErikEJ

@erikej.bsky.social

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

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…

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

January 29, 2025 at 9:22 AM Everybody can reply

2 likes

2

Azure Weekly

@azureweekly.endj.in

Introducing MSBuild.Sdk.SqlProj 3.0 - create, build, validate, analyze, pack and deploy SQL database projects with .NET 9 by Erik Ejlskov Jensen https://erikej.github.io/dotnet/dacfx/azuresql/2025/01/14/dacfx-msbuild-sdk-sqlproj-3.html?utm_source=bluesky&utm_medium=social&utm_campaign=azureweekly

In this blog post I will introduce you to a .NET build SDK, that I help maintain.

GitHub - ErikEJ/SqlServer.Rules: SQL Server static code analysis rules for SQL Projects

January 20, 2025 at 9:45 AM Everybody can reply

1 reposts 1 likes

1 1

ErikEJ

@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

SQL Server static code analysis rules for SQL Projects - ErikEJ/SqlServer.Rules

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

January 17, 2025 at 9:22 AM Everybody can reply

4 likes

4

Alvin Ashcraft

@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

In this blog post I will introduce you to a .NET build SDK, that I help maintain.

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

January 15, 2025 at 6:00 PM Everybody can reply

3 reposts 8 likes

3 8

ErikEJ

@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

In this blog post I will introduce you to a .NET build SDK, that I help maintain.