loader from loading.io

A Great Use for AI

Voice of the DBA

Release Date: 09/16/2021

Complex Searching show art Complex Searching

Voice of the DBA

Searching for data in our systems is sometimes hard. If you've ever needed to generically search a lot of text, it's not easy to write code to do this in an efficient manner. It's even harder if you try to embed this in an application. If you get into full-text searching, likely you would look beyond SQL Server as the built in full-text indexing and searching isn't great. What if you had to search in more complex data? Imagine that your users were looking for words in audio files, or they wanted to find images that matched other images. Those are even more complex searches, and I expect that...

info_outline
Going Cloud Native show art Going Cloud Native

Voice of the DBA

I am constantly surprised at the migration of workloads to the cloud. It seems that many of the customers and clients that I speak with are moving some of their assets to the cloud. Some are moving the majority of their systems, and they are pushing to do this sooner than later, including database assets. I ran across that noted that while many companies love the on-demand provisioning of cloud resources, they don't always get improvement in their software performance. In fact, quite a few might experience worse performance, though often not horribly worse. Instead, what they often get is a...

info_outline
Growing and Keeping Up show art Growing and Keeping Up

Voice of the DBA

I keep busy. My wife and I tend to be type-A people, tackling lots of things and keeping very busy. We work hard, and often, a lot. Our spare time in the winter is spent with second jobs, coaching youth volleyball. My kids think that we can be a little unbalanced at times, not taking enough time off or getting away from work. I agree. They are better balanced in life than my wife and I. The thing I tell me self is that keeping busy and being driven has helped me have a great life and a great career. It's also created lots of stress, perhaps more than I should have. I thought about this balance...

info_outline
The Last SQL Server Service Pack show art The Last SQL Server Service Pack

Voice of the DBA

I wrote a few years ago, thinking that SQL Server 2016 SP2 might end all large updates. At the time, Microsoft was moving to a Cumulative Update process, with the aim of releasing small patches for each version every couple of months. They've done a good job of that, and SQL Server 2017 now has with more coming. With little fanfare, we got recently, with a long list of fixes.  Even Pedro Lopes notes for any version. That means I expect that in the next few years, I'll start to encounter people working with technology who have no idea what a service pack is or what those are used for....

info_outline
Choosing State Over Migrations show art Choosing State Over Migrations

Voice of the DBA

I ran across an article about . While I think that this article is a bit slanted because the author is building a tool, it does present some good reasons why people worry about migration-based approaches. This article also references . Everything we do in relational databases, and in some other platforms like Snowflake, is a migration script. If you run SQL Compare and get the differences, you are generating a migration script. It might contain lots of changes, but it's still a migration script. I wish I could write CREATE OR ALTER TABLE scripts, but that's not a part of the SQL specification...

info_outline
Location Data is Not Anonymous show art Location Data is Not Anonymous

Voice of the DBA

We are truly in the era of big brother and 1984, where any of us can be tracked if we use a mobile device. That's a scary thought and one that many people might not like. There are plenty of people in management that want to increase revenue or profits from the use of data, even if we might think their decisions are unethical or immoral. When there's money to be made, often they ignore other issues. There was that noted various public data, some sold by brokers, was used to track location and usage of a device by de-anonymizing aggregated data. The post ends with these statements: Read the...

info_outline
Do You Have a Talent Gap? show art Do You Have a Talent Gap?

Voice of the DBA

I have seen articles over the years that talk about a talent gap in companies, similar to . For a long time early in my career, it seemed anyone that went through a boot camp could get a job, and we had lots of unqualified people earning lots of money. I know I've run into my share of paper-CNE's, paper-MCSE's, and more in my career that took advantage of that talent gap. Over time it seemed that many companies stopped relying on certifications in hiring, but this didn't seem to help us find more qualified workers. We either were short of staff or still had plenty of people that couldn't do...

info_outline
Incident Review show art Incident Review

Voice of the DBA

Something will always go wrong with our software systems. Issues might happen regularly or rarely, but something is going to go wrong at some point and a client will complain. Often the way we handle these situations determines whether our customers continue to do business with us or look for an alternative. In my career, I've been a part of many incidents, lots of which were service outages for customers. I've attended some incidents as a technical person working to diagnose the issue. In other incidents, I've been a developer that has to fix code. During many, my role was as a manager trying...

info_outline
Making Software Decisions show art Making Software Decisions

Voice of the DBA

I work for a company that builds software. At Redgate, we are constantly debating what to build and how, and more importantly, how to structure something that is easy for our customers to use. There's a lot that goes into the process of building software, way more than I thought was important a decade ago. Today, even when I don't like the decision or the final result in a product, I know our process often produces good results. Recently Netflix started for their software. It's interesting in that they note that of all the ways they can make decisions, most of these involve few people. This...

info_outline
Thank a Mentor show art Thank a Mentor

Voice of the DBA

"The delicate balance of mentoring someone is not creating them in your own image, but giving them the opportunity to create themselves.” — Steven Spielberg I saw with the request that people tag a mentor that had helped them. Since then, a few people have posted their thanks to someone, and I've been tagged a few times. I'm honored that people think I've helped them somehow, as that's been a portion of my career for the last twenty years. I make an effort to do help others have a great career and become better at their jobs. Read the rest of

info_outline
 
More Episodes

In the last couple of years there has been a tremendous amount of hype for machine learning and artificial intelligence as a way to improve the world. Plenty of companies have tried to implement ML/AI to generate more revenue or improve their products, often with mixed success. However, I recently saw a place where I think AI might shine.

I've never owned a Roomba or any robot vacuum, and I've never encountered a poopocalypse scenario. I do have a cat that is an avid hunter, so I certainly could envision something similar with a carcass in the house, but apparently, some owners of these vacuums have had a very messy experience when they pet has an accident and the robot vacuum attempts to clean the floor.

Read the rest of A Great Use for AI