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

🎉 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

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

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

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 · 12/08/2023

You may notice that dbatools hasn’t had a new release in a while. We are having issues with the new code signing certificate requirements (Yubikey or expensive paid service) but we expect to have it all resolved within the next 7-10 days 🤞🏼

2123

Reposted by dbatools 🚀

Anthony E. Nocentino @nocentino.com · 11/08/2023

Using Install-DbaInstance again today. @dbatools.io saves me so much time! Thanks y’all!!!

072

Reposted by dbatools 🚀

Kendra Little @kendralittle.bsky.social · 26/07/2023

New post: What's the difference between DBAs, DBREs, and Data Engineers? littlekendra.com/2023/07/26/data-ca…

Venn diagram of data professional roles as explained by Trash: DBA manages individual dumpsters of trash. DBRE manages thousands of various trash containers. Data Engineer manages lakes of trash juice with streaming trash.

174

Reposted by dbatools 🚀

Erin Stellato @erinstellato.bsky.social · 26/07/2023

🧑‍💻Azure Data Studio 1.45 is now available! Blog post coming soon😅 For now, please peruse the release notes while you update ADS, and then let me know what new item you're most excited about! learn.microsoft.com/sql/azure-data-…

176

Reposted by dbatools 🚀

Cathrine Wilhelmsen @cathrinew.net · 26/07/2023

For all my fellow Microsoft nerds, there's also an #MVPBuzz feed! 🤓 bsky.app/profile/did:plc:iemt4gxgyp…

1188

Reposted by dbatools 🚀

Cathrine Wilhelmsen @cathrinew.net · 04/07/2023

Hi! 👋🏻 In case we weren't following each other somewhere else: I'm Cathrine 🤓 I blog on cathrinew.net, speak about Microsoft and Azure tech, follow the European League of Legends championship, and I'm currently renovating a house. Here are some cute photos of my parents' pets. Happy to be here 💙

A border collie laying on grass with her tongue poking out.

0112

Reposted by dbatools 🚀

Chrissy LeMaire @funbucket.dev · 18/05/2023

First thing I do nowadays when I get access to a SQL Server. Add my SQL instances to Registered Servers then: Get-DbaRegServer | Export-DbaInstance This dbatools command will export a bunch of objects including logins, jobs, database backup scripts, sp_configure, server roles, database mail & more

a screenshot of the output of Export-DbaInstance, which results in a bunch of sql and xml files, written to disk

031

Reposted by dbatools 🚀

Rob Sewell He/Him @robsewell.com · 02/05/2023

Bit of fun with @ohmyposh.dev Loading random prompts 🤣 #pwsh youtu.be/B_iR-Z2XMQ8

154

dbatools 🚀 @dbatools.io · 29/04/2023

Oh, cool! From MSFT: aka.ms/sqlcmd #sqlcmd Got a container runtime (docker / podman etc)? Get SQL Server running using the new sqlcmd: winget install sqlcmd sqlcmd create mssql --using aka.ms/AdventureWorksLT.bak Open it in Azure Data Studio sqlcmd open ads Install, Create, Open!

aka.ms

000

dbatools 🚀 @dbatools.io · 29/04/2023

After 5 months of hard work, dbatools 2.0 is finally here! Tons of improvements (and a few breaking changes). You can read more on GitHub #PowerShell #SQLServer github.com/dataplat/dbatools/releas…

github.com

044