Have you heard about dbaTools?
dbaTools is a free, open-source PowerShell module created by the SQL Server Community. With hundreds of SQL Server Administration, Best Practices and Migration Commands, dbaTools makes it possible to use PowerShell to automate just about any SQL Server task from boring daily duties right through to security audits.
Need more convincing? Here’s three important reasons you should seriously consider dbaTools to become a more efficient, more effective database admin.
1. dbaTools has more functions than official Microsoft tools!
Microsoft has its own closed-source tools for using PowerShell with SQL Server: SqlServer and SQLPS. SQLPS is shipped with PowerShell for backwards compatibility, but is no longer being updated. The SqlServer module is still available but that offers only around 100 commands for the most basic tasks. These commands are also driven by Microsoft’s business priorities, not the needs of SQL Server users to streamline their daily work lives.
In contrast, dbaTools has over 500 commands, covering everything from instance migrations, tempdb configuration, and best practice implementations , right through to tools for improving an instance’s security posture.
2. You can learn dbaTools in just a month of lunches
The creators of dbaTools have created something amazing to help you pick up the technology fast. Working with publisher Manning, well-known for their high quality tech books, authors Chrissy LeMaire and Rob Sewell have produced Learn dbaTools in a Month of Lunches, available now in early access.
Readers have described the book as “an excellent resource to use for advancing your skills with advanced administration for SQL servers, regardless of the number of servers you are administering”. Broken up into different bite-size lessons, the book teaches you the complete ins-and-outs of dbaTools in just a month’s worth of lunch breaks.
3. The community is growing fast
In just three years, the dbaTools GitHub has grown to over 130 contributors, getting close to catching up with Microsoft’s official PowerShell repository. Thanks to its open source nature, dbaTools opens up the possibilities for you to build and share your own resources with the community. Community members can get creative, building whole wizards rather than just using basic building block tools–and many of them are!