Latest articles and updates from the dbatools community
Chrissy LeMaire
Mar 3, 2017
So, we’ve made the first step to 1.0 – we’ve stopped accepting Pull Requests that add new commands. It breaks my heart the most, but every moment that we spend vetting a new command is a moment we can’t spend bug fixing and we really need to focus on standardization and bug fixes. Our pull request queue is currently filled with new commands that we still need to review, along with a couple bug fixes.
Read moreShawn Melton
Mar 2, 2017
What follows is a walk-through in getting VSCode setup for contributing to dbatools, and also includes various tips for utilizing the PowerShell Extension and Git features. Install VSCode is a cross-platform tool that works on Windows, Linux and Mac. You can download your specific OS flavor here. Just note that I only use Windows, so if you are on another OS your mileage may vary. If you favor being a beta tester you can download the Insiders Edition from the same page.
Read moreFeb 27, 2017
In this release, we gained 22 new commands, 7 new contributors to the dbatools master repository for a grand total of 46! We even added a couple 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 154 quality commands! Updated Commands We released the follow two commands in snowball but wanted you to download the latest version of dbatools which includes some really awesome improvements to backup and restore.
Read moreStuart
Feb 23, 2017
Just to confuse people, it’s not Chrissy or Drew this time. My name’s Stuart, and I’ve got a new dbatools release to tell you about; snowball. This Release Is All About Restores DBAs spend a lot of time making sure backups work. Or at least they should, and if they aren’t then putting their spare time to fixing up their CV is probably a good plan. So we’ve got terabytes of SQL backups stashed away on disk.
Read moreDrew Furgiuele
Feb 6, 2017
These commands were updated Feb 8, 2017 (v0.8.709) to incorporate feedback ❤️ Right, so the first thing you need to know is: I’m not Chrissy. My name’s Drew, and I’m here tell you about an exciting new release of dbatools: schwifty! In this release we’ve added three new commands to help you manage SPNs for SQL Server Kerberos authentication. If you have a lot of linked servers in your environment, then this is probably a welcome addition to the toolset for you.
Read moreChrissy LeMaire
Feb 1, 2017
In this release, we gained 4 new contributors to the dbatools master repository for a grand total of of 39! We even added 4 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 126 quality commands. Sorry for the Delay, We’ve Been Really Busy! Our last release came out around mid-December. Ideally, we aim for releasing more often, but Rob and I were out presenting about dbatools and dbareports at a few conferences and ran out of time.
Read moreChrissy LeMaire
Jan 3, 2017
First, I’d like to thank everyone for a super amazing year! 🎉 Back at the start of 2016, GitHub reports that there were two contributors to the dbatools repository and now there are 32, excluding bots. THIRTY TWO! Cheers, y’all 🍺 That’s beyond amazing and I don’t even have the words to describe how excited I am to be a part of this incredibly fun and useful project. With the help of these 32 contributors, the module has grown from 23 commands to 106!
Read moreChrissy LeMaire
Dec 14, 2016
In this release, we gained 4 new contributors to the dbatools master repository for a grand total of of 33! We even added 4 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 over 100 quality commands 😀 Just a Quick Highlight I’m especially excited about every one of the commands in this release.
Read moreChrissy LeMaire
Dec 2, 2016
Recently, I presented to the Philadelphia PowerShell User Group about Contributing to Open Source PowerShell projects using GitHub Desktop. I chose this topic because a number of people have asked for step-by-step instructions on how to work with GitHub. I love the command line, but with Git? I think it’s important to get the concepts down first and the Desktop version makes that a lot easier to contribute to projets like dbatools, dbareports and even PowerShell itself.
Read moreChrissy LeMaire
Nov 22, 2016
In this release (two in one month, woo!), we gained 3 new contributors to the dbatools master repository for a grand total of of 29! We also added a shortcuts reference page for those of you who often visit portions of our site or GitHub and would like the shortlinks. Commands We fixed about 10 bugs, made two commands more efficient and added 5 new commands. Connect-DbaSqlServer Creates an SMO SQL Server object.
Read moreChrissy LeMaire
Nov 2, 2016
In this month’s release, we gained 6 new contributors to the dbatools master repository for a grand total of of 26! This was likely the result of moving the repository to the new organization on GitHub called the SQL Server Community Collaborative, which makes it easier to participate in the dbatools project. We also added a few pages to the dbatools GitHub Wiki including: Your First Pull Request, Style Guide and Testing and Q&A.
Read moreChrissy LeMaire
Sep 20, 2016
Hey, Chrissy here. Recently, I had great success with scheduling a database migration and wanted to let you know how I did it in case you have a similar requirement. My requirement comprised of copying two databases that were 30 GB in size, from one server to another, during a time that I wouldn’t be at the office. Remote work was not possible. The Script Here’s the scheduled-migration.ps1 script that ultimately worked for me.
Read moreChrissy LeMaire
Aug 17, 2016
dbatools is not only intended to be a great migration tool, but also a toolset to help DBAs follow best practices. Check out all the new commands in this batch, courtesy of Mike Fal, Constantine Kokkinos and Chrissy LeMaire. Best Practices Commands Ever read a really great article about how to do something properly but then kinda forgot and you have to revisit each time? Well, we’ve codified some of those practices for you, making them easy to both follow and remember.
Read moreChrissy LeMaire
Aug 2, 2016
When I first began working on dbatools, I was aware of the suggestion to use a distinct prefix in PowerShell, but chose to use Sql for its universal recognition. That will soon change. PowerShell Prefixes Prefixes are the things that start the noun. SQL Server uses Sql, Active Directory uses AD, SharePoint uses SP, PowerShell uses PS and Lync uses Cs. You can see, even with two letter prefixes, that there is no true case consistency.
Read moreChrissy LeMaire
Aug 2, 2016
When I first began working on dbatools, I was aware of the suggestion to use a distinct prefix in PowerShell, but chose to use Sql for its universal recognition. That will soon change. PowerShell Prefixes Prefixes are the things that start the noun. SQL Server uses Sql, Active Directory uses AD, SharePoint uses SP, PowerShell uses PS and Lync uses Cs. You can see, even with two letter prefixes, that there is no true case consistency.
Read moreChrissy LeMaire
Jul 20, 2016
So many SQL Server and PowerShell pros have joined the dbatools team and we’re producing well designed PowerShell commands like mad! dbatools is not only intended to be a great migration tool, but also a toolset to help DBAs follow best practices. We like to think of these commands as fully automated Wizards that are executed from the command line instead of the GUI. Best Practices Commands Ever read a really great article about how to do something properly but then kinda forgot and you have to revisit each time?
Read moreChrissy LeMaire
Jul 1, 2016
The SQL Server community is now on Slack! And we are too. Just join the #dbatools channel by signing up, signing in, clicking CHANNELS then #dbatools.
Read more