iiinova — where your digital self keeps evolving

Reposted by dbatools 🚀

Jan De Dobbeleer @jan.ohmyposh.dev · 26/12/2025

Wait? Is this oh-my-posh running natively inside Claude Code? Happy holidays everyone!

dbatools 🚀 @dbatools.io · 04/12/2025

We've even added a new command! Export-DbaCsv makes it easy to export CSV data from SQL Server. Includes fast CSV exports with GZip/Deflate/Brotli/ZLib compression, custom delimiters, quoting, date formats & encodings. Great for ETL, reporting, archiving, and moving big SQL Server datasets.

dbatools.io

Export-DbaCsv

A free, open-source PowerShell module with 600+ commands that make SQL Server administration simple, powerful, and fun.

010

dbatools 🚀 @dbatools.io · 04/12/2025

Of course, we've updated Import-DbaCsv to use this new library and no longer have a third-party dependency on Lumenworks. We also added functionality requested by our users (and Lumenworks users!) over the past 10 years such as compression and alternative delimiters.

dbatools.io

Import-DbaCsv

A free, open-source PowerShell module with 600+ commands that make SQL Server administration simple, powerful, and fun.

121

dbatools 🚀 @dbatools.io · 04/12/2025

We've just released a new CSV library for C#. If you're importing CSVs to SQL Server, it's 6x faster than LumenWorks with native IDataReader, built-in compression and progress reporting! Shoutout to Claude Code for making this possible by bringing efficient, secure C# development to PowerShell devs.

dataplat.dbatools.io

Dataplat.Dbatools.Csv

High-performance CSV reader and writer for .NET. Native IDataReader, built-in compression, and database-first design.

150

dbatools 🚀 @dbatools.io · 04/12/2025

If it's a code problem, dbatools.io/issues. For live feedback/help, dbatools.io/slack -- join the #dbatools channel and there's a bunch of admins and users who can help 💙

dbatools.io

Join SQL Server Community on Slack

Slack is a new way to communicate with your team. It’s faster, better organized, and more secure than email.

000

dbatools 🚀 @dbatools.io · 13/11/2025

Look at that commands page featuring our nearly 700 commands 😍 So useful now and easy to navigate.

The screenshot shows the "dbatools Commands" page from the dbatools website, listing PowerShell commands for SQL Server. The interface includes a search bar, filterable categories on the left, and a grid of command cards in the center. Visible commands include “Copy-DbaLogin,” “Invoke-DbaQuery,” and “Restore-DbaDatabase,” each with a short description, a yellow star icon indicating popularity, and category tags like “Migration” or “Backup & Restore.” The site header includes links for Getting Started, Commands, Blog, Book, Team, GitHub, and Builds, with an “Install” button and dark mode toggle.

185

dbatools 🚀 @dbatools.io · 13/11/2025

We even migrated the #SQLServer Builds Reference and made it an integrated part of the rest of the site dbatools.io/builds We've got Dark Mode now, too 🖤

SQL Server Build Reference page from dbatools.io showing a dark-themed interface with filter buttons by version (e.g. SQL Server 2022, 2019, 2017) and by attributes (e.g. Service Packs Only, Cumulative Updates Only). Below is a searchable, exportable table listing SQL Server build data including version numbers, names, service pack (SP) and cumulative update (CU) info, end-of-support dates, and KB article links; top entries include version 16.0.4222, 16.0.4215, and 16.0.4212 with support ending 2033-01-11.

111

dbatools 🚀 @dbatools.io · 13/11/2025

Our website recently got an upgrade! It was initially built on WordPress in 2016 then after several hacks, was exported to HTML and put on @github.com's Pages in 2020. Now, it's been redesigned using Hugo and Claude Code. Let us know what you think!

dbatools.io

dbatools | Command-line superpowers for SQL Server automation

A free, open-source PowerShell module with 600+ commands that make SQL Server administration simple, powerful, and fun.

