I just posted on how to use a PowerShell script in a flexible manner to perform different tasks with generative AI locally with Ollama, but I realized I hadn’t gone into just how cool and simple it was to run this on my laptop, along with the beauty of the script output. Pulling from the Demo For the demo scenario, the following exists: A Postgres 17.5 database, source and target for a migration. Four migration scripts requiring code review for the following: Syntax Row Level Security issues inside the database (RLS referenced in the prompt) Missing index options Flyway CLI…
-
-
When working with database migrations, automation is the key to speed and safety. Redgate Flyway already helps us structure and deploy migrations consistently, but what if we could add AI-powered checks directly into our existing pipelines and do so in a safe manner as well? I’ve been promoting this as part of my open-source and Postgres event sessions for the last few weeks and I’d like to discuss it further. Recently Ollama offered the option for a Windows 11 installation. No GPU or tokens required, (although having GPUs won’t hurt) I did timed tests and found it to be a…
-
2024 was a pretty busy year for me. It was one marked with change as I shifted the beginning of the year into my role at Silk as Director of Data and AI. We began focusing heavily on my abilities to navigate the technology landscape and identify what was required as a company at Silk to make the most of it. As I had time, I was heavily involved at DZone writing content on a slew of topics, which I really enjoyed. I think the biggest surprise was that you realize with a small pivot, tech is often handled the…
-
Now that I’ve been at Redgate as the newest Advocate, along with my engineering duties, let’s talk about the annual event so many of us attend each year in the Microsoft data community- PASS Data Community Summit. My schedule is shaping up to be a busy one and I want to make sure that folks know where I’ll be through the week. SQL Saturday Oregon/SW Washington My week starts the weekend before, where I will be doing the keynote at SQL Saturday Oregon/SW Washington. The keynote will be on “Why Can’t AI Do the Dishes Already?” and will follow a…
-
I’ve been getting that question a lot lately. When I left Microsoft 16 months ago, there was more than one betting pool on which cloud I would go to next, knowing my history and short attention span, but maybe I’m softening in my old age. I surprised a few when I went to one of the partners that I’d worked with for almost four years while at Microsoft, Silk and over a period of a few months, became their Director of Data and AI. It was a good opportunity for me, as they understood I needed a lot to keep…