TechCognia’s TSQL Plugin is a purpose-built extension for Microsoft SQL Server developers to assess, monitor, and enforce SQL coding standards using the power of SonarQube and SQL Code Guard. Designed to eliminate manual code review overhead, this plugin provides in-depth metrics, drilldowns, and automation to ensure your database scripts are reliable, secure, and maintainable.

• Automated SQL Code Review: Enforces pre-defined SQL coding standards without the need for tedious manual verification.
• Seamless SonarQube Integration: Fully integrates into your SonarQube environment.
• SQL Code Guard Compatibility: Leverages SQL Code Guard for static code analysis.

• Most Violated Rules
• Most Violated Resources
• Hotspots
• Trend of Issues Over Time
• Issue Statistics and Heatmaps
• File-Level Drilldown of Violations

View screenshots and drilldowns to visualize how issues are detected and how trends evolve across your projects.

• Windows 2003/2008 or Windows 7
• Microsoft .NET Framework 2.0 or higher
• SQL Code Guard
• SonarQube platform

Install and configure SonarQube following its official guide.

• Copy techcognia-tsql-plugin-X.X.X.X.jar into SONARQUBE_HOME/extensions/plugins.
• Copy SQLCodeGuard.msbuild into your SQL Code Guard installation directory.
• Restart the SonarQube server.
• Log in as System Administrator, go to:
  Configuration > General Settings > TSQL Plugin
• Set the following:
  • Path to SQLCodeGuard.msbuild
  • Path to MsBuild.exe
  • Paste your license key
• Save settings and restart SonarQube server again.

To analyze a TSQL project:

• Create a sonar-project.properties file in your project root.[Download Sample File]
• Run SonarQube analysis using the command:

sonar-runner

• View results at: http://localhost:9000

Refer to TechCognia’s Terms and Conditions

• Free to use.
• Redistribution is allowed with license inclusion.
• Commercial usage allowed with attribution.
• Full license at: http://sqlcodeguard.com

DISCLAIMER: THE SOFTWARE IS PROVIDED “AS IS”, WITHOUT WARRANTY OF ANY KIND. IN NO EVENT SHALL THE AUTHORS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY.

Visit the SQL Code Guard Website for comprehensive information about its features and the latest versions.

For plugin-specific queries or licensing, contact us at sales@techcognia.com.