dbatools 🚀

If you build software, you're based in the US or Canada, and your organization has been around for at least 3 years, check out Azure Trusted Signing.

It costs $9.99/mo, which after 3 years, costs about the same as a 3-year DigiCert — all without the antiquated ID verification.

A PowerShell Core terminal displays detailed information about an X.509 certificate, showing fields like NotAfter (8/8/2025), NotBefore (8/5/2025), SerialNumber, Thumbprint, and Issuer. Two red arrows highlight the Issuer as "CN=Microsoft ID Verified CS AOC CA 02" and the Subject as "CN=dbatools, O=dbatools, L=Vienna, S=Virginia, C=US." The background includes a stylized purple-and-cyan avatar graphic in the lower-right corner, suggesting a personalized or themed terminal setup.

But how cool is it to have your software signed by @microsoft.com?

Also, check out that NotAfter and NotBefore, so short!

Or you can stay with version 2.5.1. That signature will be valid pretty much until the end of time.

Oh and going back to Install-Module, if you switch to Install-PSResource, that bypasses the SkipPublisherCheck requirement.

```
Install-Module Microsoft.PowerShell.PSResourceGet
```

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...

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.

Trusted Publisher Checks for Azure Trusted Signing by jborean93 · Pull Request #25824 · PowerShell/PowerShell PR Summary Add support for checking the Azure Trusted Signing publisher identifier alongside the thumbprint. This check will verify whether the unique Azure TS OID present in the EKU is in any cert...

In PowerShell 7, we're looking forward to built-in support, hopefully coming soon. Shoutout to @jborean.bsky.social !

Import-Dbatools Import-Dbatools. GitHub Gist: instantly share code, notes, and snippets.

For users with strict ExecutionPolicies, we have a workaround for the daily cert rotation in Windows PowerShell.

Add this Import-Dbatools function to your profile to auto-trust certs:

A Windows Certificate Manager window shows the "Trusted Publishers" certificate store under "Certificates - Current User." The selected certificate is issued to "dbatools" and issued by "Microsoft ID Verified CS AOC CA 02," with an expiration date of August 8, 2025. Other listed certificates include several issued to "Microsoft Corporation" by "Microsoft Code Signing PCA 2011," mostly for Microsoft Publisher and code signing purposes, with varied expiration dates. The view indicates 10 total certificates in this store.

Our cert now shows Microsoft ID Verified as the issuer. Identity validation took just 30 minutes vs DigiCert's 2+ months.

Azure Trusted Signing provides instant reputation tied to our verified identity & not to a specific cert like the old way. Should finally solve years of false positives.

Upgrading from older versions? You'll need this ONE time:

```
Install-Module dbatools -Force -SkipPublisherCheck
```

After that initial transition, you won't need SkipPublisherCheck again since our cert keeps the same subject and root CA for version 2.5.5+ onward.

dbatools is moving to Azure Trusted Signing TLDR: dbatools is moving to Azure Trusted Signing, which means Microsoft backs our reputation and dbatools won't trigger as many antivirus false positives. …

🎉 Big news! dbatools is moving to Azure Trusted Signing, which provides base reputation on Windows SmartScreen. No more antivirus false positives.

The catch? If you use strict ExecutionPolicies, you'll need to trust our cert after each update (it rotates daily). But we've got automation scripts.

dbatools Backup-DbaDatabase -ReplaceInName Recently I was reading the docs for `Backup-DbaDatabase` and found a parameter I didn't realise existed, but is so useful when you want to automate backups, but keep control of the file names.

I wrote a new post about a specific parameter on Backup-DbaDatabase that I didn't know existed.

The @dbatools.io module always amazes me, even though I use it everyday!

jesspomfret.com/dbatools-bac...

😌 oh good. Happy that was the issue after getting that notification!

Getting SQL Server Version using dbatools Time to read: ~ 4 minutes Words: 730 The Initial IssueChecking under the function’s hoodUsing a dictionary insteadShift left?Using dbatoolsConnect-DbaInstanceGet-DbaDatabaseEnd I will discuss…

Getting #SQLServer Version using @dbatools.io

#SqlBlog #PowerShell

nocolumnname.blog/2025/03/06/g...

Configuring and using SQL Server client aliases In this post I cover SQL Server client aliases, what they are and when they're useful, as well as how to configure, update, and use them.