2137

Reposted by dbatools 🚀

Chrissy LeMaire @funbucket.dev · 30/10/2025

Oh, awesome! For the next 5 hours, you can get a month free of Claude! #DevOps people, add it to your @github.com repo or use it at the CLI -- either way is incredible. I just updated my whole blog with it.

claude.com

Get a month of Claude Pro free

Sign up with your company email by October 30 and get Claude Pro free for one month. Transform your workday with AI assistance.

022

Reposted by dbatools 🚀

Chrissy LeMaire @funbucket.dev · 11/10/2025

One of my favorite things to use AI for is repo storytelling. Claude Code is SO good at using gh, git and its own tools to understand changes to @dbatools.io's repo and tell a story. Here, I asked it to detail @sqldbawithbeard.bsky.social's Pester contributions for my upcoming session at @psconf.eu

A console with the writing:

**SQLDBAWithABeard's Pester Contributions – Deep Dive:**

**The Foundation: November 23, 2016 – A Historic Day**

SQLDBAWithABeard made 83 commits in a single day (November 23, 2016), fundamentally transforming dbatools' quality standards. This was just 6 months after June Blender added the first test file.

**1. CI/CD Infrastructure Setup**

Created the complete testing infrastructure:

* tests/appveyor.pester.ps1 – A sophisticated test runner that:

* Supports multiple PowerShell versions (v2+)
* Serializes XML results for AppVeyor consumption
* Uploads test results to AppVeyor's test page via API
* Aggregates results from multiple PowerShell version test runs
* Fails builds on test failures with detailed failure summaries
* AppVeyor CI Integration – Set up continuous integration that:

* Runs tests on native PS version and PS 3.0
* Installs Pester and PSScriptAnalyzer automatically
* Collects and uploads test results
* Added skip commit support for readme updates

A console that says:

**2. Test-Driven Documentation Standards**

Created tests/dbatools.Tests.ps1 – A comprehensive module manifest test that validates:

* Module name, root module, GUID, version
* Author and company information
* PowerShell version requirements
* Required assemblies
* Critically: All exported functions match actual function files

This test ensured the module manifest stayed in sync with actual functions.

**3. The Great Documentation Cleanup (Nov 23, 2016)**

After establishing the test infrastructure, he discovered widespread documentation gaps. His response: 83 commits in one day adding parameter help to pass tests across the entire codebase:

* Added help for Force, WhatIf, Confirm parameters (ShouldProcess support)
* Added SqlCredential, Detailed, OutputFile, Collection parameter help
* Fixed function headers to match Pester requirements

271

dbatools 🚀 @dbatools.io · 08/08/2025

SEVEN MILLION+ downloads on the PowerShell Gallery! Thanks to everyone who helped make this happen 🤗

Screenshot of the PowerShell Gallery page for the dbatools module version 2.5.5, showing a large red arrow pointing to the total download count of 7,001,571, highlighting a milestone achievement; the page also displays 15,846 downloads for this version, the last published date of August 5, 2025, and an example PowerShell command to install the module.

071

dbatools 🚀 @dbatools.io · 07/08/2025

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.

azure.microsoft.com

Trusted Signing—Managed Signing Services | Microsoft Azure

Secure your applications with a fully managed end-to-end signing service for code, documents, applications, and more with Trusted Signing from Microsoft Azure.

030

dbatools 🚀 @dbatools.io · 07/08/2025

But how cool is it to have your software signed by @microsoft.com? Also, check out that NotAfter and NotBefore, so short!

140

dbatools 🚀 @dbatools.io · 07/08/2025

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

100

dbatools 🚀 @dbatools.io · 07/08/2025

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.

github.com

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

102

dbatools 🚀 @dbatools.io · 07/08/2025

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:

gist.github.com

Import-Dbatools

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

101

dbatools 🚀 @dbatools.io · 07/08/2025

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.

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.

131

