Connecting to databases via SSH Tunneling is something developers and IT professionals often need to do. And HeidiSQL is one of the more popular open-source database tools. While HeidiSQL fully supports SSH tunneling, there doesn’t seem to be any documentation about how to accomplish this. So, after struggling with this for a few hours and figuring it out, I put these instructions together to help others.
Database
What is a Dirty Read in SQL Server and How to Avoid Them?
A dirty read is a database activity that ruins your reports and applications. Dirty reads are often nightmares that require the help of database administrators and developers. This article explains dirty reads and what you can do to increase data integrity in your SQL Server queries.
Protect SQL Statements From Accidental Update/Delete
The designers of SQL for some reason did not require a keyword (like “ALL”) to protect SQL statements from accidental updates or deletes. Especially when the UPDATE or DELETE statement doesn’t contain a WHERE clause. I wonder if this was deliberate or if it was an oversight. In any case, the programmer becomes “all-powerful”. The significance of this problem will be better appreciated with an example…
