#dbatools — Public Fediverse posts

📊 #PowerShell meets #Microsoft #Fabric. At #PSConfEU 2025, @[email protected] & @[email protected] showed how to: ✔ Automate Fabric admin tasks ✔ Analyse #dbatools output in #OneLake ✔ Use the Fabric Tools PS module 🎟️ Early bird 2026 → psconf.eu #Automation

- YouTube

📊 #PowerShell meets #Microsoft #Fabric. At #PSConfEU 2025, @jpomfret.co.uk & @sqldbawithbeard.bsky.social showed how to: ✔ Automate Fabric admin tasks ✔ Analyse #dbatools output in #OneLake ✔ Use the Fabric Tools PS module 🎟️ Early bird 2026 → psconf.eu #Automation

- YouTube

This post demos a script I put together to help move SQL Server database files to another drive and folder by generating PowerShell and T-SQL commands.
This is an alternative for when you might not be allowed to install #dbatools.

#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #PowerShell
https://vladdba.com/2025/02/06/move-sql-server-database-files-another-drive-folder/

PowerShell Universal + dbatools! http://dlvr.it/THb09b via PlanetPowerShell #PowerShell #dbatools #APIs #SQL

PowerShell Universal + dbatools! http://dlvr.it/THb09b via PlanetPowerShell #PowerShell #dbatools #APIs #SQL

To all the #SQLServer DBAs out there: A new release of the PowerShell module #dbatools has been published today.
Most of the changes were made on a rainy Sunday in France. So this is the official France release...

https://github.com/dataplat/dbatools/releases/tag/V2.1.13

To all the #SQLServer DBAs out there: A new release of the PowerShell module #dbatools has been published today.
Most of the changes were made on a rainy Sunday in France. So this is the official France release...

https://github.com/dataplat/dbatools/releases/tag/V2.1.13

In this post I cover two ways to export and import multiple SQL Server tables to and from CSV in one go with the help of a little PowerShell magic and tools like @dbatools or bcp.

https://vladdba.com/2023/11/16/export-multiple-sql-server-tables-to-csv-files

#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #dbatools #powershell

Join me at #sqlsatboston next Saturday, October 14 for “Answering the Auditor’s Call with Automation” featuring #dbatools #sqlfamily #sqlserver

https://flxsql.com/2023/10/02/sql-saturday-boston-2023/

Join me at #sqlsatboston next Saturday, October 14 for “Answering the Auditor’s Call with Automation” featuring #dbatools #sqlfamily #sqlserver

https://flxsql.com/2023/10/02/sql-saturday-boston-2023/

Version 2.1.0 der #dbatools – Ein Update mit Hindernissen | Die wichtigsten Änderungen sowie die Stolpersteine beim Update auf diese Version habe ich in meinem aktuellen Blog-Artikel zusammengestellt.
https://blog.ordix.de/version-2-1-0-der-dbatools-ein-update-mit-hindernissen

Version 2.1.0 der #dbatools – Ein Update mit Hindernissen | Die wichtigsten Änderungen sowie die Stolpersteine beim Update auf diese Version habe ich in meinem aktuellen Blog-Artikel zusammengestellt.
https://blog.ordix.de/version-2-1-0-der-dbatools-ein-update-mit-hindernissen

What's your favorite method to install #sqlserver Standard gui? Command line with config file? #powershell Dsc? #dbatools. What's your weirdest? My favorite is #ansible.

New version of DBA Dash is available 🚀
https://dbadash.com/blog/whats-new-in-2.44.0/
Making use of the build reference provided by #dbatools to display patching status in relation to the current builds that are available.
#opensource monitoring tool for #sqlserver

New version of DBA Dash is available 🚀
https://dbadash.com/blog/whats-new-in-2.44.0/
Making use of the build reference provided by #dbatools to display patching status in relation to the current builds that are available.
#opensource monitoring tool for #sqlserver

This is a brief post about how to fix "The certificate chain was issued by an authority that is not trusted" error when using @dbatools

https://vladdba.com/2023/07/29/fix-certificate-authority-that-is-not-trusted-when-using-dbatools

#sqlserver #dba #mssqlserver #mssql #sqlserverdba #powershell #dbatools

Very good presentation about cool use cases for #dbatools by @nocentino just arrived on YouTube: https://www.youtube.com/watch?v=3Qow5br8Hzo&t=565s&ab_channel=PowerShell.org

Very good presentation about cool use cases for #dbatools by @nocentino just arrived on YouTube: https://www.youtube.com/watch?v=3Qow5br8Hzo&t=565s&ab_channel=PowerShell.org

Here is the list of changes that are waiting to be released in the next version of #dbatools: https://github.com/dataplat/dbatools/compare/master...development

Here is the list of changes that are waiting to be released in the next version of #dbatools: https://github.com/dataplat/dbatools/compare/master...development

