Voice of the DBA
I had a request from a customer recently who asked if we could give them a report of their database server instances and include CPU usage. This request was filtered through an account executive, so something was lost in translation, but I was confused and asked for clarification, as asking for CPU usage is kind of like asking how fast you were traveling in your car. There needs to be more context. If someone asked you for a report of CPU usage for a database, what would you expect? How would you report this? I'm sure the person asking might make a difference. A fellow DBA, your DBA manager,...
info_outlineVoice of the DBA
What if I got hit by a bus? I'm sure many of you have heard some variation of this, or used it, or maybe your boss told you to be ready in case you (or someone more important) gets hit by that vehicle. This is the "," and it's often used in reference to preparation for unforeseen events. Not literally someone getting hit by a bus, but perhaps a sudden accident that takes someone away from work (hopefully not fatal). Perhaps it's someone leaving for a new job. Maybe it's retirement, which is something my boss and I at chat about periodically. Don't worry, I'm not planning on retiring anytime...
info_outlineVoice of the DBA
The AI boom is still growing like crazy. Many organizations are trying to learn how they can use AI to improve operations and become more efficient, at a reasonable cost. Plenty of companies are spending crazy amounts of AI tokens, sometimes blowing their yearly budgets in months and not necessarily receiving substantial value back. Some companies are trying to train AIs to understand their operations and perhaps reduce their other costs, primarily labor. Still others are tip-toeing in the waters of AI LLM use and conducting smaller experiments, with limited access to AI technology. Meta has...
info_outlineVoice of the DBA
I recently recorded a session with and a Redgate Flyway Solution Engineer. It was a fun session using GitHub and AI, and better managing the code in an automated fashion to bring some determinism to AI coding. I'm hoping it will be released soon, and you can see a vision of how you can better wrangle your AI agents and reduce risk and increase reliability. When we started our discussion, Ken noted that he is an AI forward deployed engineer for GitHub. His job is to work with teams in how to use agentic coding. When we were first prepping, I had never heard the Forward Deployed Engineer title,...
info_outlineVoice of the DBA
Oh, how I wish I could make you learn. How I wish I could coach, guide, inspire, or even bribe you to learn more about your job, or things related to your job, or even things in life. I wish all of you would improve your skills, but more, I wish you would want to improve your skills. I find lots of people who do want to get better, but far too often, people aren't trying to improve because they want to coast along at their jobs. I get it. You're stressed and busy at work, though hopefully not too often. You have challenges at home, kids to raise, parents getting older, financial stresses,...
info_outlineVoice of the DBA
I saw this article and thought, surely there's nothing I could use in here: . Quite often, when these articles appear, they are very high-level and contrived examples of things that I rarely find myself doing. So I clicked the link. Read the rest of
info_outlineVoice of the DBA
Tomorrow is the celebration. I've been hearing about this on the radio for weeks, and it's struck me that I've been alive and lucky enough to experience both the 200th (1976) and the 250th (2026) milestones. I'm not sure either is more amazing than any other 4th of July, but the round numbers stand out. Read the rest of .
info_outlineVoice of the DBA
Satya Nadella talked about cognitive coverage in the age of AI, about being able to understand and manage AI agents to get work done as a software developer. covers the future of work and comfort in this new age. This reminds me of a book that recommended, . I love the book, but it's slow reading as I constantly stop and think. Work is changing; it's becoming unbundled and re-bundled in different ways, and many of us will have to learn to work in new ways. Not all of us, but many of us. Some might see their day-to-day efforts change little; some will not recognize their job a year from...
info_outlineVoice of the DBA
Is it worth continuing to run SQL Server when PostgreSQL licensing is zero? Rebecca Lewis has a that looks at some of the pros and cons of paying for SQL Server instead of moving to PostgreSQL. She starts with some of the things PostgreSQL does well, of which I think the Extensibility is really cool. SQL Server has some of this in CLR and the non-SQL language support, but those seem kludgy and complex to me. They aren't really integrated into the SQL Server platform. They're good, but I do wish vendors or the community could add some extensions in a way PostgreSQL does. Of course, I also...
info_outlineVoice of the DBA
I had a very interesting conversation recently with a longtime DBA who was worried about using AI in their database work. The Redgate State of the Database Landscape 2026 report showed that the vast majority of you (99%) are getting value from AI, so clearly it's being used. However, this individual was concerned that using AI for tasks would not engage their brain, and they might lose some of their SQL skills. And they want to use their brain at work. Read the rest of
info_outlineMost of us that work with SQL Server likely use either the Windows authentication or a user name and password when connecting to an instance in SSMS or ADS. It's how we've operated for years, and likely will for some time to come. If you connect to Azure cloud resources, perhaps you use some multi-factor authentication (MFA), but that's a minority of us.
If this article is a picture of the real world, far too few people are using authentication beyond passwords for many services. While plenty are using fingerprints, patterns, or face recognition on a mobile device, that's usually the extent to which they actually go beyond a password. I've actually started to see people using PINs on laptops instead of a password, which feels like a step backward.
Read the rest of Getting Beyond Passwords