Constantine and I recently presented for 24 Hours of PASS and the video is now online! Our goal in this intro-level session was to help make PowerShell feel approachable and demonstrate its immediate value with commands like Get-DbaLastGoodCheckDb, Test-DbaSpn and Invoke-DbaDiagnosticQuery.
Slides | Demo Code Entire Presentation | Demo Portion of Presentation | Included SPN Sample Video
If you’re already familiar with the project and would like to bypass the intro, you can jump right to the demo.
If you work in a secure environment or your computers cannot access the Internet for any reason, you can still install dbatools with ease by downloading the zip from a workstation that does have Internet access 🎉 And now that our module is digitally signed, you can keep your Execution Policy set to AllSigned, too.
There are essentially 3 ways to get the zip of our module
From PowerShell Gallery using Save-Module From PowerShell Gallery by downloading from powershellgallery.
Well, first we’d like to give a big ol’ shoutout to our teammate and new PowerShell MVP Rob Sewell!
Rob is one of the most visible members of the SQL PowerShell community, an officer in the PASS PowerShell Virtual Group and an outstanding evangelist & Pester test maker for dbatools. We’re all so excited about Rob’s well-deserved recognition - love you, buddy! ❤️
Bagofbobbish Beta Testing Before the official release of bagofbobbish to master and the PowerShell Gallery, we need help finding bugs.
How cool is this? dbatools Major Contributor Constantine Kokkinos and I will be presenting a full-day session at PASS Summit in Seattle, WA, USA on Tuesday, October 31, 2017! Our precon will have a lab so seats are limited — you’ll need to sign up now to ensure a spot.
Rob Sewell will also be joining us as a guest presenter and it looks like teammates Sander Stad and Shawn Melton will help proctor the lab 😊
Today’s article is part of T-SQL Tuesday. T-SQL Tuesday is the brainchild of Adam Machanic. It is a blog party on the second Tuesday of each month. Everyone is welcome to participate.
This month’s T-SQL Tuesday, hosted by Grant Fritchey (b), is all about Databases and DevOps.
What Is DevOps? Recently, I took an Intro to DevOps Engineering class in my Masters program at Regis University. I actually found one of our first assignments to be one of the most challenging: define DevOps.
While we are still hard at work getting everything ready for the 1.0 release, thought I would share something I figured out with VS Code. If you are not familiar with VS Code you can check the link out on how it is used to contribute to dbatools.
Pester One of the big initiatives we are working fearlessly on for the module is getting the Pester test added and cleaned up.
In the latest release, we gained 8 new commands and 5 new contributors to the dbatools master repository for a grand total of 53! We even added a few new Major Contributors to the team. Thanks to all who have joined in to make the awesomest toolset for SQL Server DBAs — we’re now offering the community nearly 190 quality commands!
Export Commands Export-DbaScript Exports scripts from SQL Management Objects.
My favorite vacation ever was the time I visited Steve Jones’ wardrobe. It bore a striking resemblance to Maui and even came with complimentary piña coladas.
The year was 2009. The sun was out, Colbie Caillat was on the radio and I hadn’t mastered PowerShell yet, so I was left feeling frantic about the health of my SQL Server estate.
Now, though, I’ve got dbatools which allows me to quickly check the things that concern me most.
Recently, Constantine, Rob, Aaron, and I got together to record a podcast for SQL Data Partners with Steve Stedman and Carlos L Chacon. We talked mostly dbatools, the community, open source projects and then I answered some SQL Family questions.
Today, the SQL Data Partners team released the podcast, along with a corresponding transcript.
Spoiler Alert: I know you’re all wondering what my superhero power would be, so here’s my answer 😊
So, there’s a World Backup Day, but what about World Restore Day? We’ve all been told over and over, backups are useless if they can’t be restored and verified. Grant Fritchey has even yelled it at us a couple times.
Using dbatools to Automate Tests dbatools makes it crazy easy to automate your backup testing, as demonstrated by Sander Stad, Rob Sewell and Anthony Nocentino. It even works on Linux!
dbatools