On my way to the Data Saturday Rheinland. If you are there as well and would like to talk about the #PowerShell module #dbatools for #SQLServer - feel free to contact me.
https://datasaturdays.com/2023-06-17-datasaturday0034/

On my way to the Data Saturday Rheinland. If you are there as well and would like to talk about the #PowerShell module #dbatools for #SQLServer - feel free to contact me.
https://datasaturdays.com/2023-06-17-datasaturday0034/

Still my personal recommendation for an offline installation of #dbatools, now slightly adapted to version 2.0 by including dbatools.library: https://blog.ordix.de/installation-and-use-of-dbatools-on-a-computer-without-internet-connection
#dbatools #SQLServer

After 5 months of hard work, #dbatools 2.0 is finally here! Tons of improvements (and a few breaking changes).

https://github.com/dataplat/dbatools/releases/tag/v2.0.0

After 5 months of hard work, #dbatools 2.0 is finally here! Tons of improvements (and a few breaking changes).

https://github.com/dataplat/dbatools/releases/tag/v2.0.0

If you are looking for an easy way to download the current CU for SQL Server that also includes the CU number in the filename, take a look at my Get-CU.ps1 help script: https://github.com/andreasjordan/demos/blob/master/dbatools/Get-CU.ps1
#SQLServer #PowerShell #dbatools

Just updated and tested my automated lab for SQL Server Always On Availability Groups: It works with #SQLServer 2022 and #dbatools 2.0.0-preview1 using #PowerShell 7.3 on Windows.

If you have more ideas what to test in the scripts, feel free to add a comment.

https://github.com/andreasjordan/demos/tree/master/AlwaysOn

Brent Ozar has released a small version of the StackOverflow database as a SQL Server 2022 backup. I like this database, but needed a version for #SQLServer 2019 - so I wrote a small script to downgrade the database using the #PowerShell module #dbatools: https://github.com/andreasjordan/demos/blob/master/dbatools/downgrade_database.ps1

Mark your calendars for TOMORROW! Wednesday 6:30 EST. @HamptonRoadSSUG will be hosting ONLINE the 1 & Only @sqldbawithbeard Rob Sewell as he teaches us how to Automate Your DBA Tasks with #dbatools and #dbachecks. RSVP https://lnkd.in/gAtEv2fd #sqlserver #mvpbuzz #azuredatacommunity #azure

Mark your calendars for TOMORROW! Wednesday 6:30 EST. @HamptonRoadSSUG will be hosting ONLINE the 1 & Only @sqldbawithbeard Rob Sewell as he teaches us how to Automate Your DBA Tasks with #dbatools and #dbachecks. RSVP https://lnkd.in/gAtEv2fd #sqlserver #mvpbuzz #azuredatacommunity #azure

Any specific recommendations for a database GUI (supporting manually creating/deleting/copying/.... tables and records) for personal use? Looking for something similar to what Microsoft Access offers in terms of editing database and records, but working with different database back-ends (sqlite, AWS aurora serverless, GCP, Azure, ...)
Thanks!!!
#dbatools #sqlite #GUI #database

Any specific recommendations for a database GUI (supporting manually creating/deleting/copying/.... tables and records) for personal use? Looking for something similar to what Microsoft Access offers in terms of editing database and records, but working with different database back-ends (sqlite, AWS aurora serverless, GCP, Azure, ...)
Thanks!!!
#dbatools #sqlite #GUI #database

Hey @donjones this must be old hat for you but I found your book for sale in Paris! About two minutes before I found ours!!! I literally cried 😅 🇫🇷 🥖 #dbatools #powershell #sqlserver

Hey @donjones this must be old hat for you but I found your book for sale in Paris! About two minutes before I found ours!!! I literally cried 😅 🇫🇷 🥖 #dbatools #powershell #sqlserver

DBA Dash now has a Timeline view for your SQL Server agent jobs. It takes inspiration from #dbatools ConvertTo-DbaTimeline.
Free & open source monitoring for #sqlserver.
https://dbadash.com/blog/whats-new-in-2.31.0/

📅 This week, we have a brand new episode with none other than @cl where we learn about community building, DBATools, the journey to becoming an author, and more. 🥂

👂Listen: https://powershellpodcast.podbean.com/e/building-communities-with-chrissy-lemaire/
👁Watch: https://www.youtube.com/watch?v=iN7rCPBwAoU

There is lots of great content in this episode that I hope serves you well 👍

Have a great 2023!

#PowerShell #Podcast #Community #DBA #dbatools

Now that I've separated the libraries for #dbatools 2.0 into Desktop and Core, #PowerShell remoting from Core with Credentials is hell because it downgrades to 5.1 and tries to use those libs

Test-DbaMaxMemory -SqlInstance workstation -SqlCredential $cred
WARNING: [15:44:22] Could not load type 'Microsoft.SqlServer.Server.SqlContext' from assembly 'System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.

Anyone know of a slick way to address this besides documentation?

Help Wanted: #dbatools 2.0 https://github.com/dataplat/dbatools/discussions/8696