Dbatools Versions Save

What's Changed

• Update Get-DbaDbBackupHistory.ps1 by @0x7FFFFFFFFFFFFFFF in https://github.com/dataplat/dbatools/pull/9138
• Update dbatools-buildref-index.json - Added 11.0.7512 by @andreasjordan in https://github.com/dataplat/dbatools/pull/9142
• Add-DbaAgDatabase - Use ExecuteAs with restore to set correct database owner by @andreasjordan in https://github.com/dataplat/dbatools/pull/9144
• Connect-DbaInstance - Change EncryptConnection to a switch with a default of $true by @andreasjordan in https://github.com/dataplat/dbatools/pull/9143
• New-DbaEndpoint - New parameter AuthenticationOrder by @andreasjordan in https://github.com/dataplat/dbatools/pull/9145
• Set-DbaDbCompatbility - Fix for using piped input and don't trust master compatibility level by @andreasjordan in https://github.com/dataplat/dbatools/pull/9146
• Update Set-DbaAgentJobStep Retry null check by @tyndur in https://github.com/dataplat/dbatools/pull/9148
• New-DbaEndPoint - Fix Auth Order Param issue by @potatoqualitee in https://github.com/dataplat/dbatools/pull/9155
• Backup-DbaDatabase - allow users to specify no compression by @ben-thul in https://github.com/dataplat/dbatools/pull/9151
• Encryption Check - Add support for string settings by @potatoqualitee in https://github.com/dataplat/dbatools/pull/9154
• Install-DbaInstance - Fix for installing MachineLearning in SQL Server 2022 by @potatoqualitee in https://github.com/dataplat/dbatools/pull/9153
• Config - do not attempt HKCU on macOS or Linux by @potatoqualitee in https://github.com/dataplat/dbatools/pull/9157
• Fix non-Windows Import Errors by @potatoqualitee in https://github.com/dataplat/dbatools/pull/9158

New Contributors

• @0x7FFFFFFFFFFFFFFF made their first contribution in https://github.com/dataplat/dbatools/pull/9138
• @tyndur made their first contribution in https://github.com/dataplat/dbatools/pull/9148

Full Changelog: https://github.com/dataplat/dbatools/compare/v2.1.4...v2.1.5

Thank you, Randolph! ❤️‍🔥

What's Changed

• SQL Server 2019 and 2022 CUs: Update dbatools-buildref-index.json by @rwestMSFT in https://github.com/dataplat/dbatools/pull/9127

Full Changelog: https://github.com/dataplat/dbatools/compare/v2.1.3...v2.1.4

Thanks to all who contributed! Also thanks to @StartAutomating who didn't show up on this list but helped create a tool that we use for separating out help into a help file. You can find HelpOut on GitHub and in the PowerShell Gallery.

We used the following command:

Install-Maml -FunctionRoot public, private -Module dbatools -Compact -NoVersion -ScriptName dbatools.ps1 -NoComment

Then we further compress the resulting dbatools.ps1 to a dbatools.dat

What's Changed

• Remove-DbaDatabaseSafely - Fix usage of Stop-Function by @andreasjordan in https://github.com/dataplat/dbatools/pull/9109
• Get-DbaAgListener - Fix filtering for listener names by @andreasjordan in https://github.com/dataplat/dbatools/pull/9108
• Add repl commands to the psm1 by @jpomfret in https://github.com/dataplat/dbatools/pull/9124
• Set-DbaNetworkCertificate - Support localhost and use it as default for SqlInstance by @HCRitter in https://github.com/dataplat/dbatools/pull/9098
• Set-DbaDbCompression, prefer online rebuilds where possible by @niphlod in https://github.com/dataplat/dbatools/pull/9118
• Copy-DbaDbTableData - Enable failback to default group by @ben-thul in https://github.com/dataplat/dbatools/pull/9122
• Invoke-DbaDbDataMasking - Use correct logging command by @andreasjordan in https://github.com/dataplat/dbatools/pull/9117
• Remove-DbaDatabaseSafely - Fix Exception handling by @andreasjordan in https://github.com/dataplat/dbatools/pull/9115
• Install-DbaInstance - Use maximum length for random password by @andreasjordan in https://github.com/dataplat/dbatools/pull/9119
• Set-DbaNetworkCertificate - Support localhost and use it as default for SqlInstance (part 2) by @andreasjordan in https://github.com/dataplat/dbatools/pull/9125
• Update dbatools-buildref-index.json Added security updates addressing by @MikeyBronowski in https://github.com/dataplat/dbatools/pull/9126

