loader from loading.io

Cloud First Software

Voice of the DBA

Release Date: 11/30/2022

Coaching the Digital Transformation show art Coaching the Digital Transformation

Voice of the DBA

One of the challenges for me when working with customers is getting them to think about how to change their software process. Often they want to solve their problems, but no one wants to alter the way they work. Whether that's the protocol for capturing code or managing servers, it seems that changing the way we work is hard for many people. They want everyone else to change. Or they want a magic tool that solves problems without them changing the way they work. Unfortunately, I'm not a magician. Read the rest of

info_outline
Outsourcing Operations show art Outsourcing Operations

Voice of the DBA

When I first started working in technology in the 90s, it was a time of outsourcing lots of work overseas. Many large companies followed the wave of manufacturing in the 70s and 80s by many companies, including lots of semi-conductor manufacturers. I watched as a number of jobs moved overseas, though fortunately not mine. In the early 2000s, I worked at a company as a manager, where I was involved in some of the discussions about outsourcing a lot of our IT operations to another company. It was a scary time for my friends, as the move would have left a lot of them looking for work. The CIO...

info_outline
The Senior Advantage show art The Senior Advantage

Voice of the DBA

The senior advantage means more to me all the time, though often I feel there are more disadvantages to being around longer than advantages. Getting older is hard, especially physically, and I struggle with that. Having more wisdom, more tolerance, and more patience, are good things, but I'm not sure I would consciously make that trade. In a business, senior often equates to more experience and time working on systems. Sometimes it means more skill as well, but usually, the internal knowledge of how our systems work inside of our environment is more valuable, even though it can be hard to get...

info_outline
The Rise of Vector Databases show art The Rise of Vector Databases

Voice of the DBA

I had never heard of a vector database. I assumed this was a specialist type of database used for a particular problem domain, like a streaming database or graph database. There is a need for specialized platforms in certain situations, but I wasn't sure what a vector was. The description I saw for a vector database was that they "... are specifically designed to work with the unique characteristics of vector embeddings. They index data in a way that makes it easy to search and retrieve objects according to their numerical values." That sounds like any database. However, I saw a few more...

info_outline
The Complexity of Metrics show art The Complexity of Metrics

Voice of the DBA

Monitoring your SQL Server instances is important to ensure you can meet your SLAs. Availability, performance, reliability, quality, whatever you care about, it's important that whoever is responsible is looking at how the database is performing. At , we have multiple teams working on to enhance and grow it to meet your needs. A short while ago there was an internal conversation recently about page life expectancy. We've had some customers ask about this and setting alerts to watch this value. Our developers and sales engineers asked for a few thoughts from Grant and others on how to respond....

info_outline
Speakers Are Normal People show art Speakers Are Normal People

Voice of the DBA

The is amazing, at least I think it is. Like many families, it's welcoming, supportive, and comforting. It's also maddening, frustrating, and exacerbating at times. Like most families, or at least the ones I know, it's not perfect, but it's what we have and at the end of the day, most of us get along with each other. It's also an open group of people. In general, we welcome people with open arms and smiles. Those of us that are more visible or prominent are willing to listen to, help, and support anyone. I was overjoyed during the recent PASS Data Community Summit, where I had the chance to...

info_outline
Losing Track of Data show art Losing Track of Data

Voice of the DBA

I saw a few months ago, which talks about engineers at Facebook not knowing where their customers' personal data is stored. The engineers were being questioned in a legal matter, where they were asked to definitively state where all personal PII data for any human was stored by Facebook. Their answer was that they didn't think anyone in the company would be able to answer that question. Facebook has been controversial over the years, and plenty of people dislike the way the company conducts business. I noticed no shortage of data people (and many others) commenting on this situation, saying...

info_outline
The Challenge of Deleting Data show art The Challenge of Deleting Data

Voice of the DBA

We collect a lot of data in our databases. Not as much in bytes as a lot of the video/audio/TikTok/Instagram sites, but still enough that many of us are constantly adding storage to our systems. All this data is not only a challenge to manage, but it also means that we are regularly dealing with query tuning issues. Better code, indexes, and more become regular challenges with large volumes of data. I am a big fan of trying to reduce the data you manage where possible. Archive, delete, remove older data, do something. This not only makes your systems easier to manage and improves performance,...

info_outline
Minimize Typing show art Minimize Typing

Voice of the DBA

It couldn't have happened to a worse set of people, and I'm glad it did, but I'll still take a positive lesson out of this. A and lost control. That's kind of funny, and I'm glad it happened. The less botnets, the better, IMHO. The coding in this software didn't have good error handling, which is a lesson in and of itself. Overall it seems many developers do a good job of error handling, but I still encounter more pieces of software that allow problematic input than I'd like. While we don't have great error handling in T-SQL, you can make some checks, and you should. Read the rest of

info_outline
Knowing Your Technologies show art Knowing Your Technologies

Voice of the DBA

A while back I ran across a blog post that talks about . There are certainly some similarities and some differences, as well as an overlap in the places where you might choose to use each of these technologies. Both might be useful as a way to recover from a bad code deployment, but both aren't necessarily helpful for a DR situation where the primary server has a catastrophic hardware failure. It's often the case that we learn only a bit about some of the technologies in SQL Server. That's understandable as the platform has grown very complex, encompassing a vast array of technologies and...

info_outline
 
More Episodes

Watching the evolution of SQL Server and the Azure SQL Database (ASD) variant has been interesting across the last decade. For a long time, ASD felt crippled compared to the on-premises product. The last few years, however, it seems that ASD is getting features first, which then slip into a release that I can download and run locally. It's a cloud-first database now, even though there isn't parity with both products.

In my career, I've worked with a number of platforms in production environments. One of those is Db2, though that's often felt like a legacy platform. I've rarely seen users starting new projects on Db2, though they might add some new databases, especially on AS/400, mainframe, or Linux platforms. I never thought Db2 was less capable than other choices, but I just don't see it used very often.

Read the rest of Cloud First Software