--- title: Launch: T-SQL Analyzer live analysis now in VS Code description: A new VS Code extension brings the T-SQL Analyzer's live static analysis to the editor, catching design, naming, and performance issues in SQL scripts as you... canonical: https://daily.dev/posts/launch-t-sql-analyzer-live-analysis-now-in-vs-code-98pspivuj twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Launch: T-SQL Analyzer live analysis now in VS Code | daily.dev og:description: A new VS Code extension brings the T-SQL Analyzer's live static analysis to the editor, catching design, naming, and performance issues in SQL scripts as you... og:url: https://daily.dev/posts/launch-t-sql-analyzer-live-analysis-now-in-vs-code-98pspivuj og:image: https://api.daily.dev/og/posts/98PSpIvUj.png og:image:alt: Launch: T-SQL Analyzer live analysis now in VS Code og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Launch: T-SQL Analyzer live analysis now in VS Code **[We Are .NET](https://daily.dev/sources/wearedotnet)** · 3 min read · 1 upvotes · 0 comments ## Summary A new VS Code extension brings the T-SQL Analyzer's live static analysis to the editor, catching design, naming, and performance issues in SQL scripts as you type, with no build step required. It uses the same 140+ open source DacFX-based rules already available in the Visual Studio and SSMS extensions, adding a dedicated .sql file analyzer with hover documentation, customizable rule expressions, configurable SQL Server version targeting, and command palette actions. Requires the .NET 10 SDK and installs analyzer tooling automatically on first use. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### Is there a VS Code extension for live T-SQL static analysis? Yes, the T-SQL Analyzer extension is available for Visual Studio Code, providing real-time analysis of .sql files as you type. It highlights design, naming, and performance issues using over 140 built-in rules, requires no build step, and needs the .NET 10 SDK installed to download the analyzer tooling automatically on first use. _daily.dev helps developers track new SQL tooling releases like this one across editors._ ### How do I disable a specific T-SQL Analyzer rule in VS Code? Use the tsqlAnalyzer.rules setting with a rules expression, such as -SqlServer.Rules.SRD0004 to disable a single rule, -SqlServer.Rules.SRN* to disable all naming rules, or +!SqlServer.Rules.SRN0005 to promote a rule to an error. Multiple expressions can be combined with semicolons in the same setting. _developers tuning static analysis rulesets can find configuration walkthroughs like this on daily.dev._ ### What SQL Server versions can the T-SQL Analyzer target? The tsqlAnalyzer.sqlVersion setting controls the targeted version, defaulting to Sql170, with other supported values including Sql160, SqlAzure, and SqlDwUnified. This lets the analyzer apply version-specific rule behavior when checking stored procedures, queries, migration scripts, or ad hoc SQL edits. _daily.dev surfaces practical configuration details for developers standardizing SQL Server tooling._ ## Similar posts on daily.dev - [Updated: T-SQL Analyzer live analysis now in SSMS and Visual Studio](https://daily.dev/posts/updated-t-sql-analyzer-live-analysis-now-in-ssms-and-visual-studio-wmm37dku6) · We Are .NET · 4 upvotes · 1 comments - [SQL code analysis in VS Code: Configure rules without editing your project file](https://daily.dev/posts/sql-code-analysis-in-vs-code-configure-rules-without-editing-your-project-file-yrj9d2yp0) · DevBlogs · 0 upvotes · 0 comments - [A better way to work with SQL Server](https://daily.dev/posts/a-better-way-to-work-with-sql-server-thprghiwd) · InfoWorld · 3 upvotes · 0 comments - [New Visual Rule Manager: Configure SQL Code Analysis Without Editing XML](https://daily.dev/posts/new-visual-rule-manager-configure-sql-code-analysis-without-editing-xml-scsoekjj8) · We Are .NET · 1 upvotes · 0 comments - [MSSQL Extension for VS Code: New Getting Started Page, Agent skills, SQL Formatter, and more](https://daily.dev/posts/mssql-extension-for-vs-code-new-getting-started-page-agent-skills-sql-formatter-and-more-yvnc8wtts) · DevBlogs · 0 upvotes · 0 comments --- Tags: [#vscode](https://daily.dev/tags/vscode), [#microsoft-sql-server](https://daily.dev/tags/microsoft-sql-server) [View this post on daily.dev](https://daily.dev/posts/launch-t-sql-analyzer-live-analysis-now-in-vs-code-98pspivuj) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Launch: T-SQL Analyzer live analysis now in VS Code","url":"https://daily.dev/posts/launch-t-sql-analyzer-live-analysis-now-in-vs-code-98pspivuj","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/launch-t-sql-analyzer-live-analysis-now-in-vs-code-98pspivuj"},"datePublished":"2026-08-12T18:52:58.606Z","dateModified":"2026-09-14T06:53:59.972Z","description":"A new VS Code extension brings the T-SQL Analyzer's live static analysis to the editor, catching design, naming, and performance issues in SQL scripts as you...","image":"https://media.daily.dev/image/upload/s--2-1xRawN--/f_auto/v1722860399/public/Placeholder%2011","thumbnailUrl":"https://media.daily.dev/image/upload/s--2-1xRawN--/f_auto/v1722860399/public/Placeholder%2011","isAccessibleForFree":true,"articleSection":"We Are .NET","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"We Are .NET","logo":"https://media.daily.dev/image/upload/s--BsnVOa3i--/f_auto/v1718347410/logos/wearedotnet","url":"https://daily.dev/sources/wearedotnet"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/launch-t-sql-analyzer-live-analysis-now-in-vs-code-98pspivuj","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":1},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"vscode,microsoft-sql-server","timeRequired":"PT3M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"We Are .NET","item":"https://daily.dev/sources/wearedotnet"},{"@type":"ListItem","position":3,"name":"Launch: T-SQL Analyzer live analysis now in VS Code"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/launch-t-sql-analyzer-live-analysis-now-in-vs-code-98pspivuj#faq","mainEntity":[{"@type":"Question","name":"Is there a VS Code extension for live T-SQL static analysis?","acceptedAnswer":{"@type":"Answer","text":"Yes, the T-SQL Analyzer extension is available for Visual Studio Code, providing real-time analysis of .sql files as you type. It highlights design, naming, and performance issues using over 140 built-in rules, requires no build step, and needs the .NET 10 SDK installed to download the analyzer tooling automatically on first use. daily.dev helps developers track new SQL tooling releases like this one across editors."}},{"@type":"Question","name":"How do I disable a specific T-SQL Analyzer rule in VS Code?","acceptedAnswer":{"@type":"Answer","text":"Use the tsqlAnalyzer.rules setting with a rules expression, such as -SqlServer.Rules.SRD0004 to disable a single rule, -SqlServer.Rules.SRN* to disable all naming rules, or +!SqlServer.Rules.SRN0005 to promote a rule to an error. Multiple expressions can be combined with semicolons in the same setting. developers tuning static analysis rulesets can find configuration walkthroughs like this on daily.dev."}},{"@type":"Question","name":"What SQL Server versions can the T-SQL Analyzer target?","acceptedAnswer":{"@type":"Answer","text":"The tsqlAnalyzer.sqlVersion setting controls the targeted version, defaulting to Sql170, with other supported values including Sql160, SqlAzure, and SqlDwUnified. This lets the analyzer apply version-specific rule behavior when checking stored procedures, queries, migration scripts, or ad hoc SQL edits. daily.dev surfaces practical configuration details for developers standardizing SQL Server tooling."}}]} ```