Full Changelog: https://github.com/dataplat/dbatools/compare/v2.1.2...v2.1.3

What's Changed

• Add-DbaAgDatabase - Fix stale cache issue by @andreasjordan in https://github.com/dataplat/dbatools/pull/9101

Full Changelog: https://github.com/dataplat/dbatools/compare/v2.1.1...v2.1.2

What's Changed

• Add replication support to dbatools! by @jpomfret in https://github.com/dataplat/dbatools/pull/8958
• Test-DbaLoginPassword, use parametrized query by @niphlod in https://github.com/dataplat/dbatools/pull/9097
• Test-DbaConnection - Fix for wrong data in failed connections by @HarrisonLond in https://github.com/dataplat/dbatools/pull/9096
• Fix stale cache issue in Add-DbaAgDatabase by @agowa in https://github.com/dataplat/dbatools/pull/9094

New Contributors

• @HarrisonLond made their first contribution in https://github.com/dataplat/dbatools/pull/9096
• @agowa made their first contribution in https://github.com/dataplat/dbatools/pull/9094

Full Changelog: https://github.com/dataplat/dbatools/compare/v2.1.0...v2.1.1

What's Changed

• Get-DbaDatabase - Add RecoveryPending as possible Status by @andreasjordan in https://github.com/dataplat/dbatools/pull/8965
• Get-DbaMaintenanceSolutionLog - Update documentation by @andreasjordan in https://github.com/dataplat/dbatools/pull/8979
• Export-DbaUser - Add support for SQL Server 2022 by @andreasjordan in https://github.com/dataplat/dbatools/pull/8978
• Install-DbaMaintenanceSolution - Added InstallJobs switch in examples by @andreasjordan in https://github.com/dataplat/dbatools/pull/8982
• Get-DbaDbRoleMember - EnableException support on child function call by @wsmelton in https://github.com/dataplat/dbatools/pull/8987
• configuration.ps1 - Fix wrong setting of NoRegistry by @andreasjordan in https://github.com/dataplat/dbatools/pull/8968
• Backup-DbaDatabase - Add database name to error message by @andreasjordan in https://github.com/dataplat/dbatools/pull/8975
• Get-DbaStartupParameter - Return debug flags instead of writing warning by @andreasjordan in https://github.com/dataplat/dbatools/pull/8977
• Connect-DbaInstance - Fix for using a connection string by @andreasjordan in https://github.com/dataplat/dbatools/pull/8962
• Add IsHadrEnabled to default output of Microsoft.SqlServer.Management.Smo.Server by @andreasjordan in https://github.com/dataplat/dbatools/pull/8983
• Update build file - SQL 2022 CU5, SQL 2019 CU21 by @MikeyBronowski in https://github.com/dataplat/dbatools/pull/8990
• Test-DbaWindowsLogin - Add support for pipeline input from Get-DbaLogin by @andreasjordan in https://github.com/dataplat/dbatools/pull/8984
• Documentation - correct typo of TThe to The by @mikeblas in https://github.com/dataplat/dbatools/pull/9000
• Update reference in project readme - correction on custom port syntax by @mikeblas in https://github.com/dataplat/dbatools/pull/8998
• Get-DbaDbBackupHistory - support AvailabilityGroupName for Raw parameter output by @andreasjordan in https://github.com/dataplat/dbatools/pull/8974
• New-DbaLogShippingPrimaryDatabase / New-DbaLogShippingSecondaryPrimary - Add missing parameter name by @andreasjordan in https://github.com/dataplat/dbatools/pull/8971
• Update-DbaServiceAccount - Add information about supported services and versions by @andreasjordan in https://github.com/dataplat/dbatools/pull/8981
• Get-DbaMemoryUsage - New parameters for regex string to support non US systems by @andreasjordan in https://github.com/dataplat/dbatools/pull/8976
• Copy-DbaSsisCatalog - Fix building IntegrationServices object by @andreasjordan in https://github.com/dataplat/dbatools/pull/9005
• Test-DbaDbCompatibility - Determining target compatibility level based on server version by @andreasjordan in https://github.com/dataplat/dbatools/pull/8992
• Copy-DbaDatabase - Set correct database offline on source server when using both -NewName and -SetSourceDatabaseOffline by @andreasjordan in https://github.com/dataplat/dbatools/pull/9004
• Read-DbaXEFile - Refactoring to get the command working again by @andreasjordan in https://github.com/dataplat/dbatools/pull/9007
• Invoke-DbaDbDataGenerator / Get-DbaRandomizedValue - Fix precision for datatime datatype by @andreasjordan in https://github.com/dataplat/dbatools/pull/9016
• Convert-DbaIndexToTable - Fix for [n]varchar(max) by @andreasjordan in https://github.com/dataplat/dbatools/pull/9014
• Copy-DbaSystemDbUserObject - Create schema with correct owner by @andreasjordan in https://github.com/dataplat/dbatools/pull/9017
• Copy-DbaDatabase - Add missing parameter validation by @mikeblas in https://github.com/dataplat/dbatools/pull/9002
• Copy-DbaDatabase - Fix documentation for parameter BackupRestore by @andreasjordan in https://github.com/dataplat/dbatools/pull/9018
• New-DbaAgentSchedule - Don't allow shorter intervals than 10 seconds by @andreasjordan in https://github.com/dataplat/dbatools/pull/9020
• Test-DbaLastBackup - change backupDate fixes #9024 by @jpomfret in https://github.com/dataplat/dbatools/pull/9025
• Get-DbaProductKey - Continue on error by @andreasjordan in https://github.com/dataplat/dbatools/pull/9023
• Improve formatting by @andreasjordan in https://github.com/dataplat/dbatools/pull/9026
• Update dbatools-buildref-index.json by @rwestMSFT in https://github.com/dataplat/dbatools/pull/9034
• fix typo in Get-DecryptedObject.ps1 by @DiHo78 in https://github.com/dataplat/dbatools/pull/9054
• Add SQL Server 2022 CU7 by @MikeyBronowski in https://github.com/dataplat/dbatools/pull/9056
• Add SQL Server 2019 CU22 by @rwestMSFT in https://github.com/dataplat/dbatools/pull/9058
• added cu8 for 2022 by @niphlod in https://github.com/dataplat/dbatools/pull/9082
• Find-DbaInstance - Fix regex for UDP Search by @uncletimmy3 in https://github.com/dataplat/dbatools/pull/9072
• Bug Fix #9068. New-DbaDbUser by @sqlarticles in https://github.com/dataplat/dbatools/pull/9078
• Copy-DbaDatabase - Use correct variable for testing for same database by @andreasjordan in https://github.com/dataplat/dbatools/pull/9032

