loader from loading.io

Crazy Interview Questions

Voice of the DBA

Release Date: 05/08/2022

Be Smart show art Be Smart

Voice of the DBA

An engineer at Google recently . Great headlines, and whether true or not, this might bring some notoriety to the engineer.. It certainly did, and it also resulted in . It's entirely possible this person might be fired. Perhaps I'm cynical, but I think the more talented he is, the more likely he keeps his job. Less talented, likely fired. This might not be fair, but I am a realist. The more value someone brings, the more tolerance for missteps. I give a talk on branding, and one of the things I do before giving you practical tips is to remind you to be cautious. A brand can be a very positive...

info_outline
The Useful Cloud Tags show art The Useful Cloud Tags

Voice of the DBA

One of the things I've seen in working with cloud based resources is that you get a lot of them in your account quickly. A database might end up with a server, an IP address, a network, security groups, and more. A few clicks of the mouse in the Azure Portal can create a new Resource Group that doesn't just have the one thing you need, but 3, 4, or more other items. In addition to the quantity, there are also the problems of namespaces in cloud resources. Some of the items you provision are publicly named in a domain, such as database.windows.net. In these cases, the resources need to be...

info_outline
Returning to an Employer show art Returning to an Employer

Voice of the DBA

I've had a number of jobs in my career. In many instances, I left on good terms, and I'd go back to the organization if there was a job that suited me. I'd like to think that many of these organizations would rehire me if I applied, as I did good work and had success. I've always been pleased when someone is disappointed at my resignation. Intel had a large layoff in 2015/2016 where over 13,000 employees were dismissed. The CEO at the time implemented a no re-hire policy, meaning those who were laid off, or I'm guessing those that quit during that time, were not eligible for employment in the...

info_outline
Accounting for Typos show art Accounting for Typos

Voice of the DBA

When I watched Star Trek as a kid, I was amazed by the technology. Talking to the computer, the touch screens, the handheld communicators. We have most of those devices now, without the space travel. Hopefully that will start to change with all the efforts being made by various organizations.   One of the things that always bothered me was the chance for mistakes. A mis-spoken (or mis-heard) command to a computer that didn't verify things as a human might. The chance to hit the wrong part of the screen as the starship moved. It seemed as though soft buttons would have allowed more...

info_outline
Long Term Storage show art Long Term Storage

Voice of the DBA

Data storage has always been a concern for data professionals. Early on in my career, we dealt with large ESDI, IDE, and SCSI drives, all of which would fail unexpectedly in servers. Sometimes after a few years, sometimes after a few weeks. We learned to use RAID and tape backups to ensure that our data was recoverable. In many places tape was the long term storage medium used. These days, I know many people have moved to secondary disk storage of some sort, often rotating data across a few disk types that give you recovery for days, weeks, or longer. I don't know how long term storage work in...

info_outline
Onboarding Remote Employees show art Onboarding Remote Employees

Voice of the DBA

I guess that I was a remote employee that needed to onboard at a new company at one point. When Redgate Software bought SQL Server Central, I lived in Colorado and the company was (mostly) in Cambridge, UK. However, I was hired mostly to continue the same work I did at SQL Server Central, so I didn't really on board with the company. I signed a contract, and set up payroll paperwork, and that was it. I used my same workstation and laptop, albeit with a new account, password, and VPN, but almost everything was the same for me. Over the last two years, we've hired many people at Redgate, with...

info_outline
Better Communication of Information show art Better Communication of Information

Voice of the DBA

Many of us work with data in some way that helps a customer better understand data, use it to make a decision, or support a some conclusion. The way we present data (or help others present data) can impact how well a consumer understands the information represented by the data. There are people whose job it is to design visualizations and ensure the final product communicates well, but often I find a developer or DBA is the person that gets asked for help. What do we recommend when looking at a set of data and deciding how to format it? A few posts I saw recently help with decisions () or...

info_outline
My Incredible Journey With Your Help show art My Incredible Journey With Your Help

Voice of the DBA

At Techorama, I saw a keynote from Derek Martin of Microsoft. The talk was called , and it's worth seeing if you can find it live or recorded. David talks about his growth in life from a young man to a Principal Program Manager at Microsoft, husband, and father of six or seven. All the while dealing with a mental illness and learning to ask for help and to manage his busy life. It's a great talk, though one I only lightly relate to. My life has been mostly easy and wonderful. Not always, but mostly. My problems are often minor ones. As I write this, I had surgery this morning to repair a...

info_outline
Becoming a Better DBA show art Becoming a Better DBA

Voice of the DBA

One of the things that I try to advocate for is that more of you actively manage your careers and find ways to improve your skills. I want you to be more impressive and find an amazing job for you. Not my job, because I have the best job in the world, but I hope you find a job that you love as much as I love mine. It does take effort, work, and focus. It's something else to manage in life. I certainly don't want you to only care about work. After all, we work to live, not live to work. Read the rest of

info_outline
Are Cubes Dead? show art Are Cubes Dead?

Voice of the DBA

I was talking with a friend recently about technology. This individual is a person focused on business intelligence, originally a developer, but now an architect and consultant. They have a fair number of clients and have worked with them to build solutions to assist in analysis and decision-making for all sorts of organizations. This person has primarily worked in the Microsoft stack but has embraced NoSQL, Hadoop, and other technologies. In many ways they view the world as I do, using what works well for a particular situation without prejudice. They want to be effective, using whatever...

info_outline
 
More Episodes

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 questions and give feedback on the language, structure, and difficulty of the problem.

Read the rest of Crazy Interview Questions