loader from loading.io

DevOps is Mostly About People

Voice of the DBA

Release Date: 08/11/2022

The Value of Seniority show art The Value of Seniority

Voice of the DBA

There was . It's written from the perspective of someone that gets a new co-worker, but the co-worker is from the future. In fact, it's the future you. The post is actually titled senior engineers are living in the future. We (hopefully) are more capable and impressive over time. I would hope most of us are learning more each day and our work reflects that. The code you write today should be better than what you wrote last month or last year. The choices you make, the bugs you solve, the experience you bring to work often does reflect your seniority. Not always, but often. Read the rest of

info_outline
The Growth of IQP show art The Growth of IQP

Voice of the DBA

When Microsoft started to talk about Intelligent Query Processing (IQP) before SQL Server 2017, I wasn't sure what to think. There was , and only 5 were highlighted (you can see that in the article linked). That felt like something, but barely something. Over time, as we've gone through SQL Server 2019 and now 2022, the diagram now looks more filled in. In fact, now there are a lot of things filled in. When I think about new features of SQL Server, I don't often spend a lot of time on the IQP stuff. First, I don't have to live with people yelling at me every day about slow performance. If I...

info_outline
Cloud Databases show art Cloud Databases

Voice of the DBA

Most of us are used to a database that lives on a server somewhere. It might be in our data center or a VM that exists somewhere, but it's really an on-premises type of infrastructure. Even if the VM is in AWS or Azure, this is a single system on a server that we control. We can add HA capabilities to this system, but the model is the same as if the database were on our development workstation. Note: this doesn't matter if this is an RDBMS like SQL Server or or a NoSQL type system, such as or . Read the rest of

info_outline
The Communication Channels at Work show art The Communication Channels at Work

Voice of the DBA

Recently a friend started a new job that didn't have Slack used as a communication vehicle. The new employer was considering Teams, but most of the communication among employees was done through email or a live meeting. At Redgate, we use Slack extensively. I also use Teams for some work with Microsoft, and in general, I find I prefer Slack. That might be because I don't spend enough time in Teams, but regardless, I find myself preferring email for discussions with MS employees over Teams. That's my preference, but really, what I value is the instantaneous, yet async, nature of using messaging...

info_outline
Custom SQL Server on RDS show art Custom SQL Server on RDS

Voice of the DBA

One of the challenges in moving to the cloud is achieving a similar level of performance to what you would get with dedicated hardware on-premises. The cloud is someone else's computer, and you are limited to the choices that the vendors allow you to rent. In many cases, you might even share the physical hardware resources with other customers, though many cloud providers have started to allow dedicated hardware reservations in the last few years. One of the challenges of choosing a PaaS cloud database platform is that there are often restrictions that differ from a similar platform...

info_outline
Paying It Forward show art Paying It Forward

Voice of the DBA

A big part of SQL Server Central has been members of the community answering questions for others. We have an amazing community and over the years, it's been helpful to so many people. I often get the thanks, but really have been those that have helped many people. There are too many to list, but gilamonster, Jeff Moden, lynn-pettis, lowell, and more have been tremendous assets to our community. Part of the inspiration for StackOverflow years ago was SQL Server Central and the popularity of people helping others. The main thing their founders didn't like from us (and other sites) was the need...

info_outline
To Which Experts Should You Listen? show art To Which Experts Should You Listen?

Voice of the DBA

When I was getting my career going in Denver, Microsoft used to host lunch sessions every few weeks in their office. There were some Microsoft employees presenting and some community members. I learned a lot from both groups. At local user groups, more often than not, a community speaker was present, but there were plenty of people that worked for different vendor companies that delivered talks. I saw many of these people are knowledgeable in their area, and they taught me things I used in my job. At some point, it started to seem that presenters that worked for companies weren't experts, and...

info_outline
The Challenge of Early Tech Decisions show art The Challenge of Early Tech Decisions

Voice of the DBA

When we design software or databases, we have to make decisions right now. If you work in as many environments as I have, this means I'm often picking a tool, platform, version, technology, or something else without a complete set of information. In some cases, I'm actually writing code (SQL or C#/Java/etc.) without completely knowing the business problem I'm solving. I do know what someone described, but as many of us find out, those descriptions often prove to be lacking. Over time, we refine the code with feedback from users, which is why DevOps has become so popular. We write the best code...

info_outline
Fixing Impostor Syndrome show art Fixing Impostor Syndrome

Voice of the DBA

I think that most of us feel like an impostor at some time in our lives.  We will get asked to do something we've never done, with others expressing confidence in us. We may tackle the task, or we may not. We may succeed or we may not In any of those cases, we may still feel like an impostor, someone that isn't really qualified to do this thing. Many of us continue to feel this way in our careers, suffering from . While I know that I'm good at my job, good at working with SQL Server and teaching others to do so, I still suffer from impostor syndrome at times. There are periods where my...

info_outline
Developer Optimism show art Developer Optimism

Voice of the DBA

Developers, in general, are very optimistic about the code they write. This is likely one cause of their estimates of the time required being low, as well as the various bugs that slip through because of corner cases that appear for the problem being solved. Often developers think they've considered the various ways this code ought to work and covered all the possibilities. Usually we find they've not thought about the problem from other perspectives and need to adjust their code. They often also feel that their code is superior to others, and that they can examine a problem in a new way. One...

info_outline
 
More Episodes

I was giving a talk on DevOps recently and one of the questions from a person in the audience was how to get others to buy in. This person also had complaints that "DevOps" wouldn't work because their boss wasn't interested.

I think these are great examples of things that many developers and managers don't think about when they look to embrace DevOps. While there is no shortage of technical articles and videos on how to introduce automation or deliver features in a new way, what gets lost is the need for cultural change.

Read the rest of DevOps is Mostly About People