Joe Celko in Theory and design Rounding Numbers I would hope by now everybody has figured out when you see a price like $39.99 that it might as well be forty bucks. Dropping... 23 September 2024 12 min read
Joe Celko in Theory and design Uniqueness, Keys, and Identity If you’ve ever had a traditional logic course, you’ll have run into “The Law of Identity” as the founding principle of all Western thought. It... 09 September 2024 16 min read
Joe Celko in Theory and design Bad Data and Dirty Databases Many years ago, my wife and I wrote an article for Datamation, a major trade publication at the time, under the title, “Don’t Warehouse Dirty... 28 August 2024 10 min read
Joe Celko in Theory and design LIKE Constraints In this article, I will cover a bit about the LIKE operator, including how it works, and a bit of history about why it is... 19 August 2024 10 min read
Theory and design Joe Celko in Theory and design The CHECK() Constraint One of the many ways a relational table differs from the file structures used by pre-relational storage systems is that the tables, rows and columns... 20 May 2024 11 min read
Theory and design Joe Celko in Theory and design SQL Logic In this article, I will discuss the history and thinking behind several types of logic that are typically associated with writing relational database code. Because... 29 March 2024 13 min read
Theory and design Joe Celko in Theory and design Department of Redundancy Department Ever wonder all the reasons that we use databases instead of file systems? While we don’t think of it too much anymore, the first reason... 18 March 2024 12 min read
Software Delivery Phil Factor in Software Delivery Database Feature Toggles In software development the concept of feature toggles are used to selectively turn on and off features. They are, for example, used to restrict some... 19 February 2024 15 min read
Theory and design Joe Celko in Theory and design First Normal Form Gets No Respect Dr. Codd first described the relational model in a paper in Communications of the ACM (CACM 13 No 6; June 1970). Some more work followed... 05 October 2023 13 min read