Blog post from the past:
I which I demo creating and managing aliases via @dbatools.io, cliconfig, SQL Server Configuration Manager, and registry keys.
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #powershell
vladdba.com/2023/09/29/c...

Hamburg PowerShell User Group #40 - AI, Wed, Jan 29, 2025, 7:00 PM | Meetup Das nächste Treffen der Hamburg PowerShell User Group findet am 29.01.2025 um 19:00 Uhr statt und ihr seid herzlich eingeladen! (Verschoben vom 22.01.25) Das Treffen finde

⚠️ Attention #HHPSUG #PowerShell people ⚠️

Our Hamburg PowerShell User Group today was hit by flu season and we have to move it to next week.

📆New date & time: 29.01.25 19:00 CET

Hope to see you all then.

www.meetup.com/hamburg-powe...

CC @funbucket.dev

Fantastic walk through of using @dbatools.io with PowerShell Universal. Jess provides step-by-step examples of pulling data back in APIs and building out an app to display database in tables. She even gets into the server-side paging. Worth a watch!

I’m getting so many ideas from this. And so little time.

So very cool. #dbatools & #PowerShellUniversal creating a dashboard enabling users to backup their databases and showing the current status. I also love that Jess explains some of the development process so that even if you're not a PowerShell expert you can still learn the steps to do this yourself

YouTube video by Jess Pomfret PowerShell Universal + dbatools!

Put together a little video on using #PowerShellUniversal with @dbatools.io to create a cool dashboard!

What do you think? What should I add? (especially to the home page 🤣)

www.youtube.com/watch?v=DKD1...

Lots of #SQLServer and #PowerShell on this list!

I've been making some PowerShell modules to test out PowerShell Universal's upcoming improvements to handling resources embedded in modules. Here's a simple @dbatools.io REST API. It mostly wraps some of the get commands but will likely add some more soon. powershelluniversal.com/gallery/Powe...

#psconfeu starter pack for bluesky 🫶💜
go.bsky.app/3yWTwPy

My fav starter packs so far, a thread:

stats: go.bsky.app/Ki7PjpS
stats: go.bsky.app/7TBN5rX
causal inference: go.bsky.app/FdemGAZ
package devs: go.bsky.app/N1569Qh
data peeps: go.bsky.app/8TdEfdK
medical stats: go.bsky.app/ArqEz36
bioinformatics: go.bsky.app/Ha64Gmv
r-ladies: go.bsky.app/Vgxwa2F

YouTube video by DataPopkorn Chrissy LeMaire - Importing unstructured data from PDF to SQL Server #DataPopkorn 2024

I made a 5-minute video for #DataPopkorn, hosted by @mikeybronowski.bsky.social!

In the video, I quickly show how you can use OpenAI's Structured Output and PowerShell to import data right from a PDF into SQL Server.

#OpenAI #PowerShell #SQLServer

chatgpt solidly answering a question about DR

I like the responses so far, too 😊

ChatGPT - dbatools help Finds commands and assists with dbatools development

I created a GPT for #dbatools that helps with development, contributing AND finding commands! I uploaded our XML help file along with a few of my demos and SMO's XML file.

After nearly 10 years, we've made it to 250 contributors! Thanks to all who have given their time to help make such a useful tool for the community 🚀

Release v2.1.10 · dataplat/dbatools THIS RELEASE ADDRESSES TWO CVE'S This update addresses two CVE's, one in Microsoft.Data.SqlClient and one in Azure.Identity. Thanks to @garyhampson for the update on dbatools.library dataplat/dbato...

New release! dbatools.library has been updated to include newer versions of SqlClient and Azure.Identity. The updated versions fix CVE-2024-0056 and CVE-2023-36414, both of which are High Severity.

Time for @jpomfret.bsky.social to talk about replication in @dbatools.io @databristol

dbatools loading in just 1 second.

New release! v2.1.5 is now out. Thanks to all who contributed. Have you checked out our import times lately? It's nice and fast, especially on macOS and Linux. github.com/dataplat/dba...

FINALLY! dbatools 2.1.0 is now out 🥳

If you are running Update-Module, please check out this issue which basically says that industry requirements changed and now you have to use -SkipPublisherCheck for a little while.