new release – realfakedoors

In the latest release, we gained 22 new commands and 2 new contributors to the dbatools master repository for a grand total of 48! 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 180 quality commands!

1.0 Reminder

On March 1, 2017, we initiated a new command freeze. This means that we will no longer be accepting commands that are not within the scope of version 1.0, which we hope to debut on June 1. You may notice that this release still contains a lot of new commands — that’s because there was a mad dash to get a bunch of commands in before March 1 😉 We actually still have a few more left to vet.

A new command freeze is necessary because we invest time vetting each PR and in order to reach 1.0 in a timely manner, we need to focus on bug and style resolutions. We’re asking anyone who can code to help fix the 35 bugs currently filed at GitHub and address the style changes that the community decided upon.

If you’re available to help, we’d love it! Even if you don’t know PowerShell, we’ll need help updating the website with screenshots and examples with the updated parameters and command names, and other tasks of that nature. We will be working on the following:

  • Bug fixes
  • Standardized documentation
  • Standardized names for parameters, commands, etc
  • Standardized outputs
  • Testing

We plan to resolve all bug issues first and will continue releasing on a regular basis until the style changes are implemented.

New Commands

Of the 22 new commands in this release, one command, Get-DbaSqlBuildReference, fulfills a need that I’ve seen talked about in the community for quite some time. Major Contributor Simone Bizzotto parsed a ton of SQL Server build information, created a JSON database then coded Get-DbaSqlBuildReference to parse it. We’ll also be placing the data on sqlcollaborative.github.io once we get that going. Thank you, Simone!

General commands

Based on the popularity of Get-DbaDatabase and a general agreement within the team, 1.0 will include a bunch of basic Gets and Sets within the module that return SMO objects. Here’s the first batch!

  • Get-DbaAgentJob
    Gets SQL Agent Job information for each instance(s) of SQL Server.

  • Get-DbaAgentJobOutputFile
    Returns the Output File for each step of one or many agent job with the Job Names provided dynamically if required for one or more SQL Instances.

  • Get-DbaBackupDevice
    Gets SQL Backup Device information for each instance(s) of SQL Server.

  • Get-DbaCredential
    Gets SQL Credential information for each instance(s) of SQL Server.

  • Get-DbaCustomError
    Gets SQL Custom Error Message information for each instance(s) of SQL Server.

  • Get-DbaDatabaseAssembly
    Gets SQL Database Assembly information for each instance(s) of SQL Server.

  • Get-DbaDatabaseEncryption
    Returns a summary of encryption used on databases based to it. Shows if a database has Transparent Data encryption, any certificates, asymmetric keys or symmetric keys with details for each.

  • Get-DbaJobCategory
    Gets SQL Agent Job Category information for each instance(s) of SQL Server.

  • Get-DbaServerAuditSpecification
    Gets SQL Security Audit Specification information for each instance(s) of SQL Server.

  • Get-DbaTable
    Shows table information around table row and data sizes and if it has any table type information.

  • Set-DbaAgentJobOutputFile
    Sets the OutPut File for a step of an agent job with the Job Names and steps provided dynamically if required.

  • Set-DbaSpConfigure
    This function changes the configured value for sp_configure settings. If the setting is dynamic this setting will be used, otherwise the user will be warned that a restart of SQL is required.

Now on tour

We recently added a new Presentations page to keep track of all of the presentations around the 🌎🌍🌏 that speak all or in part about dbatools.

New to dbatools?

Visit the downloads page for information about how to download and install dbatools (it’s 1 command). I actually created a video to demonstrate just how easy the install is on Windows 7 with PowerShell 3. The video is now on our YouTube channel.

Join us!

We’re all hanging out on the SQL Server Community Slack in the #dbatools channel. There’s over 500 of us there now, but the conversation load is reasonable.

Thanks for reading 😀
- Chrissy

Leave a Reply

Your email address will not be published. Required fields are marked *