For the longest time, I thought AI would never apply to me as a developer. I don't excel at math, and AI is pretty much all math. But then I realized that I don't need to understand the math to use AI effectively - there's plenty of applied intelligence that's directly relevant to what I do every day with PowerShell. …
Read MoreRecently, I was trying to figure out if the content of two headlines overlapped. I needed a script that would answer if Pacific Palisades is part of Los Angeles, but I couldn't use regex because there's no pattern that matches "Pacific Palisades is part of Los Angeles." There's also no simple string …
Read MoreIf you're like me and have a hard time wrapping your mind around how AI works, Microsoft's AI Toolkit for Visual Studio Code makes it unusually approachable. Recent versions work on Windows, Linux AND macOS too! I didn't expect LLM engines to be "just" binary files, but the VS Code extension helped me better …
Read MoreI'm currently working on the final chapter of our book! It's the DevOps chapter, which for a while, I thought would probably be about LLMOps or GenAIOps. But I haven't found a way to apply those to me as a DevOps person. After reading Chapter 2 which covers Code Assistants, my coauthor and BFF Brandon suggested we show …
Read MoreIncredible! I just used PowerShell and OpenAI to import text from a PDF right into SQL Server 🚀 AI's usefulness is often debated but this is such a great use-case. I also see it being useful for automatically adding SharePoint document metadata and cleaning dirty data. Using a new feature from OpenAI called …
Read MoreI don't know if you can tell but I'm having a ton of fun lately with AI. I prefer AI coding over manual coding because I can skip all the tedium and just communicate in my first language. Advanced things too, in languages I don't know well like TypeScript. I remember seeing a YouTube headline about a guy who built a …
Read MoreSince I can't find it anywhere else on the web, here's how you detect ARM64 xplat. 1# Determine OS and Architecture 2$osPlatform = [System.Runtime.InteropServices.RuntimeInformation]::OSDescription 3$architecture = [System.Runtime.InteropServices.RuntimeInformation]::OSArchitecture 4 5# Adjust the platform and …
Read Morefinetuna, the PowerShell module for fine-tuning OpenAI models, has been updated to version 2.0. This release now depends on PSOpenAI, supports Azure OpenAI services, and provides a demo notebook along with some sample data. If you're new to finetuna, it makes OpenAI model fine-tuning in PowerShell simpler. It does file …
Read MoreTLDR: This error is expected and the change is legitimate. To update, switch to Install-Module, then slap on the -SkipPublisherCheck and -Force parameters and continue your update. 1Install-Module dbatools -Force -SkipPublisherCheck I've always been very proud that dbatools is Code Signed like a "real" …
Read MoreIf you're wondering about the uptick in SQL Server-related posts, I recently changed jobs and went back to being a SQL Server DBA. For a few years there, I switched to security engineering; I figured I'd try something new and welcomed no longer being an admin. It was nice enough and I got to do a ton of PowerShell, but …
Read More