Audit and update this blog post. The blog covers various topics including dbatools, PowerShell, SQL Server, and technology.
CONTEXT:
IMPORTANT: THIS TASK REQUIRES NUANCE
You are updating Hugo markdown blog posts to fix title capitalization and migrate WordPress images to the correct Hugo directory structure.
Given a migrated blog post file:
dbatools has 3,500+ Pester tests spread across 707 test files. For years, we put off migrating from Pester v4 to v5 because the sheer volume felt impossible. The thought of manually converting hundreds of test files, each with their own quirks, edge cases, and complex SQL Server integration scenarios, was overwhelming.
But avoiding it wasn't making it go away. Pester v4 was deprecated, and we knew we'd have to migrate eventually. The question wasn't if, but when and how.
PackageManagement\Install-Package : Authenticode issuer 'CN=dbatools, O=dbatools,
L=Vienna, S=Virginia, C=US' of the new module 'dbatools' with version '2.5.5' from
root certificate authority 'CN=Microsoft Identity Verification Root Certificate
Authority 2020, O=Microsoft Corporation, C=US' is not matching with the authenticode
issuer 'CN=dbatools, O=dbatools, L=Vienna, S=Virginia, C=US' of the previously-installed
| function Import-Dbatools { | |
| <# | |
| .SYNOPSIS | |
| Imports the dbatools module after trusting its code signing certificate. | |
| .DESCRIPTION | |
| This function checks if the dbatools module's signing certificate is trusted. | |
| If not, it adds the certificate to the current user's Trusted Publishers store, | |
| then imports the module. This is particularly useful when working with | |
| AllSigned execution policies and the new Azure Trusted Signing certificate. |
This is step by step guide how to use new .NET namespace Microsoft.Data.SqlClient with Powershell. I've tested connection string using SQL login and Windows login. This could not fit you all but might provide you some ideas.
Fresh Windows Server 2016 in my case Azure VM.
| # train_grpo.py | |
| import re | |
| import torch | |
| from datasets import load_dataset, Dataset | |
| from transformers import AutoTokenizer, AutoModelForCausalLM | |
| from peft import LoraConfig | |
| from trl import GRPOConfig, GRPOTrainer | |
| # Load and prep dataset |
| { | |
| "New Developments": { | |
| "keywords": { | |
| "indicted party boss": { | |
| "description": "Current trending topic", | |
| "weight": 3, | |
| "timestamp": "2025-01-29T00:05:14.7211272+00:00" | |
| }, | |
| "urgent health care": { | |
| "description": "Current trending topic", |
| ############# Install PSOpenAI and set your API key ############# | |
| Install-Module PSOpenAI | |
| Import-Module PSOpenAI # only when it's first installed | |
| $env:OPENAI_API_KEY = 'sk-xxxxxxxxxxxxxxxxxxxxxx' | |
| ############# Here's some markdown that'd be extracted from a PDF, however you want ############# | |
| $markdown = "# Dog Shot Record | |
| 2309 Kelley Road, Gulfport, MS, 39501 | |
| **CLINIC NAME** | |
| Phone: 123-1234567 - Email: info@petshopname.com |
| { | |
| "name": "pet", | |
| "strict": true, | |
| "schema": { | |
| "type": "object", | |
| "properties": { | |
| "pet_name": { | |
| "type": "string", | |
| "description": "What is the name of the pet?" | |
| }, |