loader from loading.io

An Amazing Summit

Voice of the DBA

Release Date: 12/02/2022

Creating Candidate Interest show art Creating Candidate Interest

Voice of the DBA

It can be hard to find candidates for positions these days. I know there are a lot of people looking for jobs, but are they the ones you want? Are they a good fit for your team? Those are hard questions to answer when culling through resumes, conducting phone screens, and sitting in interview rooms asking questions from a template. What can be even harder is to compare different candidates when multiple people may interact with the candidates. Even if you do all the work, you're busy. Can you make good comparisons of different individuals that you've spoken to across a few weeks, in between...

info_outline
Using AI for Security show art Using AI for Security

Voice of the DBA

AI (Artificial Intelligence) systems and technology has been all over our industry for the past year or so, ever since ChatGPT released the initial public version in late 2022. It seems that there is a lot of hype around the possibilities, with plenty of excitement and skepticism, depending on who is talking about the tech. However, there do seem to be some places where the technology is working well, and security is one of them. There is , which seemed to have run rampant a few years ago. It's still around, though it seems fewer exploits are being publicized. That might be because systems are...

info_outline
The Art of the Code Review show art The Art of the Code Review

Voice of the DBA

The inspiration for this was a piece about . Throughout my career, I've seen code reviews grow and change. From formal meetings to automated notifications and asynchronous discussions to complete lip service to the process. I'd like to think that most organizations are beyond the latter and there is some sort of review beyond the developer, but I still see a lack of other eyes looking at code before it's deployed, especially database code. The article above opens with the idea of why we review code. The main reason is to create ownership, or more specifically, shared ownership. I had never...

info_outline
The Dangers of Not Upgrading show art The Dangers of Not Upgrading

Voice of the DBA

About ten years ago my sister-in-law broke the screen on her mobile phone. She'd had an older iPhone and when she went to upgrade, none of the upgrade processes worked because her OS was so far behind that they couldn't transfer her information smoothly. She had been avoiding OS updates because they interrupted her life, but that was now a problem because the world had marched so far beyond her version that there weren't tools, or at least, no one was interested in trying to perform an upgrade across multiple OS versions (I think it was 3 or 5 versions). I ran into this recently with someone...

info_outline
Free SQL Server show art Free SQL Server

Voice of the DBA

No, I don't have a way to license a SQL Server instance for your application for free. Microsoft still charges for production workloads. However, there are several ways that you can do development or testing for free, or at a greatly reduced cost. Bob Ward spent a bit of time researching options and he's written . It's very comprehensive and I know a lot of us are grateful to Bob for summarizing our options. As I work with developers in organizations, there are often questions about the licensing for dev editions. This comes up more with Oracle than other platforms, but SQL Server does get...

info_outline
Visual Design for Safety show art Visual Design for Safety

Voice of the DBA

I drive a Tesla Model Y and love it. They're not for everyone and not for every situation, but I think it's the best car I've owned. My wife feels the same way, and if we had a need for two cars, we'd likely get another one. The car is fun, and I look forward to getting in and moving around town. If you have questions about owning an EV or a Model Y, please feel free to ask. The car isn't perfect, and there are things I wish I could change. There have also been a few recalls on the car, which is interesting for a Tesla. A few of these recalls meant that I got a software update a few days or...

info_outline
Am I Good At My Job? show art Am I Good At My Job?

Voice of the DBA

I was talking with a friend recently about some of their co-workers. In this case, they were complaining that another person couldn't do some tasks that my friend considered relatively easy things. Deal with an unusual restore situation, write some PowerShell to reconfigure servers, build somewhat complex (to them) queries, etc. Things that my friend thinks most database people should be able to do after a year of experience. However, my friend questioned whether they were evaluating co-workers appropriately. How can one tell? I might be able to tell if a coworker is better or worse at a task,...

info_outline
This is Why You Use Git for Scripts show art This is Why You Use Git for Scripts

Voice of the DBA

Git has become a fantastic tool for me, and many other technologists, over the last ten years. It's almost ubiquitous in most of my clients, and so many people are comfortable with it. Many others aren't, which is why I started a (and other Ops people) on my blog. Quite a few people asked me why I recommend git over a file share for storing code that a team of Ops people or DBAs might use. Why isn't a global file share a better choice in an organization? I think I have a few good reasons, but if you disagree, let me know in the discussion for this piece. Read the rest of

info_outline
Un-Stable Teams show art Un-Stable Teams

Voice of the DBA

I've always valued having a team of people I know and can work with. While I haven't had a lot of long-term jobs before Redgate, I have had a few positions that lasted more than a year and appreciated working with the same group for a long time. We might gain or lose a person, but overall, the structure of the team was the same day after day. This was a comfortable atmosphere, and I liked knowing who I was working with each day. At Redgate, we have had some stable teams of people, but in our engineering area, we move teams around. There is each December/January where engineers can choose to...

info_outline
Do You Have a Jeff? show art Do You Have a Jeff?

Voice of the DBA

In the (worth a read), there is a character called Brent, who is to go-to person for everything in IT. I don't know if this character was modeled after , but I always picture him when I re-read the book, and I suspect he was that person in previous positions. I've been that person as well, and it's both exciting, fulfilling, and very stressful. At , that person has been Robert C, who is my go-to person for many questions. In the DBA world, I think of . He's been a prolific and incredible author over the years on many things SQL-related and is a huge proponent of others learning to write...

info_outline
 
More Episodes

 

Read the rest of An Amazing Summit