Code Analysis

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

Cursor Dynamic SQL

By

Today was working on SQL Server cursor standard cursor deification would be like this:...

How to get the Active Directory user password policy values

By

Recently I have had to troubleshoot quite a bit of SQL login issues and...

How do you use PowerShell toc check if an active directory user locked out, disabled etc.?

By

If your organization uses a password policy (there are very good odds these days...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

XP_send mail fail

By ramyours2003

We migrated from sql 2005 to sql 2016  recently in one of the job...

How does DBCC CHECKDB use tempdb?

By RaufDBA

I would like to know the working principle of DBCC regarding the tempdb. I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers