SQL injection refers to the ability of an attacker to inject a rogue SQL command to the database within a seemingly legitimate request. One of the most common myths that surrounds SQL Injection is that it is due to the use of EXEC or EXECUTE. Some say –...

Occasionally I will need to monitor tables and generate alerts based on the number of records in a table. Collecting the row count in an efficient way becomes very important on a busy system. I have found this method to be the most efficient way to coll...