loader from loading.io

Long Term Storage

Voice of the DBA

Release Date: 06/23/2022

Look Beyond What You See show art Look Beyond What You See

Voice of the DBA

One of the sales managers at Redgate Software posted about how he came to work at Redgate Software. It's an interesting story, and while I don't work in sales or have the same origin story, I don't know that I could have seen the place I'm in now early in my career. When I saw the video, it made me think of this movie scene, where Rafiki asks us to . I think this is a hard thing for many of us, especially when many of us have been leaning on our skills in the past. What we know and what we are good at doing has led us to this place. Picking a new direction, or thinking in a new way might be...

info_outline
What Do We Want to See in SQL Server? show art What Do We Want to See in SQL Server?

Voice of the DBA

I like the feedback system that Microsoft built for SQL Server. This used to be the Connect system, but all the bug reports and feature requests are now at . That's the place where you can send notes to Microsoft or vote on those that others have submitted. In case you are wondering if this makes a difference, it does. Years ago, there pushback for Service Packs from Microsoft, and after a lot of lobbying from myself and others, and a number of votes, Microsoft released more Service Packs for a few versions. They've also made a few other changes in the product, or fixed bugs when enough people...

info_outline
Digging into an AI Algorithm show art Digging into an AI Algorithm

Voice of the DBA

One of the more successful uses of AI (artificial intelligence) has been in the medical field. It seems that there is a tremendous amount of data, high variability in some aspects of the target of the data (the patient), and a need to constantly review very tedious volumes of data. A place where AI might, and has, made a difference to help humans, not replace them. There's that dives into a bit of how a medical algorithm works for detecting sepsis. As you scroll, the article tries to explain in layman's terms what the AI system(s) are doing. It goes through the necessity of regular data,...

info_outline
How Often Do You Update During Issues? show art How Often Do You Update During Issues?

Voice of the DBA

I use to store podcast files. They've been a reliable service for me for years. Once in awhile uploads are slow, but things seem to work. The other day I went to upload a file and got a status message that there was an issue with database maintenance. When I looked at the , I saw a few updates. This was for a platform issue, and I saw this set of updates. I have the timing with my own comment: Read the rest of

info_outline
Being Reasonable show art Being Reasonable

Voice of the DBA

The last two years have changed the way many of us work in technology. The pandemic allowed many of us to work remotely, a challenge that many companies are struggling with. Or perhaps, management is struggling with and employees appreciate. In any case, no matter what your situation, the way we work has changed. The change wasn't easy at times, and even though many people appreciated the extra time in their day from not commuting to work, they often had other challenges. Co-existing with others in a residence, finding a place to work that allows concentration, and even learning how to...

info_outline
The Azure Carrot show art The Azure Carrot

Voice of the DBA

Microsoft wants more people to move their database workloads to Azure. They are constantly adding new features, capabilities, even tools to help people move databases to some part of Azure. It's working well, as shows tremendous growth in Azure revenue. We don't know precisely how SQL Server or Azure SQL databases impact this, but I certainly see more and more customers moving relational workloads to the cloud. Some to Azure, some to other providers. In an effort to entice people, Microsoft has a promotion that they were running in March, which was and save with free extended security...

info_outline
AI Ethics show art AI Ethics

Voice of the DBA

I found to be an interesting look at how we might add ethics to AI systems in one area. As the article points out, "... today there is no broadly accepted AI ethics framework, or means to enforce it. Clearly, ethical AI is a broad topic ...". Glad someone is thinking, or many people are, but sad that we aren't really moving in a direction that creates a better system for us humans to work under, or be bound by. To be fair, I do think this is a very difficult topic and hard for any large group of people to agree on what should be done. Read the rest of

info_outline
Share Your Mistakes show art Share Your Mistakes

Voice of the DBA

I wrote the other day about . We know mistakes are going to happen, so we ought to accept them. Even stupid ones. I make them at times, my wife does, my kid does, so I have been working to not get upset and emotional about them. Instead, hold someone accountable, let them fix things, and try to do better in the future. It's what I'd want, and what I am trying to do with my family, friends, kids I coach, and others. Many of us share knowledge and information. One of the reasons I love events like SQL Saturday is that others share their knowledge. I especially appreciate is when someone shares a...

info_outline
A Culture That Allows Mistakes show art A Culture That Allows Mistakes

Voice of the DBA

Building a culture that promotes teamwork, efficiency, retention, and other positive attributes can be challenging. While many organizations want accountability and responsibility, it is easy for managers to tip over into a blame-and-chastise pattern. When someone makes a mistake and a deadline is missed or a client gets upset, how do you respond? I saw about how to build a culture that allows mistakes and forgives them. We all make mistakes, and we should strive to correct them while working to avoid repeating the same mistake. But we will make mistakes again in the future, so how do we deal...

info_outline
The Limited Cloud show art The Limited Cloud

Voice of the DBA

The cloud is truly someone else's computer, and it's not limitless. From the perspective of the individual, it might seem like you could scale infinitely if you need more boxes, storage, or networking, but ultimately the cloud vendor (Azure, AWS, GCP, etc.) needs to have spare machines around. Many of them do, and that works well at the scales in which they operate. To a point. Read the rest of

info_outline
 
More Episodes

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 Azure or AWS, but I assume some sort of combination of technologies are in use. I also know I don't trust them completely to be readily available and recoverable after a few years.

Read the rest of Long Term Storage