dbatools 🚀 @dbatools.io · 07/08/2025

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.

133

dbatools 🚀 @dbatools.io · 07/08/2025

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

blog.netnerds.net

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

22110

Reposted by dbatools 🚀

Jess Pomfret (She/Her) @jpomfret.co.uk · 18/04/2025

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

jesspomfret.com

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.

174

dbatools 🚀 @dbatools.io · 14/03/2025

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

120

Reposted by dbatools 🚀

Fabian Bader @fabian.bader.cloud · 22/01/2025

⚠️ 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

meetup.com

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

046

Reposted by dbatools 🚀

Adam Driscoll @adamrdriscoll.com · 20/01/2025

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!

142

Reposted by dbatools 🚀

Andy Levy @alevyinroc.flxsql.com · 20/01/2025

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

143

Reposted by dbatools 🚀

Rob Sewell He/Him @robsewell.com · 20/01/2025

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

184

Reposted by dbatools 🚀

Jess Pomfret (She/Her) @jpomfret.co.uk · 20/01/2025

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

youtube.com

PowerShell Universal + dbatools!

YouTube video by Jess Pomfret

02411

Reposted by dbatools 🚀

Adam Driscoll @adamrdriscoll.com · 26/12/2024

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

powershelluniversal.com

PowerShellUniversal.API.dbatools - PowerShell Module

HTTP REST APIs for dbatools.

2176

Reposted by dbatools 🚀

Rob Sewell He/Him @robsewell.com · 08/11/2024

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

01010

Reposted by dbatools 🚀

Jeremy Allen @jeremy-data.bsky.social · 26/10/2024

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

18277132

Reposted by dbatools 🚀

Chrissy LeMaire @funbucket.dev · 28/10/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

youtube.com

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

YouTube video by DataPopkorn

1146

Reposted by dbatools 🚀

Chrissy LeMaire @funbucket.dev · 11/03/2024

I like the responses so far, too 😊

chatgpt solidly answering a question about DR

052

Reposted by dbatools 🚀

Chrissy LeMaire @funbucket.dev · 11/03/2024

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.

chat.openai.com

ChatGPT - dbatools help

Finds commands and assists with dbatools development

141

dbatools 🚀 @dbatools.io · 10/03/2024

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 🚀

031

dbatools 🚀 @dbatools.io · 09/03/2024

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.

github.com

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

011

Reposted by dbatools 🚀

Rob Sewell He/Him @robsewell.com · 22/02/2024

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

0101

dbatools 🚀 @dbatools.io · 05/11/2023

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

097

dbatools 🚀 @dbatools.io · 01/09/2023

Annnd back to DigiCert

000

Reposted by dbatools 🚀

Rob Sewell He/Him @robsewell.com · 01/09/2023

We are ready for today's pre con at Data Saturday Oslo @jpomfret.bsky.social

0191

dbatools 🚀 @dbatools.io · 31/08/2023

LOL, late again, as usual. This time, it's out of our control. We're still waiting for ssl.com to authenticate us.

100

Reposted by dbatools 🚀

Rob Sewell He/Him @robsewell.com · 29/08/2023

I like skyfeed but first impressions of blueskydeck.com are definitely postive for me. #tweetdeck #blueskydeck @blueskydeck.com

1177

Reposted by dbatools 🚀

Jess Pomfret (She/Her) @jpomfret.co.uk · 21/08/2023

So excited to see the new @dbatools.io replication functions getting some major love in @kendralittle.bsky.social Monday SQL comic today! Thank you! 😍 Spark up your Monday with a SQL Comic in your inbox (ck.page)

093

dbatools 🚀 @dbatools.io · 13/08/2023

Seriously, we considered not signing anymore. It’s another like $350/year+ for SSL dot com’s online signer and their tool doesn’t even sign all PowerShell files 😡 We opted to pay instead for the FIPS compliant Yubikey ($150 in total) and just manually sign. Total pooshow.

110