It doesn’t take much to royally screw up a company’s records. You don’t have to be out for blood. You just need to make a mistake. See the fallout from this worker’s oopsie. A couple of jobs ago, I ...

pgtt is a PostgreSQL extension to create, manage and use Oracle-style Global Temporary Tables and the others RDBMS. The objective of this extension it to provide the Global Temporary Table feature to ...

Part of the SQL Server 2022 blog series. The main difference between tempdb and other databases is the workload. With tempdb we are constantly creating and destroying objects such as temp tables. This ...

PostgreSQL semantic of temporary tables is substantially different from that of Oracle. Oracle temporary tables are permanent, so their structure is static and visible to all users, and the content is ...

Data privacy is a major concern today for any organization that manages sensitive data or personally identifiable information (PII). Examples of such data include sensitive customer information such ...

Stored procedures can speed up your code by reducing trips to your database -- even if you only have one SQL statement to execute. Here's how to speed up your application (and how to simplify your ...

The importance of automating processes can’t be overestimated. Most things start out as a manual procedure until you work out exactly how things should happen, but many times they stay that way ...