Tag: AI

  • The Era of Cloned Humans

    AI-technologies are evolving at an alarming rate. The ability of LLMs to produce drafts, review work, even write some code continues to improve to the point where junior level workers are in danger of having less opportunity than in the past.

    Perhaps even more alarming is the ability of AI technologies to mimic what they find in the real world, which can include voices. As with any technology created to make the world better, criminals will find a way to use it for nefarious purposes. This article notes that the FBI has warned families to have a secret word or phrase, as criminals are using AI to clone the voice of a family member asking for financial help.

    Can you imagine getting a call from your spouse, parents, or children, saying that they’re in trouble and need some money right away? With AI tech, the voice could even respond to your questions, mimic anxiety or distress, cry, or who knows what.

    Last year Microsoft announced a text to speech technology that can closely simulate a person’s voice with just 3 seconds of audio. I’m sure that capability has improved in a year and soon we may not be able to trust the voices we hear. We certainly can’t trust the photographs we see, something that we enjoy when we see artists photoshop images for fun, but when we look at an image  in the news, we want it to be real, but we can’t trust that an organization hasn’t manipulated a photo. When anyone could simulate another’s voice, things can go wrong quickly.

    I assume the ability to fake video in real time is coming soon. With enough hardware and some imagery, I would guess AI models will be able to hold a Facetime-type call as a human, fooling most people that might not know the person extremely well. At some point, since all our images and video are digital anyway, I assume that without some security measure, the tech could likely fool almost everyone.

    Even as I write this I doubt how well the quality is, but I’m sure that it will continue to improve to the point where we might be loathe to trust remote interactions. This has the potential to be a security nightmare for some people, and I worry about the scams and losses criminals will inflict upon the unsuspecting.

    This is one type of technology whose negatives will far outweigh the positives.

    Steve Jones

    Listen to the podcast at Libsyn, Spotify, or iTunes.

    Note, podcasts are only available for a limited time online.

  • The AI Budget Assistant

    I saw this article about AI helping IT leaders plan their budgets, and I had visions of certain departments getting cut, especially data-related ones. My concern is that a lot of what a DBA does can be acting as insurance or supporting others and not necessarily doing things which are easily visible or that might show up in reports, praise in Slack/Teams, or in other places an AI might be prompted to look. If an IT leader has to decide what’s important for the AI to look at, is data included?

    Of course, it’s entirely possible the AI would look at all the performance problems and want to spend more budget on the data side. Fingers crossed for that interpretation.

    The idea of an AI looking at a large amount of current data in various spreadsheets, reports, goals, requirements, usage, and more to synthesize a budget makes sense. This is the type of thing many AI-type technologies do well, finding patterns and summarizing the data in a way that assists a human in producing a final report of where to spend money.

    Just like any report produced by a human, I would hope that someone reviews the results and verifies the analysis makes sense. However, in reality, I suspect a lot of human reports are passed along as-is, with only a cursory glance. The world of AI might make this worse as we can produce larger and more detailed reports.

    The funny thing might be that whoever has to approve the budget might let their GenAI model summarize the budget for accuracy. In that case, do we need humans involved? I can see some managers trying to reduce the staff that might have internal knowledge and replacing them with GenAIs. Will we just have AIs producing things other AIs read and summarize?

    Most of us know that garbage in/garbage out is a constant problem in the world of data and reports. Judging data quality and ensuring the accurate (and complete) data is fed into any system is something that humans need to be a part of. An AI model might assist, but humans have context and knowledge that can be hard to craft into a prompt. After all, this might be the training data for your model, and I’m not sure general models will learn well without handholding from humans, especially in specialized areas like budgets.

    I’ve had to build budgets, and while I don’t think it’s hard, it’s time-consuming. There is a lot of drudgery, and I think an AI can help here. However, I’d want to audit and check the data and ensure that my helper is summarizing the data in a way that makes sense to me. Even then, what I’d most like to do is let the AI give me a few suggestions of future costs and let me fine-tune those before I present them to anyone else. After all, if we make large errors, I suspect I’ll feel the pain of failure more than my AI assistant.

    Steve Jones

    Listen to the podcast at Libsyn, Spotify, or iTunes.

    Note, podcasts are only available for a limited time online.

  • Another AI Faux Pax

    I was experimenting with a local model (article) and as a part of this, I pulled down a web interface for my model in a container. I ran it and had it in the background. I’ve randomly been asking questions as I need to look up things. I’m mostly curious how well it works.

    This week I asked about CDC and got and interesting response.

    This is part of a series of experiments with AI systems.

    Updating a CDC Schema

    I asked this question of my local mistral model: How do I alter a table in SQL SErver that is being tracked by CDC to add a new column?

    That might not be the best way to phrase things, but I was on a call with a customer who was going to enable CDC and wanted to discuss how to manage this with schema changes. I’m not a CDC expert, so I was checking some documentation while chatting and decided to put this query in.

    I got these results,

    2025-01_0153

    I thought I’d missed something, as I had never heard of sp_cdc_refresh_schema. Sure enough, I didn’t see it on MS Docs.

    2025-01_0155

    If I were trying to do this (pretend I’m a copy/paste DBA), I would see this:

    2025-01_0156

    So, the next step is to call the AI on this. It finds that it hallucinated and give me other ideas.

    2025-01_0158

    It gets worse. Now I create a proc and insert into the system tables, which isn’t recommended.

    2025-01_0160

    This won’t work either, but I can see people trying this.

    First, if you get advice from the Internet, please always, always use a sandbox to test (what I also recommended to the customer), and second, treat any AI response like it came from a teenager.

  • Setting up a Local LLM

    I wanted to experiment a bit with an LLM and training it, so I decided to try a few things. I looked at a few tutorials (see the references below) and then finally got this working. This post distills down what I got to work.

    Getting Started

    I like containers, and rather than install something on my machine, I decided to get docker images for ollama. I ran this to get started:

    docker pull ollama/ollama

    I ran the Docker container with this command:

    docker run -d -v ollama:/root/.ollama -p 11434:11434 --name ollama ollama/ollama

    From there, I pulled a few models into the container with these commands:

    docker exec -it ollama ollama pull mistral

    I then ran this to start the model and interact with it.

    docker exec -it ollama ollama run mistral

    Here are a first few things I typed in to test the model.

    2025-01_0111

    From here, I exited and then ran this to start the model in detached mode.

    docker exec -d ollama ollama run mistral

    From there, more experiments, but that’s in another article.

    References

    Here are some places and tutorials I looked at: