Phil Factor demonstrates why SQL Prompt has a 'Best Practice' rule (BP010) that checks for use of the @@IDENTITY function, and suggests less error-prone ways to get the latest identity values used in a table.
2019-09-05
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
By nelsonaloor
I am a SQL Administrator and today I will share my experience about an...
By damianwidera
Good morning! It was a tough weekend as we supposed to be in Goteborg...
By Steve Jones
Not something you’ll do too often, but you might find yourself doing this if...
Comments posted to this topic are about the item Is Data the Future of...
Genbrain Israel There are lots of sorts of trauma and fears that have their...
Hi All, This is more of a security related question. Usually, we connect to...
Ask SSC