dbatools

New Commands

• Export-DbaAvailabilityGroup
• Get-DbaBackupHistory
• Get-DbaDatabaseSnapshot
• Get-DbaRoleMember
• Read-DbaBackupHeader
• Remove-DbaDatabaseSnapshot
• Resolve-DbaNetworkName
• Test-DbaLastBackup
• Test-DbaMaxMemory
• Test-DbaValidLogin

Selected Bug fixes

Find-DbaOrphanedFile - speed improvements, added trims to remove null bytes for sql2000
Remove-SqlDatabaseSafely - Fixed SQL Agent Running check
Fix Export-SqlLogin not enumerating database permissions
Test-SqlMaxMemory - renamed all the MaxMemory commands
Get-DbaRestoreHistory - output directly to pipeline
Get-DbaBackupHistory - added device type
Copy-SqlLogin SQL Login not migrating when mixed mode not enabled on destination
Get-SqlRegisteredServerName - fix to allow working with nested groups

Testing

Added Appveyor + Pester

New Commands

Connect-DbaSqlServer
Get-DbaLastBackup
Get-DbaPermission
Get-DbaStartupParameter
Remove-DbaBackup

Bug Fixes & Enhancements

Copy-SqlCredential and Copy-SqlLinkedServer unneeded connect attempts/errors removed
Copy-SqlDatabase - added example, and fixed a filestream check
Find-DbaOrphanedFile - Fixed bug that reported some valid directories and files as orphaned.
Get-DbaTcpPort -Fixed a bug that hid a real exception message behind one that basically said “Something didn’t work right.”
Set-SqlMaxMemory - fixed error message
Start-SqlMigration - Corrected error that made Copy-SqlCredential and Copy-SqlLinkedServer only work with Windows auth
Test-SqlNetworkLatency -Fixed a logic bug that produced inaccurate results.
Test-SqlPath - Now works in all languages!

New Commands

Copy-SqlSsisCatalog
Find-DbaOrphanedFile
Get-DbaAvailabilityGroup
Get-DbaLastGoodCheckDb
Get-DbaProcess
Get-DbaRunningJob
Set-DbaMaxDop
Test-DbaFullRecoveryModel
Test-DbaMaxDop

Bug Fixes & Enhancements

Fix Test-DbaPowerPlan powerplan language not being native
Set-SqlTempDbConfiguration calculation bug
Test-SqlTempDbConfiguration - Improved output
Copy-SqlLogin - moved kill closer to drop
Get-ParamSqlDatabases - Adding -NoSystem to dynamic parameter to include SystemDB's
Get-DbaDiskSpace - Output format issue bug general tools
Copy-SqlDatabase - Fixed Check for ROWS or LOG
Set-SqlTempDbConfiguration errors when more than 1 data file already exists best practices bug
Set-SqlTempDbConfiguration can't set data file growth
Copy-SqlLogin - Fixed language being dropped in some circumstances
Get-DbaDiskSpace - added bytes as unit, filesystem, fragmentation and -Detailed
install.ps1 to point to updated location
Copy-SqlLogin and Database in Availability Group issue resolved
Get-DbaDatabaseFreeSpace added columns enhancement
Update-SqlPermissions, Sync-SqlLoginPermissions - Fixes for inaccessible databases

Details about this release can be found at dbatools.io/tinyrick

This is a test of the GitHub release tagging, we're doing August's version of the master branch and labelling it accordingly. We'll be doing this for real in September.