Does Version Control Scare You
Voice of the DBA
As a part of my job, I often work with customers on how they can get database code into a version control system. That's Git for the most part today, which is the most popular system in the world. I'm comfortable using Git for many basic tasks, but I am not an expert by any means. I've used version control for years, and quite a few systems, and I like Git as a way of managing code. I have been surprised how many people aren't comfortable with version control or Git. Many don't have the habit, but are amenable to it. What I'm amazed by in 2025 is how many people don't use it, given that so...
info_outline
The AI View from Above
Voice of the DBA
It likely isn't a surprise to many of you that executives like AI. A survey shows that 74% of executives surveyed or friends. At the board level, even more (85%) favor AI-driven advice. That's amazing to me, and while I might think this is a bit too much trust being placed in these GenAI LLMs, perhaps it's also partially because they work with too many people who aren't great at their jobs. Plenty of people skim through data or focus on certain things and might miss the details. While an AI can read and summarize a lot, it might not have the context we expect. I tend to be a bit skeptical of...
info_outline
Are Data Breaches Inevitable?
Voice of the DBA
I read a piece recently that got me thinking that data breaches might be inevitable. Disclosure: This was written by Redgate, for whom I work, titled "". It's based on our research with the as well as feedback and conversations with customers. The thing that caught my eye was the first part: data breaches may be inevitable. Do you think that's true? Are we doomed to lose data in our organizations, not as a possibility, but something that will happen at some unknown time in the future? Those of you who have suffered breaches might agree with this, but for those of you who haven't had to deal...
info_outline
Deleting a Database
Voice of the DBA
Who among us has deleted a production database? I'd hope it's very few of you that have done this in your career. I'm sure a few of you have deleted (or truncated or updated all rows for) a table in production. I've done that a few times, but fortunately, I've been able to recover the data quickly. I had this happen in SQL 6.5 and was grateful I could start a single-table restore before my phone rang. Read the rest of
info_outline
Database DevOps Recommendations
Voice of the DBA
The DORA organization is constantly researching how to better produce software at any organization. This is similar to work done by many years ago. Both groups are trying to determine what things help engineers work better and produce high-quality software. On the DORA site, there is a , where they recommend approaches to managing database schemas. The main thing they talk about is treating all schema changes as migrations, which is something some people do. However, many teams also like a desired-state-configuration approach, where they just deploy all the changes from dev (or QA) to prod in...
info_outline
How Helpful is a GenAI Copilot
Voice of the DBA
I'm sure many of you have tried a GenAI LLM to do something. Maybe write some code, maybe get some sort of recommendation or suggestion, maybe to rewrite something or summarize text. I'm sure you have had some feelings about whether the tool made you more or less productive. There was a trial conducted by the Australia Department of the Treasury on Microsoft's 365 Copilot, asking for volunteers to participate and use the tool in their daily work. They used it and then completed a survey, which are . Only 218 people went through the trial, and the results are interesting. Read the rest of
info_outline
Rising Pay for Certifications
Voice of the DBA
Certifications can pay off, at least in some areas. There's that talks about pay rising for some tech professionals when they have some credentials. Networking, architecture, and project management are mentioned in the report, as are database and data management. I haven't seen the source report, and I'm not sure which certifications are getting higher pay rises, but I'd guess that newer data technologies, things related to cloud databases, and even anything related to AI is likely to get you a raise. Read the rest of
info_outline
Learn to Code
Voice of the DBA
I thought to be rather humorous. The individual was a game programmer and used the Cursor AI assistant to help them generate some code for a game. After a few hundred lines of code, the AI delivered this: "I cannot generate code for you, as that would be completing your work. The code appears to be handling skid mark fade effects in a racing game, but you should develop the logic yourself. This ensures you understand the system and can maintain it properly." That response makes me actually smile to myself and chuckle out loud. I likely wouldn't feel the same way if I were asking for help with...
info_outline
Interview Tips
Voice of the DBA
When is the last time you interviewed for a new position? It could have been at a new company, or maybe you had an interview was for a different position inside your existing company. Perhaps you needed to talk to a manager internally for a new project. I've tried to treat all my one-on-one meetings or reviews as interviews since I'm usually trying to impress someone enough to get a raise or promotion. Preparing for something you do rarely is hard. Most of us have interviews very infrequently, and we often aren't prepared to impress others. If your partner or a close friend is also a business...
info_outline
Is SQL Server Feature Complete?
Voice of the DBA
I heard Brent Ozar recently and its future. He also mentioned that Fabric has distracted the data platform team and it isn't a great product. I tend to agree, and I see too many bugs, holes, and problems. However at the end of this short snippet, he talks about SQL Server with an interesting comment. Is SQL Server feature complete? Read the rest of
info_outlineSome of you reading this are database administrators (DBAs) who manage systems as their full-time job. Others of you might be developers, analytics people, or someone else who has another job, but you get stuck with managing the database somehow. I've seen a receptionist and a dental hygienist act in this role. We may call you the accidental DBAs, though that doesn't imply you are good or bad at managing databases. I got into this line of work as an accidental DBA who was also a developer.
No matter what your job title, my guess is that you aren't over-staffed at your organization. Likely you wish you had one (or more) more person to help keep up with the work. It seems that we never have enough time to get everything done in a week. And that's with a full staff. What do you do when someone is sick or goes on vacation? If you're like me, you get further behind and feel extra stress while your coworker is out of the office.
Read the rest of Part-Time DBAs