real-world tde database migrations
In today’s post, I will tell you about how we managed to successfully complete a migration during a ~12 hour maintenance window. This could have taken a LOT longer if …
t-sql tuesday and new module teaser
The challenge I always try to solve my technical issues with natively available (aka Microsoft) solutions. It’s one of the many reasons I love PowerShell. When it comes to monitoring, …
I ❤️ Invoke-DbaQuery
Pétur Grétarsson, here. Long time dbatools fan, first time blogger. I really love the new Invoke-DbaQuery command and wanted to share how I use it. I have well over 100 …
cleaning up comment-based help
Hey all! Andy Levy here. I’m a SQL Server DBA and major contributor for dbatools. My current focus within the project is fixing the docs and more specifically, the help …
Getting complex with Restore-DbaDatabase
As part of the `Restore-DbaDatabase` stack rewrite, I wanted to do make things easier for users to be able to get their hands dirty within the Restore stack. Not necessarily needing to dive into the core code and the world of GitHub Pull Requests, but by manipulating the data flowing through the pipeline using standard PowerShell techniques, all the while being able to do the heavy lifting without code.
new release – picklerick
I have to wake up at 3am to go to the airport and start a solid two weeks of vacation, so I’ll keep this incredibly short. Tonight, we released picklerick. …
improving tests: code coverage usecase
A recent addition to the release pipeline is the “code coverage” report. Although you can find several posts about the intricacies of code coverage for PowerShell (my favourite is this …
our prompt
A few months back, dbatools wizard Fred created a prompt that was so awesome, I never had to use Measure-Command again. It was cool enough that a number of us …
walk-thru: installing modules from the powershell gallery
It’s easy for PowerShell toolmakers to forget that new users may have questions about ExecutionPolicy and Repositories. If dbatools is the first module you’ve ever installed and used, this guide is intended to help you with all of your questions and concerns.
introducing the community-driven build reference
Yet another post from the dbatools team, I’m Simone Bizzotto. Hit me up on Slack, I’m @niphlod. the problem Even the accidental DBA has to manage those pesky SQL Server …