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

The Third Sabbatical

By

I can’t believe I’ve been at Redgate long enough to get a third sabbatical....

Advice I Like: Focus on what’s important

By

Don’t let someone else’s urgency becomes your emergency. In fact, don’t be governed by...

Is Air Travel Still Safe? | Ahmedabad Plane Crash 2025 Explained | Aviation Safety & AI Solutions

By

Is Air Travel Safe? Yes, air travel remains statistically the safest mode of transportation. In...

Read the latest Blogs

Forums

Azure Database Watcher Monitoring

By bokswager

Hi, I’ve provisioned an Azure Database Watcher to monitor our 4 Azure SQL Managed...

Can You Ask for a Raise?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Can You Ask for a...

Stored Procedure Generation Script

By Deepam Ghosh

Comments posted to this topic are about the item Stored Procedure Generation Script

Visit the forum

Question of the Day

Generating a Series I

What is returned by this code in SQL Server 2022?

SELECT value
FROM GENERATE_SERIES(4, 1);

See possible answers