Data Control Language (aka Security)
Like ancient Gaul, SQL is divided into three sub- languages. The DDL (Data Declaration Language) declares the […]
Database Theory
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 […]