loader from loading.io

Are Cubes Dead?

Voice of the DBA

Release Date: 06/05/2022

Reducing Debt and Increasing Security show art Reducing Debt and Increasing Security

Voice of the DBA

Many of us know that reducing financial debt in our lives leads to a bit more security in our minds. We are better able to cope with unexpected expenses when we have the ability to get credit or pay for something in cash. If you've ever had a major house repair, car calamity, or (hopefully not) medical issue, you know what I mean. At least in the US. That last one is less of an issue in many other countries. We know that our code has technical debt, and often we fight a battle with project managers and business people over whether we should spend time paying down that technical debt or...

info_outline
DevOps is Mostly About People show art DevOps is Mostly About People

Voice of the DBA

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

info_outline
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
 
More Episodes

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 technology may be best in the current situation.

In their career, this person has extensive SQL Server Analysis Services experience and has built many cubes over the years that clients access with any number of front-end tools. I would guess that cube design and construction have made this person a lot of money over the years.

Read the rest of Are Cubes Dead?