A series of episodes that look at databases and the world from a data professional's viewpoint. Written and recorded by Steve Jones, editor of SQLServerCentral and The Voice of the DBA.
Listen to episodes
60 recent
September 10, 2026Episode 892 min
I Don't Want To Do XX
Every job is a job on some days. I've said this to my kids and others I've mentored over the years. I've probably written that here, and I truly believe it. When you work at a job, some days are bad days. There are always days you don't want to do the work. There are also likely some days that you dread starting. Whether you work for someone else or run your own business, there will be times you aren't completely in control of the work and wonder how you ended up in this situation. Even if you're self-employed, you have clients that sometimes dictate your day. Read the rest of I Don't Want To Do XX
September 8, 2026Episode 883 min
The Cost of Multiple Platforms
I ran into an interesting post that noted the modern data platform can have a bunch of different systems underlying it . The example might be that your "software" could use PostgreSQL, MongoDB, Cassandra, Clickhouse, and something NewSQL (Spanner, CockroachDB, etc,). Some of you might think that's not reality, but keep in mind that for a lot of your organizations, the "software" is what the customer uses. I'm sure my bank has multiple systems behind the mobile app I use to pay for things, move money, check balances, etc. I would guess there is some DB/2, SQL Server, and some analytics or No/NewSQL stuff in there. Hidden as different applications that make up the "app", but they are still in there from my perspective as a user of the app. No one intentionally designs software like this, but we still see it. They might not even have 5 or 6 platforms in their organization, but almost none of the customers I work with have less than 3. Somehow, somewhere, someone added a PostgreSQL server to an Oracle/SQL Server environment. MongoDB crept in when someone thought it was a better store than DB/2 or MySQL. An article written about how Facebook or Spotify or some other high tech company used Cassanda or Snowflake inspired a developer to add that to their toolbelt and build it into their application. Read the rest of The Cost of Multiple Platforms
September 3, 2026Episode 873 min
The End of Summer
Growing up, this was the last week of summer for me every year. When I was a child in Virginia Beach, school started the day after Labor Day every year, which is next Monday in the US. This was our last chance to sleep in, enjoy the ocean, and stay out late without commitments. Starting next week we'd be back in school, up early, with homework to do every night. As an adult, the end of summer doesn't really stand out anymore. Corporate changes are usually at the beginning of the year or in July, so it's the end of June or December that are slower times. September is often the beginning of conference season for me, and I've usually been preparing for travel in September, as I am this year. I'll be in San Diego in a little over a week for VS Live (if you want to join me, use the code Jones ). Read the rest of The End of Summer
September 1, 2026Episode 864 min
Measuring Productivity
I've dealt with a lot of customers with who lately are concerned with the ROI of their teams. Certainly they want a good ROI if they purchase software from Redgate, as do we. Our goal has been to be partners with customers and continue to add value to the products they've purchased on a regular basis. We release every week or two, and our Redgate Monitor and Flyway updates reflect this. New functionality, fixes, and previews. I'm proud of the constant updates we deliver, and I know customers get increased value throughout our partnership. Does our software provide a good ROI? I get asked this question by execs regularly, and I often ask them if they feel they get a good ROI from their staff already. Answers are mixed, especially in the database world where it seems the costs and the value delivered from database dev or ops groups can be nebulous. Databases support application software, and if that software doesn't work well because the database deployment scripts weren't correct, weren't tested, or have performance issues, who is at fault? Read the rest of Measuring Productivity
August 30, 2026Episode 853 min
Preserving Data
Most data professionals I know go out of their way to take care of the data entrusted to them. Most people ensure backups are running, lots (hopefully most) test their restores. A few will ensure a good rotation their data offsite. Some of you might have formal rotation schemes, and some might just keep a rolling list of xx backups available. Likely a few of you don't worry about anything other than the last full backup, which is a risker approach than I'd take. Read the rest of Preserving Data
August 27, 2026Episode 843 min
Collecting Data is Hard
Data is the lifeblood of much of the world today. Not necessarily big data, and certainly not perfect data, but organizations, individuals, governments, really everyone is making decisions based on data. You might think it's going to rain, so you cut the grass today, or maybe defer adding fertilizer. Your organization sees demand for a product, so it orders more and produces more. Government is always using data to make decisions. We might not think they make great decisions, but data matters. Recently I was reading a science fiction book ( I, Starship ) about the future, where a person's brain (Henry) becomes uploaded to manage a starship. This ship will travel light years away for 80 years and they need the human crew asleep in hibernation to survive the journey. The interesting thing, to me, was a part in the book where there is a discussion of why Henry was uploaded and why AIs aren't advanced enough to run the starship. There's this quote: "The first generations performed well, but as time went on, we entered a situation where more and more of the data available to train them on was itself machine-generated. So, instead of mimicking high-quality human output, the outputs got more garbled." Read the rest of Collecting Data Is Hard
August 25, 2026Episode 833 min
Admin Rights for Everyone
I was chatting with someone that works at a smaller organization Still a few hundred employees, but the technical teams (dev and ops) were less than 20 in total. They mentioned that everyone had admin rights to the systems as they worked as a team and sometimes developers provided production support. I haven't encountered that in quite some time. Is it still a thing to give a lot of people administrator writes across many systems? I know for many organizations there is concern about developers being able to change things in production, but if you aren't a public company or a regulated one, then Sarbanes-Oxley , HIPAA , PCI-DSS , or other restrictions don't apply. In those cases, if you have a tight team that functions together, would you be worried about this? Read the rest of Admin Rights for Everyone
August 23, 2026Episode 822 min
A Challenge of Our Knowledge
AI is here to stay. It will evolve, it will get better at some things, and we might decide that it's not good for certain tasks. It's a weird, new, different technology that somehow seems magic, extremely intelligent, and at times as dumb as a box of rocks. It can do things that I could never do, or would never do, for myself. Heck, I'm not sure I could or would pay someone to do this by hand . Yet this was less than a minute for a computer system to take this image and transform it into something fun. Christian Buckley wrote an interesting post about AI challenging our identity , which sums up nicely one of the struggles many of us have with AI. Many of us identify with our work. We spend most of our lives for decades toiling away at a craft that we (hopefully) enjoy and in which we have success. We build skills, and we're proud of our accomplishments. Some of us are more proud of our scars. Read the rest of A Challenge of Our Knowledge
August 20, 2026Episode 815 min
An Eventual Consistency Scam
Recently I sold a car. It was an interesting process as I hadn't sold a car to someone I didn't know in a long time. I listed the car in a few places and was surprised by the interest. It was an EV (I guess it still is), and with the rising price of fuel in the US, maybe I shouldn't have been surprised. I arranged a couple of showings, but I had quite a few people offer to buy the car after only seeing a few pictures, asking if I'd take a check. Some of you might be wary at this point, and I was. However, my wife had gotten similar offers from a few people when she was selling a horse. She never did, but we talked about where the scam is if someone sends a check and says they'll wait for the funds to clear. Read the rest of An Eventual Consistency Scam
August 18, 2026Episode 803 min
Never is Not the Policy
Years ago I worked with a few developers and DBAs that were temp-table happy. As in they defaulted to using temp tables everywhere. This was in SQL Server 6.5, and tempdb was an issue with contention, sizing, and performance. I rewrote so many queries to remove temp tables for our clients that I banned them. I told other developers they could never use temp tables in their SQL code. They, of course, would try to submit code with temp tables in our VCS (Visual SourceSafe at the time), but an early, pre-automated CI/CD would notify me and I'd have the developer rewrite their code. There were situations that didn't perform well with a single query, and we did allow some temp tables. The point wasn't the ban them entirely, but stop them from being a crutch for developers or a first choice. I wanted them to think about the problem first and try to solve it with SQL. If performance was an issue, then we'd look at a temp table. Read the rest of Never is Not the Policy
Is this your show?
Claim this listing to keep it up to date, reach guests who want to pitch you, and manage bookings with Guestify.
