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_outline
50 Years of Microsoft
Voice of the DBA
I get the email periodically and I always find it interesting to read. Like Bill Gates or not, he is a very smart individual and has thoughtful things to say. Even when I don't always agree with him, I enjoy hearing his view and have enjoyed seeing him deliver presentations. In fact, one of my career highlights was at , held at the MS campus. Bill Gates was speaking to employees that day and we were allowed to watch the Q&A from the balcony. Later, I saw him start to leave and stop by a sign. He asked someone about SQL Saturday. When they explained the idea for free conferences, he said...
info_outline
The Return to the Office Debate
Voice of the DBA
At the end of last year, I ran into a friend I hadn't seen in a long time. We were chatting and this person mentioned that they were looking for a new job. They had been laid off and needed something. This is someone with a lot of experience and skill, so I wasn't worried for their career or future. At the time, they mentioned they had gotten an introduction and interest from Amazon, but they weren't interested in a position because of the that Amazon was implementing. I was recently chatting with another friend at a different company. This person manages a tech team, and was looking to hire...
info_outline
Staying Employed
Voice of the DBA
The revolution with GenAI has been quite the ride since 2023 and quite a few people have been concerned that their employment status might be in jeopardy. I can certainly understand that, especially in light of the tight budgets, , and . There was with a few tips on how to stay employed. While tech workers weren't mentioned as being vulnerable, repetitive data-heavy jobs, such as data entry clerks, telemarketers, and cashiers were. That last one is interesting. Lots of companies have tried to use automated checkout stations, but this hasn't necessarily eliminated cashiers. Maybe there are...
info_outlineWe collect a lot of data in our databases. Not as much in bytes as a lot of the video/audio/TikTok/Instagram sites, but still enough that many of us are constantly adding storage to our systems. All this data is not only a challenge to manage, but it also means that we are regularly dealing with query tuning issues. Better code, indexes, and more become regular challenges with large volumes of data.
I am a big fan of trying to reduce the data you manage where possible. Archive, delete, remove older data, do something. This not only makes your systems easier to manage and improves performance, but it reduces your risk. Any PII data you have that might store is an ongoing risk in the event of a data breach. I don't pretend this is easy to do in any way, but it's a good idea.
Read the rest of The Challenge of Deleting Data