Code Analysis

External Article

Database Code Analysis

  • Article

Database code analysis will reduce the number of 'code smells' that creep into your database builds. It will alert the team to mistakes or omissions, such as missing indexes, that are likely to cause performance problems in production. It will allow the Governance and Operations team visibility into production readiness of the code, warning them of security loopholes and vulnerabilities. William Brewer describes the two technical approaches to database code analysis, static and dynamic, and suggests some tools that can help you get started.

2017-08-18

3,546 reads

Blogs

EightKB 2025 – Schedule and Registration

By

Hello Hello, We. Are. Back! The schedule for EightKB 2025 Edition has been announced!...

Why Not Just Use VARCHAR(MAX)?

By

A while ago I was looking into some odd errors that were cropping up...

Quick Wins with GenAI

By

The more I look to GenAI to save me minutes, short periods of time,...

Read the latest Blogs

Forums

Batchmode execution in SQL 2019

By cooldude001

Is there a way to force a query to use Batchmode execution, my database...

How to Work with RStudio and SQL Server

By Daniel Calbimonte

Comments posted to this topic are about the item How to Work with RStudio...

Finding Heaps

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Finding Heaps

Visit the forum

Question of the Day

Finding Heaps

If I am querying DMVs for a heap, what do I look for?

See possible answers