New Contributors

• @mikeblas made their first contribution in https://github.com/dataplat/dbatools/pull/9000
• @rwestMSFT made their first contribution in https://github.com/dataplat/dbatools/pull/9034

Full Changelog: https://github.com/dataplat/dbatools/compare/v2.0.4...v2.1.0

Surprisingly big version! Thanks again @andreasjordan 🏆

What's Changed

• Fix JobCount returned on schedule creation by @lowlydba in https://github.com/dataplat/dbatools/pull/8934
• New-DbaAgentSchedule - Fix issue with FrequencyInterval Weekdays by @andreasjordan in https://github.com/dataplat/dbatools/pull/8938
• Get-DbaAgentSchedule - Use better switch syntax by @andreasjordan in https://github.com/dataplat/dbatools/pull/8937
• Get/Test-DbaBuild, handle version "aliases" by @niphlod in https://github.com/dataplat/dbatools/pull/8959
• Watch-DbaDbLogin - Only write to target and don't watch target by @andreasjordan in https://github.com/dataplat/dbatools/pull/8936
• Test-DbaBackupInformation - Fix for database name capitalization changes by @andreasjordan in https://github.com/dataplat/dbatools/pull/8942
• New-DbaAvailabilityGroup and Add-DbaAgDatabase: Improve progress bars by @andreasjordan in https://github.com/dataplat/dbatools/pull/8943
• Install-DbaFirstResponderKit - Use target database on first connect by @andreasjordan in https://github.com/dataplat/dbatools/pull/8951
• Get-DbaProductKey - Support SQL Server 2022 by @andreasjordan in https://github.com/dataplat/dbatools/pull/8952
• Get-DbaDbAssembly - Fix filter for name by @andreasjordan in https://github.com/dataplat/dbatools/pull/8953
• Copy-DbaDatabase - Fix issue while deleting backups by @andreasjordan in https://github.com/dataplat/dbatools/pull/8954
• Copy-DbaDbTableData - Fix test and example for query parameter by @andreasjordan in https://github.com/dataplat/dbatools/pull/8956
• New-DbaDbUser - Align code with docs by @andreasjordan in https://github.com/dataplat/dbatools/pull/8957
• Get-DbaProductKey - Enable support for SQL Server 2005 by @andreasjordan in https://github.com/dataplat/dbatools/pull/8961
• Export-DbaDbRole - Exclude special user dbo by @andreasjordan in https://github.com/dataplat/dbatools/pull/8963
• New-DbaAvailabilityGroup - Remove parameter ReadonlyRoutingConnectionUrl by @andreasjordan in https://github.com/dataplat/dbatools/pull/8960

