I'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 MoreI recently got into VS Code Dev Containers and Azure Functions, and I love them. Unfortunately, the PowerShell Azure Functions pretty much come out of the box with a high likelihood of throwing Ominsharp exceptions when debugging.
Two of the files the setup process generates,
launch.json
andtasks.json
, use the func …
Read MoreIf you work in an offline environment, you're probably familiar with how painful it can be to install anything, including PowerShell modules like dbatools.
In the past, dbatools had no dependencies, so the installation process was somewhat straightforward — you could even download a zip from our GitHub repo. However, …
Read MoreNote: This blog post is going to borrow a bit from Microsoft's official documentation in "Connect with Azure Data Studio" and from our book, Learn dbatools in a Month of Lunches. It also addresses dbatools 2.0, which is currently in pre-release.
Microsoft recently made some changes to the default encryption …
Read More