Voice of the DBA

One of my colleagues wrote a great post about DBAs and developers , about how a DBA's pushback on bad code isn't to be difficult, it's because they can see the future. I never thought of myself as a modern-day Nostradamus , predicting the future of system performance. Apparently I had another title besides DBA. Working under pressure and with short deadlines often leads to short cuts. I've made th...

There was a post on X recently from a founder in the EU about an engineer using Claude and ChatGPT to build a feature. I am not sure how true these posts are or if they are designed to just create engagement, but it's still an interesting topic. The part that makes me think is that (supposedly) the engineer was fired because their "data" (code) was sent to American servers. The code was then delet...

It's always interesting to me when I give product feedback to engineers at Redgate on their demos. Quite often they've built a feature that uses AdventureWorks or Pagila (PostgreSQL) or some other well known schema to evaluate how their particular thing works with a database. I try to remind them that many databases aren't well modeled and designed with consistent naming. I ran across a Daily WTF...

Recently, I saw a graph about making decisions that showed the impact of both reversibility and consequences. Here is an example of such a graph and how one might approach decisions. If things are easily reversible or have a low consequence, we tend to make a decision and move on. Or we are willing to make a decision. One of the examples of such a decision was choosing what to wear out to dinner....

Years ago I was giving a talk on software development and asked the audience how long it takes to review a PR that has 10 lines changed. Answers were in the minutes to tens of minutes range. I then asked how long it takes to review a PR that has 1,000 lines changed. Some people said hours, but a few people said seconds. I've often taken the latter, pessimistic view. Not because I don't think engin...

SQL Server Central has been a great success over the last 25 years. We've helped a lot of people improve their careers with the Microsoft Data Platform, primarily SQL Server, but we've published articles on other aspects of databases, including other platforms. I wrote a bit about the history of the site last month, with a few stories in various pieces. We even got Brian Knight to contribute a pie...

One of the challenges of AI-assisted coding agents is that they tend to produce A LOT of code. Even in refactoring or migration changes, the AIs can work quickly and generate such a volume of code that the process starts to become overwhelming. For pull requests, for CI/CD build systems, and certainly for human reviewers, they can be overwhelmed. This can become a real problem with OSS projects, w...

We do a lot of research at Redgate Software , often contacting customers or Ambassadors and asking questions, getting feedback, listening to their challenges or criticisms. We take that information and it helps guide us to build the tools that help you in your job. Recently I watched a call with a customer that uses our famous Toolbelt in their job and has for years. In this case, the call was abo...

I wrote a blog about sitting at LHR recently and watching planes take off. That's been a fun thing for me to do when I'm stuck at the airport. I can see a plane roll down the runway every 35-45s during busy times. This time I was sitting by a window in the hotel, working and watching. There was a moment when I realized no planes were taking off. I looked and saw a vehicle rolling down the runway,...

When I was young and needed to learn about something, I had to go to a library or a bookstore to get information. I often started by looking through an encyclopedia. I had to wander between entries to learn more about the topic I was researching. A few lucky friends had their own copy of an encyclopedia, which was nice since we could research at home. At some point these collections of information...

A few weeks ago I was in Bletchley Park , at the facility where the Allies decoded and broke many of the German Nazi messages in World War II. It's quite a facility and museum, and I hope to go back. I was distracted that day and didn't get a lot of time to enjoy the exhibits and really learn more about what happened there. I was there for our Redgate 2026 Company Kickoff, and as a part of that, t...

Recently I was working with a customer that is trying to smooth out their database development process. They noted that a lot of changes tend to take a significant amount of time and impact their availability. They came to Redgate to see if Flyway might be a way to improve the effectiveness of their internal groups that build, deploy, and manage their database software. We can help, but often when...

I saw an interesting LinkedIn post on Kyler Murray and how he goes about approaching the game of American football. I don't know if this meme is true, but certainly, his efforts to prepare have been a reported issue during Murray's career. The post actually deals with sales and analyzing the reasons for deal success or failure, something I've been able to witness at Redgate the last few years. It'...

We had a Simple Talks podcast recently where we discussed roll forward vs roll back. You can watch the episode and listen to our thoughts, but one interesting place was when we talked about deployments. Grant mentioned that he deployed from version control/source control at a previous employer. I asked him whether he did that for every system. His response: "Well, ..." He admitted that most, but n...

I have the opportunity to work with a variety of customers on their database systems, often with the focus on how they can build and deploy changes to their databases. Often, they have a process around how and when they make changes. Some have maintenance windows, though often these are approved times for changes rather than a true window during which a system is shut down. I ran into a customer r...

I remember listening to an interview with Rick Reilly in the mid 2000s. He was the back page columnist for Sports Illustrated for years as well as a writer in various pieces. He talked about how he would lay on the couch in his office sometimes, trying to think of what to write. His kids would come in looking for attention, but couldn't understand that Dad was "working". I had been writing the edi...

The Advocates at Redgate Software had an interesting discussion about deployments in databases and how you go forward or back from the point at which you discover a problem. You can watch the episode , but a few things occurred to me while we were having our discussion. The first thing is we all agree data makes things hard. A database is a stateful object, and dealing with stateful objects is har...

Many of us know that testing our code is important. The adoption of unit testing by many software application developers as a normal course of business has dramatically improved the quality of applications. Mobile software, especially, has benefited from the requirement for most software to include, and constantly run, a suite of unit tests. For database software, I find relatively few organizatio...

Why do we reboot machines when something goes wrong? I'm sure all have done it, and I would guess quite a few of you have found situations where this seems to fix issues, but there isn't an underlying root cause that you can pinpoint.  This is a fairly accepted way of dealing with issues, but have you thought about why this is a way to solve some problems? The main thing that a reboot does is retu...

This is part of a few memories from the founders of SQL Server Central, celebrating 25 years of operation this month. We did photoshoots at Redgate many years ago. We had a bunch of props, including some phrases written down. We could create our own, but my handwriting is atrocious (likely why I never became an architect), but I ended up with this one: Read the rest of Doing Good at SQL Server Cen...

Many of you reading this have a number of years working with technology. You might have 1 year or 20 years, but you've likely grown and learned along the way. Some of you may also know someone who has several years of seniority in a position but not that many years of experience. In this case, a person might have been working at this job for 5 years, but they really have one year of experience tha...

This is part of a few memories from the founders of SQL Server Central, celebrating 25 years of operation this month. When we started SQL Server Central, our goal was to build a great resource that helped other people advance in their careers and also made some money. Our decisions in building the site were based around the digital world and treating the community as we would want to be treated. O...

I tend to be fairly careful with data, especially data on this site. When we started the site, we were worried about potential issues and worked hard to ensure we kept our systems safe and limited the attack surface area for personal information. We also declined the various offers we had to sell our list of subscribers to marketing firms. We know that some places add value for marketing, but some...