Full Changelog: https://github.com/dataplat/dbatools/compare/v2.0.3...v2.0.4

What's Changed

• Update dbatools-buildref-index.json - SQL 2022 CU4 by @MikeyBronowski in https://github.com/dataplat/dbatools/pull/8925
• Install-DbaMaintenanceSolution - fix scheduler, add examples by @potatoqualitee in https://github.com/dataplat/dbatools/pull/8926
• Fix SuspectPage example in documentation by @msgisme in https://github.com/dataplat/dbatools/pull/8928

New Contributors

• @msgisme made their first contribution in https://github.com/dataplat/dbatools/pull/8928

Full Changelog: https://github.com/dataplat/dbatools/compare/v2.0.2...v2.0.3

What's Changed

• Connect-DbaInstance: Use parameter or config for TrustServerCertificate for connections from registered servers by @andreasjordan in https://github.com/dataplat/dbatools/pull/8900
• Test-DbaSpn: Support multiple ports per instance by @andreasjordan in https://github.com/dataplat/dbatools/pull/8901
• fixed issue #8906 and #8905 by @HCRitter in https://github.com/dataplat/dbatools/pull/8909
• Removed wrong examples in synopsis; fixed issue #8908 #8907 by @HCRitter in https://github.com/dataplat/dbatools/pull/8910
• Update-Dbatools - Deprecate command by @potatoqualitee in https://github.com/dataplat/dbatools/pull/8912
• Get-DbaDbTable - Only return accessible objects by @potatoqualitee in https://github.com/dataplat/dbatools/pull/8913
• Install-DbaMaintenanceSolution - Add auto-scheduling by @potatoqualitee in https://github.com/dataplat/dbatools/pull/8911

Full Changelog: https://github.com/dataplat/dbatools/compare/v2.0.1...v2.0.2

Thanks to everyone who contributed!

What's Changed

• Import-DbaCsv - #8554 add documentation for importing gzip csv by @match-gabeflores in https://github.com/dataplat/dbatools/pull/8885
• Backup-DbaDatabase - EnableException when appropriate by @potatoqualitee in https://github.com/dataplat/dbatools/pull/8887
• Import-Command: Wait if file in use by @potatoqualitee in https://github.com/dataplat/dbatools/pull/8893
• New Command - Test-DbaAgSpn by @potatoqualitee in https://github.com/dataplat/dbatools/pull/8889
• New-DbaCredential - MappedClassType not found by @potatoqualitee in https://github.com/dataplat/dbatools/pull/8892
• New-DbaComputerCertificate - Fix immutability issue by @potatoqualitee in https://github.com/dataplat/dbatools/pull/8897
• Refactored function to improve code clarity and fix issue #8807 by @HCRitter in https://github.com/dataplat/dbatools/pull/8896
• Update library version with working Analysis Services on Desktop by @potatoqualitee in https://github.com/dataplat/dbatools/pull/8898

New Contributors

• @match-gabeflores made their first contribution in https://github.com/dataplat/dbatools/pull/8885
• @HCRitter made their first contribution in https://github.com/dataplat/dbatools/pull/8896

Full Changelog: https://github.com/dataplat/dbatools/compare/v2.0.0...v2.0.1