Tag: AI

  • Day of Data Baton Rouge Slides and Code

    Thanks to everyone for attending my talk today at Day of data Baton Rouge 2026 (formerly SQL Saturday Baton Rouge).

    The slides are here: Building an API with DAB – Baton Rouge

    The repo for the code and demos is here: DAB-Experiments

    Use the Getting Started folder for the setup and demos as batch files. This is for SQL Server with a user set as JoeUser. Change this in the .env file if you want to alter this. I use Northwind, with a few additions in the .sql files.

    Apologies, it’s not completely organized as I am still working on the flow and structure. feel free to reach out with questions.

  • A Security and AI Fail

    The AI boom is still growing like crazy. Many organizations are trying to learn how they can use AI to improve operations and become more efficient at a reasonable cost. Plenty of companies are spending crazy amounts of AI tokens, sometimes blowing their yearly budgets in months and not necessarily receiving substantial value back. Some companies are trying to train AIs to understand their operations and perhaps reduce their other costs, primarily labor. Still others are tiptoeing in the waters of AI LLM use and conducting smaller experiments, with limited access to AI technology.

    Meta has been a company at the forefront of trying to train AI based on the work employees already perform. There has been plenty of concern that their efforts are designed to lower headcount and replace humans with AI agents. That might or might not work, though I don’t expect a lot of organizations to do this. It’s likely harder than any of the hype suggests, and most organizations have much more complex types of operations than Meta.

    However, in collecting this data, Meta has had other issues. Notably, they have had security problems with all the data they are trying to collect. Some of this data was exposed and they have paused the data collection for now. They were trying to move fast, likely cutting corners or not thinking things completely through. They created these issues. Hackers are constantly looking for holes and the quicker anyone moves to change their software and processes, the more likely that security holes slip by.

    Plus, data governance and protection is hard. Most developers really don’t think through data protection and security well. They’re focused on software and assume the data store (RDBMS, NoSQL, data lake, etc.) is handled by someone else.

    Data is hard. Especially at scale.

    While I’m sure most companies aren’t looking to track employees’ every move (which is a big uplift), they will be trying to move data around and use it for AI purposes. With RAG, with model training, with who knows how, but they are just as likely to cause a security incident if they are not careful.

    Think data governance and data security early. Develop patterns with DBAs and InfoSec alongside software engineers to ensure that as you stand up new agents, systems, and data stores, you aren’t asking for trouble. Re-using existing data is fine, but if you assume that your development team automatically knows about data security, you’re going to have issues. They likely don’t, and if you (or they) think they do, make them prove it.

    AI is amazing, but it’s also easy to mess up the data part of this. Everyone I deal with at Redgate Software is concerned about data governance, and more so all the time. For good reason. Meta made the headlines, but a lot of us aren’t better at securing our systems. We just aren’t as much of a media target.

    Steve Jones

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

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

  • Learn about Modern Microsoft Apps in San Diego

    I wrote about learning today for the editorial: I Can’t Make You Learn. I sure hope you want to learn. It’s been great for my career and it will help yours.

    Join me this September in San Diego (register). I used to live there (Carlsbad) and it’s a beautiful, wonderful part of California to visit. VS Live comes to San Diego, and I’m honored to be speaking this year.

    2026-07_0297

    Visual Studio Live! (VSLive!) San Diego 2026 is at the Bahia Resort Hotel, September 14–18, 2026 in San Diego, CA. It’s five days of immersive developer training right on Mission Bay.

    I think actually worked as a waiter for a wedding in this hotel. If not this one, then one of the others right there on Mission Bay. It’s a great place to stay and I’m looking forward to going back.

    Whether you’re building modern apps on the Microsoft stack (.NET, ASP.NET Core, C#, Blazor, .NET MAUI) or focused on cloud and AI (Azure, GitHub Copilot, AI-powered development, Kubernetes, modern data platforms), this is real-world instruction, hands-on labs, and direct access to expert speakers, Microsoft engineers, and MVPs. Learn more: vslive.com/sandiego

    I’ll be discussing local LLM models, which I think are important for the future. You might not want an LLM on your laptop (maybe a MLM or SLM), but your org might want local models in its data center. I’ll also be discussing the Data API builder, which is a great piece of tech that makes your development against a database much easier, whether you write the code or an AI agent helps.

    Save $500 off standard pricing with my exclusive code JONES. Be sure to register by July 17th.

    Register with my code here: https://na.eventscloud.com/ereg/newreg.php?eventid=865669&discountcode=JONES

  • A Quick Second Opinion

    I saw this article and thought, surely there’s nothing I could use in here: 10 Best AI Prompts for Everyday Tasks. Quite often, when these articles appear, they are very high-level and contrived examples of things that I rarely find myself doing.

    So I clicked the link.

    For most of the prompts, I didn’t think these were the types of things that I do often, nor were the prompts useful. I’m rarely looking for AI to draft emails or perform some of the simple creative things. I’m not sure these are big burdens on time for others, but perhaps I’m wrong. I know many people struggle to build plans or rewrite things, but I do those often and have gotten good at them. I tried using an LLM, but it wasn’t helpful. I do sometime ask Claude to turn things into checklists because I’m being lazy, but getting the things organized is usually the hard part. Pasting them into Word/Powerpoint and changing the bullet format is easy.

    If anyone finds value in these items, and you should try them, that’s great. I find an LLM to be a great quick assistant that can do something for me while I move on to another task. If you struggle to get drafts started, or you need a second opinion and don’t want to call/slack/message/text/etc. a friend, use an LLM. I don’t know using an LLM like this provides an ROI, but it definitely prevents your blocker from interrupting others and forcing them to context-switch to respond to you.

    I found another article on prompts for professionals, which has other prompts that might help you get that second opinion. Perhaps you can use these in technical ways, asking for an evaluation of your algorithmic approach or your message to co-workers. If you find them valuable, or you try them in a situation, let me know. Leave a comment. This AI stuff is new, and we can help each other learn.

    If nothing else, experimenting with an LLM will teach you about communication and how clear and direct you are being with your assistant. Do a poor job and the LLM often won’t quite give you the results you want. Get something back that you can use? Examine how well you communicated to the assistant. Many of us can improve here, and learning to be clear and concise with an LLM will also aid you in those communications you send to other humans.

    Steve Jones

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

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