loader from loading.io

Acknowledging Success

Voice of the DBA

Release Date: 12/13/2021

The General Database Platform show art The General Database Platform

Voice of the DBA

It's been a decade-plus of the Not-Only-SQL (NoSQL) movement where a large variety of specialized database platforms have been developed and sold. It seems that there are so many different platforms for data stores that you can find one for whatever specialized type of data you are working with. However, is that what people are doing to store data in their applications? I saw this piece on , postulating that a lot of the NoSQL database platforms have added additional capabilities that make them less specialized and more generalized. I've seen some of this, just as many relational platforms...

info_outline
The Future of Certifications show art The Future of Certifications

Voice of the DBA

Hacker News is a forum for experienced developers. While I think plenty of beginners lurk there, the discussions seem to be dominated by those who have worked in the technology or software industries for years. I saw an interesting article that noted and backed up the claim with some search results that show few results for various terms. I think that many experienced people working in technology are wary of certifications. With a little practical experience, one quickly realizes how little certifications actually do to prove you know how to work with a platform, or with code. Most companies...

info_outline
Crazy Interview Questions show art Crazy Interview Questions

Voice of the DBA

Redgate had a discussion recently among our developers about our interview process and questions. There has been a standard question asking candidates about 2D arrays, but as one developer pointed out, we don't use these in our code base. So, why do we ask candidates about this topic? The developers came up with a different question, actually a series of questions that ask about a class and then how to test parts of this class. We mostly work in C# in a DevOps culture, so this seemed like a good idea. They proposed a scenario with a few questions and then asked current developers to solve the...

info_outline
Traveling Observations show art Traveling Observations

Voice of the DBA

I fly regularly. While I only had one trip during 2020 in the most dangerous time of the COVID pandemic, I flew a record number of miles in 2019 and had 10 trips in 2021. As 2022 progresses, I find myself back in the air and on the road, visiting new and familiar places for work and pleasure. I both enjoy the familiarity of known adventures and the excitement of new places. Already this year I have trips in place to three new places I've never visited and I'm hoping to plan more. I usually fly to LAX a couple of times a year. I visit Redgate employees in the area or travel to some event....

info_outline
Project Zero for Better Security show art Project Zero for Better Security

Voice of the DBA

Google started to study zero-day vulnerabilities in systems. They want to improve security and safety, at least from a software and hardware standpoint. Its mission is to make it more difficult to find and exploit issues in software. They published an update recently that showed , at least according to data from the last few years. The metrics show a change in patching from an average of 80 days a few years ago to 52 days in 2021. There were also patches that missed the 90-day deadline, though only one missed the 90-day time and also a 14-day grace period. They are also trying to help with...

info_outline
Testing or Learning show art Testing or Learning

Voice of the DBA

All of us get into challenging situations. This might be a coding problem that we struggle to solve. It might be an argument with a co-worker. It could be feedback from a customer on how we dealt with them or maybe just how our app works. Our responses to a challenge might determine how we view the situation, our future actions, or even just how we react to life in the next few hours. When someone struggles or feels as though they have failed in a situation, they tend to react in one of two ways. They can view the experience as though it were a test and they didn't pass. This is quite common...

info_outline
Gathering Data Through Life show art Gathering Data Through Life

Voice of the DBA

Every once in a while, I find a list of places posted on the Internet with a "how many have you visited?" question attached. This might be US states, countries, cities, or even attractions. I love traveling with my wife and having new experiences, and as we've gotten older, we value the experiences more than any physical things. It's something that I hope we've passed on to our children as well. My wife and I have been very blessed and have been able to travel a bit in life, though not as much as we would have liked with three children and a ranch of horses. We made it a goal about 6 years ago...

info_outline
Migrating a Large Database show art Migrating a Large Database

Voice of the DBA

I have upgraded lots of SQL Servers from one version to the next, and for the most part, the process has been smooth. That's not always the case, and there have been some long nights where the Operations staff had to scramble to fix things, script out old logins, call Microsoft support, and perform various data exports and imports to get a new instance running. I've been a part of quite a few of those teams. Most of my upgrades were with relatively small databases, at least small for that time period. However, I have upgraded a few "large" databases in the past. We had a 400GB database on SQL...

info_outline
The Craziness of Code show art The Craziness of Code

Voice of the DBA

Every once in a while I find a fun post that makes fun of programming. I think because the author is struggling with some piece of code, they write about the craziness of software development, often with an analogy that compares building something in the real world to how software programs get written. , with a bridge construction analogy, that degenerates into a rant on the disparate ways in which different programmers work together and how the entire world of the Internet is held together in a constant patch-fix loop. I do think that most large software applications have a decent amount of...

info_outline
Scripting Makes Mistakes Easier Than Ever show art Scripting Makes Mistakes Easier Than Ever

Voice of the DBA

A number of you likely use Atlassian products like Jira, Confluence, Opsgenie, or something else. You might have been affected by a large outage they had (, , ) recently which lasted at least 9 days. I don't know if all customers have their data back and are working, but this was a surprisingly poorly handled incident according to a number of reports from customers. There's a that you might want to read. The bottom line in this issue is that Atlassian looked to deactivate a legacy product with a script, but they apparently didn't communicate well among their teams. The script ended up using...

info_outline
 
More Episodes

Today is the Redgate annual award event, and I'm honored to be hosting again. I've been asked a few times, and I used to look forward to the gathering in Cambridge followed by our annual Christmas party. Last year this was virtual, as it is this year, so I'm hosting again from my home office. Not what I had hoped would happen, but I'll have some fun. Last year I had a number of shirt changes between my parts, and I may do that again.

I know there are often annual sales awards in many companies, usually with some vacation or prize being given out, but not a lot outside of the sales department. In most of my jobs, we've usually had some sort of holiday party, but nothing else for most employees.

Read the rest of Acknowledging Success