dbatools 🚀
@dbatools.io
Community driven SQL Server PowerShell module. Works on Windows, Linux and macOS.
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 | 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.
dbatools.io
November 13, 2025 at 7:53 PM
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!
Reposted by dbatools 🚀
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.
October 30, 2025 at 10:49 AM
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.
Reposted by dbatools 🚀
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
October 11, 2025 at 12:56 PM
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
SEVEN MILLION+ downloads on the PowerShell Gallery! Thanks to everyone who helped make this happen 🤗
August 8, 2025 at 10:39 AM
SEVEN MILLION+ downloads on the PowerShell Gallery! Thanks to everyone who helped make this happen 🤗
🎉 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.
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 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. …
blog.netnerds.net
August 7, 2025 at 10:34 AM
🎉 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.
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.
Reposted by dbatools 🚀
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...
The @dbatools.io module always amazes me, even though I use it everyday!
jesspomfret.com/dbatools-bac...
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.
jesspomfret.com
April 18, 2025 at 12:28 PM
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...
The @dbatools.io module always amazes me, even though I use it everyday!
jesspomfret.com/dbatools-bac...
Reposted by dbatools 🚀
Reposted by dbatools 🚀
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...
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...
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.
vladdba.com
February 24, 2025 at 8:59 PM
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...
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...
Reposted by dbatools 🚀
⚠️ 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
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
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
www.meetup.com
January 22, 2025 at 12:39 PM
⚠️ 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
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
Reposted by dbatools 🚀
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!
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...
What do you think? What should I add? (especially to the home page 🤣)
www.youtube.com/watch?v=DKD1...
PowerShell Universal + dbatools!
YouTube video by Jess Pomfret
www.youtube.com
January 20, 2025 at 2:38 PM
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!
Reposted by dbatools 🚀
I’m getting so many ideas from this. And so little time.
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...
What do you think? What should I add? (especially to the home page 🤣)
www.youtube.com/watch?v=DKD1...
PowerShell Universal + dbatools!
YouTube video by Jess Pomfret
www.youtube.com
January 20, 2025 at 11:09 AM
I’m getting so many ideas from this. And so little time.
Reposted by dbatools 🚀
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
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...
What do you think? What should I add? (especially to the home page 🤣)
www.youtube.com/watch?v=DKD1...
PowerShell Universal + dbatools!
YouTube video by Jess Pomfret
www.youtube.com
January 20, 2025 at 8:52 AM
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
Reposted by 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...
What do you think? What should I add? (especially to the home page 🤣)
www.youtube.com/watch?v=DKD1...
PowerShell Universal + dbatools!
YouTube video by Jess Pomfret
www.youtube.com
January 20, 2025 at 7:42 AM
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...
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!
To top off 2024, I've put together a list of my most popular blog posts in 2024.
Thanks for all the clicks, likes and shares!
vladdba.com/2024/12/31/m...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba
Thanks for all the clicks, likes and shares!
vladdba.com/2024/12/31/m...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba
Most popular blog posts in 2024
Since 2024 is coming to an end, I figured I should make a round-up, similar to Brent Ozar's, outlining the most popular blog posts this year
vladdba.com
December 31, 2024 at 3:33 PM
Lots of #SQLServer and #PowerShell on this list!
Reposted by dbatools 🚀
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.API.dbatools - PowerShell Module
HTTP REST APIs for dbatools.
powershelluniversal.com
December 26, 2024 at 9:05 PM
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...
Reposted by dbatools 🚀
November 8, 2024 at 8:56 PM
Reposted by dbatools 🚀
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
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
October 26, 2024 at 7:23 PM
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
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
Reposted by dbatools 🚀
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
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
Chrissy LeMaire - Importing unstructured data from PDF to SQL Server #DataPopkorn 2024
YouTube video by DataPopkorn
www.youtube.com
October 28, 2024 at 3:22 PM
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
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
Reposted by dbatools 🚀
I like the responses so far, too 😊
March 11, 2024 at 11:51 AM
I like the responses so far, too 😊
Reposted by dbatools 🚀
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.
ChatGPT - dbatools help
Finds commands and assists with dbatools development
chat.openai.com
March 11, 2024 at 11:48 AM
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 🚀
March 10, 2024 at 8:12 AM
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 🚀
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.
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...
github.com
March 9, 2024 at 11:11 AM
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.
Reposted by dbatools 🚀
Time for @jpomfret.bsky.social to talk about replication in @dbatools.io @databristol
February 22, 2024 at 6:35 PM
Time for @jpomfret.bsky.social to talk about replication in @dbatools.io @databristol
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...
November 5, 2023 at 6:03 PM
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.
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.
EXPECTED ERROR: Update-Module dbatools Authenticode Issue for 2.1.0 · Issue #9090 · dataplat/dbato...
TLDR: This error is expected and the change is legitimate. Just slap on the -SkipPublisherCheck parameter and continue your update. As people update over time, this should become less and less of a...
github.com
September 21, 2023 at 12:53 PM
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.
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.