Temporary Tables
There is a feature of SQL I have not seen used much and probably with good reason. […]
Database Theory
VIEW Objects
A view is a virtual table, created when it’s invoked by the < view name>. The goal […]
Data Control Language (aka Security)
Like ancient Gaul, SQL is divided into three sub- languages. The DDL (Data Declaration Language) declares the […]
AI and Databases
Although it is probably true to say that “AI is reshaping the landscape of database technology“, it’s […]
Transactions
By now, pretty much everyone has heard the stories about the first computers. They were huge, cost […]
Rounding Numbers
I would hope by now everybody has figured out when you see a price like $39.99 that […]
Uniqueness, Keys, and Identity
If you’ve ever had a traditional logic course, you’ll have run into “The Law of Identity” as […]
Bad Data and Dirty Databases
Many years ago, my wife and I wrote an article for Datamation, a major trade publication at […]
LIKE Constraints
In this article, I will cover a bit about the LIKE operator, including how it works, and […]
The CHECK() Constraint
One of the many ways a relational table differs from the file structures used by pre-relational storage […]
SQL Logic
In this article, I will discuss the history and thinking behind several types of logic that are […]