• Today’s AI

    “This is the worst version of the car you’ll own.” That was a quote from the delivery manager when my wife and I picked up our Lucid Gravity. He said that since the car is very software-oriented and gets regular over-the-air updates, the car keeps improving. The car I bought is the worst version because it keeps getting better. His experience over the last few years with the company has shown that the changes made in software…


  • The SUM of Nothing: #SQLNewBlogger

    I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that Look Too Easy. I decided to give you a few thoughts from me on the SUM one. Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. The Sum of Nothing I am guessing more people working with SQL know that if you have a NULL in your data and try to…


  • Architecting Zero Downtime Deployments–Day of Data Boston

    Here are the resources for my talk at Day of Data Boston. Slides – ArchitectingZeroDowntime.pptx Slides also at: https://dayofdata.org/2026-10-03-dayofdata1150/#schedule Code: https://github.com/way0utwest/ZeroDowntime Book: Refactoring Databases Some interesting questions. I’ll write more, but a couple of quick answers as I breakfast at Logan. How do I handle expanding a column? Making it larger? This is platform and change dependent. For example, if you are expanding a varchar() column from 10 to 20, this is usually a metadata operation in…


  • Development Is Fun

    I was listening to The Pragmatic Engineer interview Casey Muratori about high-performance code, which I found really interesting. I’m actually considering going through his Performance Aware Programming series and (re)learning some assembly. I never thought I’d even consider doing that. I learned Assembly in high school and university, and I didn’t enjoy it. Casey is a game programmer, and there was a question in the interview about how he uses AI tools in his work. “We are…


  • The Book of Redgate:A Prehistory

    I’ve covered the values in a number of previous posts on the Book of Redgate. Those values came from our founders, Simon Galbraith and Neil Davidson. I am lucky enough, and honored to have known these gentlemen for many years and had the chance to sit and chat with them throughout my time at Redgate. Simon and I still get together periodically even today after 25 years. In the Book of Redgate, there’s a section about prehistory.…