Klaas 🇪🇺
banner
klaasv.bsky.social
Klaas 🇪🇺
@klaasv.bsky.social
PowerDBA
Sql Server + PowerShell => dbatools
Yes, Excel too!
Azure because I have to.
Ukulele and tin whistle, but never at the same time.

Once a war chief, then healer to kings and heroes, now guardian of all that is secret.
Reposted by Klaas 🇪🇺
New blog post: SQL Server Diagnostic Information Queries for November 2025

glennsqlperformance.com/2025/11/03/s...

#SQLServer #SQLServer2025
November 3, 2025 at 9:42 PM
Reposted by Klaas 🇪🇺
💡 Converting 3500+ Pester tests from v4 to v5 using AI and why v6 will be easy
👨‍🏫 @funbucket.dev - Creator, dbatools.io
🗓️ 14 Oct | #PSConfEU MiniCon
👉 Free ticket: synedgy.com/psconfeu-minicon
#PowerShell #automation #Pester
September 17, 2025 at 3:45 PM
Reposted by Klaas 🇪🇺
EightKB Resources! (update with correct link
GitHub - github.com/eightkb/2025...
YouTube - eightkb.online/streaming
Web - eightkb.online
Bluesky - @eightkb.online
Email - info@eightkb.online
SQL Community Slack - #EightKB
Buy T-shirts and support www.bonfire.com/store/eightkb
GitHub - eightkb/2025-August: Resources for the sessions at the 2025 edition of EightKB
Resources for the sessions at the 2025 edition of EightKB - eightkb/2025-August
github.com
August 21, 2025 at 2:47 PM
Reposted by Klaas 🇪🇺
MiniCon is back!

Join the PSConfEU community on 14 October 2025.
Secure your free ticket 👉

🎟️ ti.to/synedgy/psconfeu-mini...

#DevOps #PSConfEU #MiniCon2025 #Automation #PowerShell #TechLeaders #DevOpsEngineers #SRE #SysAdminTools
August 20, 2025 at 3:45 PM
Reposted by Klaas 🇪🇺
SEVEN MILLION+ downloads on the PowerShell Gallery! Thanks to everyone who helped make this happen 🤗
August 8, 2025 at 10:39 AM
Reposted by Klaas 🇪🇺
Not up for dealing with daily cert rotation? You can set your execution policy to Bypass or Unrestricted.

If this sounds concerning to you, the post below should provide you with reassurance. Also, most if not all of us on the dev team set our Execution Policies to Bypass or Unrestricted if we can.
EXPECTED ERROR: Update-Module dbatools Authenticode Issue for 2.5.5 · Issue #9748 · dataplat/dbatools
TLDR: dbatools is moving to Azure Trusted Signing, which means Microsoft backs our reputation and dbatools won't trigger as many antivirus false positives. Users upgrading from older signed version...
github.com
August 7, 2025 at 10:34 AM
Reposted by Klaas 🇪🇺
🎯 Want smarter #PowerShell scripts?
At #PSConfEU 2025, @trackd.x64.se showed how to:
🔹 Validate inputs
🔹 Transform values
🔹 Add autocompletion
Perfect parameters = cleaner code + better UX.
🎟️ Grab your ticket for #PSConfEU2026psconf.eu
#DevOps #Automation
- YouTube
Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.
youtu.be
July 15, 2025 at 3:00 PM
Reposted by Klaas 🇪🇺
⚡ Your PowerShell scripts feel slow? Profiler spots the bottlenecks — fast & simple.
Jakub Jareš showed how it works at #PSConfEU 2025.
🎟️ Early bird 2026 tickets now live → psconf.eu
#PowerShell #Profiler #Automation youtu.be/oWBk12UCjCo?si=AYF...
- YouTube
Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.
youtu.be
July 12, 2025 at 8:00 AM
Reposted by Klaas 🇪🇺
If you're a #DBA or #Dev working on #SQLServer or #AzureSQL, I hope you are clued into the fantastic #PowerShell library at DBAtools.io. Michael D'Spain shares an example that we should all implement as a regular drill - automated DB restoration testing!

thwack.solarwinds.com/groups/data-...
July 3, 2025 at 3:12 PM
Reposted by Klaas 🇪🇺
I have a session 🥳 - at the free, online EightKB SQL Server internals conference on August 21 - "Fix your SQL database design with T-SQL static code analysis" - I am sure you will find that and the other awsome sessions useful.

Sign up today at buff.ly/SJ8mwJ2
#sqlserver #eightkb #dotnet #dacfx
EIGHTKB - The SQL Server Internals Conference
A virtual MS Data Platform conference focusing on SQL Server internals.
buff.ly
July 1, 2025 at 8:22 AM
Reposted by Klaas 🇪🇺
I am just a microscopist with social anxiety. But seeing #Covid impact on the brain through the lenses of the microscope has affected me. It’s hard not to feel for the millions sick everywhere.

Below is a 2021 video about our research. Can we please keep talking about #LongCovid?
June 20, 2025 at 4:06 AM
Reposted by Klaas 🇪🇺
Hi #powershell people,
Looking to simplify your module installation life?
Well, look no further, just released the latest version of PSFramework.NuGet:
github.com/PowershellFr...

Now including a oneliner to bootstrap it all:
iwr raw.githubusercontent.com/PowershellFr... | iex
GitHub - PowershellFrameworkCollective/PSFramework.NuGet: A Wrapper around the PowerShellGet modules
A Wrapper around the PowerShellGet modules. Contribute to PowershellFrameworkCollective/PSFramework.NuGet development by creating an account on GitHub.
github.com
May 18, 2025 at 12:13 PM
Reposted by Klaas 🇪🇺
XeSmartTarget 2.0 is out! Finally ported to .NET 9. Enjoy! #sqlserver
github.com/spaghettidba...
Release Release 2.0.0.0 · spaghettidba/XESmartTarget
Porting to .NET core 9
github.com
May 12, 2025 at 8:39 AM
Reposted by Klaas 🇪🇺
Version 1.97 of VS Code is out now with Copilot Next Edit Suggestions, Python no-config debugging, SVG image preview, and more!

Full release notes: https://code.visualstudio.com/updates/v1_97

Here are some of the highlights… 🧵
February 6, 2025 at 5:05 PM
Reposted by Klaas 🇪🇺
Tired of inconsistent, slow, boring GUI?
Looking for a keyboard and console-only experience?

Look at the latest version of the VPAX command line tool (beta/preview/unstable/funny).
It's so cool...
We are so back! 😎

https://github.com/sql-bi/VertiPaq-Analyzer/releases/tag/Dax.Vpax.CLI_1.3.2-beta
December 18, 2024 at 5:02 PM
Reposted by Klaas 🇪🇺
Did you know that cmd.ms has a whole bunch of quick links to get to some of your most common Microsoft 365 pages?

BTW today I just merged new PRs for

✳️ Planner → planner.cmd.ms
✳️ Defender → azdef.cmd.ms

➕ more
December 9, 2024 at 9:40 PM
Reposted by Klaas 🇪🇺
[observation]
Bonus: It allows you to setup alerts on each of the impacted categories.
Plus, 3 of the current Preview Workbooks allow you to:
- Track the reliability of your applications
- Track service retirements
- Identify cost optimization opportunities
#ObservAbility #MondayObs
Introduction to Azure Advisor - Azure Advisor
Learn how to use Azure Advisor to optimize your Azure deployments and get answers to frequently asked questions.
learn.microsoft.com
December 9, 2024 at 8:40 PM
Reposted by Klaas 🇪🇺
#PowerShell ModuleFast 0.5.1 is out!

This fixes a bug with installing modules with legacy version numbers like 3.2.0.0 where nuget drops the trailing zeroes but PS still needs them. Thanks to Raimund Andrée for the contribution and collaboration!
github.com/JustinGrote/...
Release v0.5.1 · JustinGrote/ModuleFast
🐛 Bug Fixes Modules with Trailing Zeroes do not install correctly by @raandree #99 🙋‍♂️🙋‍♀️ New Contributors @raandree made his first contribution with #99! Thank you! Full Changelog: v0.5.0...v0.5.1
github.com
December 7, 2024 at 6:42 PM
Reposted by Klaas 🇪🇺
#Pwsh Tip of the day!

You can use FilterXML to search windows event logs. Here's a function from my PSSysadminToolkit module demonstrating its use. github.com/steviecoaste...

Happy Scripting!
PSSysadminToolkit/Public/Get-UserLogonEvent.ps1 at Dev · steviecoaster/PSSysadminToolkit
A collection of Powershell scripts to make life as a sysadmin just a tiny bit more bearable - steviecoaster/PSSysadminToolkit
github.com
November 29, 2024 at 7:51 PM
Reposted by Klaas 🇪🇺
Lots of people are mentioning me in posts on LinkedIn today, I feel left out.

I suppose I might as well publish an awesome new post, like one that covers two ways to perform CI/CD for SQL databases in Fabric using #AzureDevOps #MicrosoftFabric

www.kevinrchant.com/2024/11/29/t...
Two ways to perform CI/CD for SQL databases in Fabric using Azure DevOps - Kevin Chant
Covers two ways to perform CI/CD for SQL databases in Fabric using Azure DevOps. By showing two ways to create a dacpac.
www.kevinrchant.com
November 29, 2024 at 12:50 PM
Reposted by Klaas 🇪🇺
Running KQL queries on Microsoft Defender for Endpoint through Azure Automation

www.systanddeploy.com/2024/10/runn...
Running KQL queries on Microsoft Defender for Endpoint through Azure Automation
In this post we will see how to run KQL queries on a Microsoft Defender for Endpoint through Azure Automation, PowerShell. and Graph API
www.systanddeploy.com
November 23, 2024 at 2:35 PM