ErikEJ’s blog

If you deploy .dacpac files frequently, you know how much time is wasted when nothing has actually changed.

When SQL Server Management Studio 21 arrived on the Visual Studio 2022 shell, it opened the door for third-party extensions in SSMS for the first time in years.

I'm excited to announce that the T-SQL Analyzer is now available for Visual Studio Code!

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.

The T-SQL Analyzer extensions for Visual Studio and SQL Server Management Studio have been significantly updated.

SQL Server Management Studio (SSMS) 22.7 introduces support for agents and MCP (Model Context Protocol) Servers, opening new possibilities for integrating third-party analysis tools directly into your development workflow.

In this blog post I will describe a new feature in SQL Project Power Tools: Publish programmability objects on save.

SqlServer.Rules v5.0.0 is now available SqlServer.Rules is an open-source static code analysis library and toolset for SQL Server database projects, command line, and Visual Studio, that helps teams catch design flaws, naming inconsistencies, performance…

I’m excited to announce the launch of the SSMS Extension Gallery: 👉 Find it here This new page gives SQL Server developers and DBAs a quick overview of tools that can improve day-to-day work in SQL Server Management Studio 22.

Keeping your SQL database project in sync with a live database is one of the most common — and most tedious — challenges in database development.

Configuring SQL static code analysis rules just got easier.