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’s blog
.NET Data Access and more
Latest posts
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. Even for tiny schemas, every single publish reliably took 20+ seconds before anything actually happened on the server.
Updated: T-SQL Analyzer live analysis now in SSMS and Visual Studio
The T-SQL Analyzer extensions for Visual Studio and SQL Server Management Studio have been significantly updated. Here's what's new.
Deterministic SQL Bad Practice Detection in SSMS 22.7 with T-SQL Analyzer MCP Server and Copilot
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 post, I'll show you how to use the T-SQL Analyzer MCP Server to deterministically detect bad practices and anti-patterns in your SQL Server scripts right within SSMS.
Instantly deploy T-SQL programmability changes on save in SQL Projects with SQL Project Power Tools
In this blog post I will describe a new feature in SQL Project Power Tools: Publish programmability objects on save. This feature lets you instantly deploy stored procedures, views, functions, and triggers to your development database the moment you save the corresponding .sql file in Visual Studio — no full dacpac deployment required.
SqlServer.Rules 5.0.0 is out 🎉
SqlServer.Rules v5.0.0 is now available
Launching the SSMS Extension Gallery
I’m excited to announce the launch of the SSMS Extension Gallery:
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 line by line, or tried to figure out which stored procedures drifted out of sync between your source code and development or production environments, Visual Schema Compare was built for you.
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, and configure rule severity without manually editing your SQL Database project file.
Publish SQL Database Projects as Container Images with MSBuild.Sdk.SqlProj
Database deployments have traditionally been one of the trickier parts of a CI/CD pipeline. You need the right tools installed, the right permissions configured, and the right SQL Server instance reachable—all at deploy time. MSBuild.Sdk.SqlProj simplifies this by letting you manage your SQL Server schema as code and build a .dacpac file just like any other .NET project. Starting with version…