Chrissy LeMaire potatoqualitee

The Problem We Avoided for Years

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.

Why August 2025 Was Different

Fix: dbatools Update-Module Install-Module SkipPublisherCheck Error (August 2025)

The Error You're Seeing

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

Microsoft.Data.SqlClient with PowerShell

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.

Scenario

Fresh Windows Server 2016 in my case Azure VM.

Install .NET CORE 3.0 SDK it must be SDK

To use the DCLM-7B model on Jan.ai, follow these steps:

Install the Required Tools: Ensure you have the necessary tools installed. You might need packages like transformers and open_lm. You can install them using:
```
pip install git+https://github.com/mlfoundations/open_lm.git transformers
```
Download the Model: Integrate the DCLM-7B model from Hugging Face with Jan.ai:

	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.

	# 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: [email protected]

	{
	"name": "pet",
	"strict": true,
	"schema": {
	"type": "object",
	"properties": {
	"pet_name": {
	"type": "string",
	"description": "What is the name of the pet?"
	},

	/! Asciidoctor default stylesheet \| MIT License \| https://asciidoctor.org /
	/* Uncomment the following line when using as a custom stylesheet */

	@import "https://fonts.googleapis.com/css?family=Open+Sans:300,300italic,400,400italic,600,600italic%7CNoto+Serif:400,400italic,700,700italic%7CDroid+Sans+Mono:400,700";

	html {
	font-family: sans-serif;
	-webkit-text-size-adjust: 100%
	}