v2.0.0

[potatoqualitee]

After 5 months of hard work, dbatools 2.0 is finally here!

THIS RELEASE INCLUDES BREAKING CHANGES.

Most notably, we updated the SQL Server libraries, which brings more power, bug fixes and breaking changes of its own. The one that will cause the most headaches is the change to encryption. Now, Trust Certificate is set to false and Encrypt is set to true. We wrote a few posts about this:

• New Encryption and Certificate Defaults in Microsoft's SQL Server Connection Provider
• Configuring network encryption for SQL Server
• New Certificate and Encryption Defaults in dbatools 2.0

Our library files (the DLLs) are also now included in their own module, dbatools.library. This means that dbatools will ultimately be smaller in size and take up less disk space for those who update often. It also means that the way you install dbatools in offline environments has changed.

A couple months ago, I wrote a post that detailed more of our changes, which you can find here:

• What's new and different in dbatools 2.0

Don't have time to mess with a new release today, consider it's a Friday? You can install the latest 1.x release by running the following command:

Install-Module dbatools -RequiredVersion 1.1.146

I'll likely update this README a few times as I discover a few things that I'd like to highlight. Until then, here is an exhaustive list of the changes that have been made since October.

What's Changed

• Update PR template with updated final pruning date (today -- repo is now 85MB) by @potatoqualitee in Update PR template with updated final pruning date (today -- repo is now 85MB) #8637
• Bug Fix 8626 Export-DbaUser by @potatoqualitee in Bug Fix 8626 Export-DbaUser #8641
• Add Certificate and CertificateName aliases for EncryptorName by @potatoqualitee in Add Certificate and CertificateName aliases for EncryptorName #8653
• Fix Copy-DbaSysDbUserObject to include indexes by @sqlslinger in Fix Copy-DbaSysDbUserObject to include indexes #8668
• Add 2022 support by @potatoqualitee in Add 2022 support #8682
• Add force on encryption commands to auto create cert with specified encryptor name by @potatoqualitee in Add force on encryption commands to auto create cert with specified encryptor name #8683
• Install-DbaInstance - drive path helper by @potatoqualitee in Install-DbaInstance - drive path helper #8684
• Address SQL Server 2022 issue with Test-DbaDbCompatibility by @wsmelton in Address SQL Server 2022 issue with Test-DbaDbCompatibility #8706
• Create Azure Automation Test and execute it from GitHub Actions by @potatoqualitee in Create Azure Automation Test and execute it from GitHub Actions #8709
• Add try/catch for containers without the hostname command by @potatoqualitee in Add try/catch for containers without the hostname command #8710
• Enable Set-DbaDbCompatibility to support SQL Server 2022 by @sanderstad in Enable Set-DbaDbCompatibility to support SQL Server 2022 #8717
• Find-DbaInstance - Correct SqlConnect check, update test to not be Appveyor specific by @wsmelton in Find-DbaInstance - Correct SqlConnect check, update test to not be Appveyor specific #8725
• Update dbatools.library and dbatools.core.library dependency versions by @potatoqualitee in Update dbatools.library and dbatools.core.library dependency versions #8734
• Reenable Azure Automation Test by @potatoqualitee in Reenable Azure Automation Test #8736
• Set-DbaDbCompatability - breaking change, code cleanup, add integration testing by @wsmelton in Set-DbaDbCompatability - breaking change, code cleanup, add integration testing #8724
• Install-DbaInstance - Support SQL Server 2022 by @andreasjordan in Install-DbaInstance - Support SQL Server 2022 #8735
• Rename directories to align with better practices by @potatoqualitee in Rename directories to align with better practices #8737
• Fix DAC alerts and errors by @potatoqualitee in Fix DAC alerts and errors #8738
• Remove install.ps1 by @potatoqualitee in Remove install.ps1 #8740
• Remove dbatools.core.library dependency, use only dbatools.library by @potatoqualitee in Remove dbatools.core.library dependency, use only dbatools.library #8741
• Register-DbatoolsConfig - Add example that shows -PassThru by @jpomfret in Register-DbatoolsConfig - Add example that shows -PassThru #8758
• Update dbatools-buildref-index.json - multiple security updates + CUs for SQL 2019/2022 by @MikeyBronowski in Update dbatools-buildref-index.json - multiple security updates + CUs for SQL 2019/2022 #8760
• Test-DbaSpn - Remove the version lookup by @wsmelton in Test-DbaSpn - Remove the version lookup #8779
• Invoke-DbaBalanceDataFiles: fix for VLDBs by @lancasteradam in Invoke-DbaBalanceDataFiles: fix for VLDBs #8776
• Update Add-DbaExtendedProperty.ps1 - removed examples from Get* function as they are not valid here by @MikeyBronowski in Update Add-DbaExtendedProperty.ps1 - removed examples from Get* function as they are not valid here #8786
• Get-DbaDbSchema: returning standard properties on the return object by @lancasteradam in Get-DbaDbSchema: returning standard properties on the return object #8775
• Get-DbaDbDbccOpenTran: Add DatabaseId to the return object by @lancasteradam in Get-DbaDbDbccOpenTran: Add DatabaseId to the return object #8781
• Get-DbaDbCompression: Add DatabaseId to the return object by @lancasteradam in Get-DbaDbCompression: Add DatabaseId to the return object #8769
• Add new function - Invoke-DbaDbAzSqlTips by @jpomfret in Add new function - Invoke-DbaDbAzSqlTips #8755
• Add ARM64 Self-Hosted Runner by @potatoqualitee in Add ARM64 Self-Hosted Runner #8788
• Add support for geometry/geography/hierarchyid types by @potatoqualitee in Add support for geometry/geography/hierarchyid types #8789
• New-DbaConnectionString - Support older compatibility by @potatoqualitee in New-DbaConnectionString - Support older compatibility #8791
• Allow disabling logging, TEPP, and maintenance by @wsmelton in Allow disabling logging, TEPP, and maintenance #8792
• Export credential by @ACALVETT in Export credential #8794
• BugFix for Install-DbaInstance.ps1 NoPendingRenameCheck by @kerneldba in BugFix for Install-DbaInstance.ps1 NoPendingRenameCheck #8802
• Install-DbaMultiTool: add sp_help_revlogin to script list by @lowlydba in Install-DbaMultiTool: add sp_help_revlogin to script list #8804
• docs: fix template typo by @lowlydba in docs: fix template typo #8806
• Install-DbaInstance: Fix for using default Feature parameter with SQL Server 2022 by @andreasjordan in Install-DbaInstance: Fix for using default Feature parameter with SQL Server 2022 #8812
• Update dbatools-buildref-index.json - SQL 2022 CU2 by @MikeyBronowski in Update dbatools-buildref-index.json - SQL 2022 CU2 #8813
• Updates to devcontainer configuration by @wsmelton in Updates to devcontainer configuration #8823
• New-DbaDbSnapshot - Support special characters in database name by @niphlod in New-DbaDbSnapshot - Support special characters in database name #8830
• Implementing Test-DbaPath for Testing Copy Folder for Log Shipping Secondary by @sqldeployhelmet in Implementing Test-DbaPath for Testing Copy Folder for Log Shipping Secondary #8826
• Set-DbaNetworkCertificate: Try to determine key algorithm and use appropriate extension class by @rose-a in Set-DbaNetworkCertificate: Try to determine key algorithm and use appropriate extension class #8818
• New-DbaDbUser: Refactor and added contained user creation by @sqlarticles in New-DbaDbUser: Refactor and added contained user creation #8827
• Contributing guide update by @wsmelton in Contributing guide update #8822
• Fix: Copy-DbaDatabase: prevent dropping of destination databases if destination is the source by @potatoqualitee in Fix: Copy-DbaDatabase: prevent dropping of destination databases if destination is the source #8831
• Find-DbaOrphanedFile - Fix path in non-Windows by @potatoqualitee in Find-DbaOrphanedFile - Fix path in non-Windows #8835
• Skip Setting Default Log Shipping Monitor by @sqldeployhelmet in Skip Setting Default Log Shipping Monitor #8832
• Attempt to resolve default shell issue in devcontainers by @potatoqualitee in Attempt to resolve default shell issue in devcontainers #8837
• Write-HostColor - Fix issue in Linux by @potatoqualitee in Write-HostColor - Fix issue in Linux #8839
• Added Filter functionality to Get-DbaDbUserDefinedTableType by @sqlarticles in Added Filter functionality to Get-DbaDbUserDefinedTableType #8834
• Add back SSIS commands for non-core PS by @potatoqualitee in Add back SSIS commands for non-core PS #8843
• Sync-DbaAvailabilityGroup - Show details for objects being synced when using -WhatIf by @potatoqualitee in Sync-DbaAvailabilityGroup - Show details for objects being synced when using -WhatIf #8844
• Get-DbaLastGoodCheckDb - Support Azure by @potatoqualitee in Get-DbaLastGoodCheckDb - Support Azure #8836
• New command - Set-DbatoolsInsecureConnection by @potatoqualitee in New command - Set-DbatoolsInsecureConnection #8849
• Restore-DbaDatabase - Enable summing TotalSize if input is from CliXml exported file by @potatoqualitee in Restore-DbaDatabase - Enable summing TotalSize if input is from CliXml exported file #8848
• Standardize Whatif Output by @potatoqualitee in Standardize Whatif Output #8846
• Update to new version by @potatoqualitee in Update to new version #8852
• Fix TEPP/autocomplete by @potatoqualitee in Fix TEPP/autocomplete #8854
• Get-DbaPermission - Fix missing bracket in SQL statement by @ft3411 in Get-DbaPermission - Fix missing bracket in SQL statement #8856
• Update sp_configure properties for 2022 by @potatoqualitee in Update sp_configure properties for 2022 #8858
• Update dbatools-buildref-index.json - SQL 2022 CU3 / SQL 2019 CU20 by @MikeyBronowski in Update dbatools-buildref-index.json - SQL 2022 CU3 / SQL 2019 CU20 #8859
• Temptables can be used on NonPooledConnections by @InDey in Temptables can be used on NonPooledConnections #8764
• Fix/8860 by @niphlod in Fix/8860 #8861
• Updated Version and changed import routine a lil bit by @potatoqualitee in Updated Version and changed import routine a lil bit #8869
• Invoke-ManagedComputerCommand - Add explicit SQLWMI import by @potatoqualitee in Invoke-ManagedComputerCommand - Add explicit SQLWMI import #8862
• Invoke-DbaBalanceDataFiles - Skip disk check on non-Windows servers by @potatoqualitee in Invoke-DbaBalanceDataFiles - Skip disk check on non-Windows servers #8866
• Test-DbaLastBackup - Enable CopyOnly for backups with multiple files by @potatoqualitee in Test-DbaLastBackup - Enable CopyOnly for backups with multiple files #8868
• Start-DbaMigration - Remove KeepCDC and KeepReplication parameters from detach method by @ben-thul in Start-DbaMigration - Remove KeepCDC and KeepReplication parameters from detach method #8871
• Fix New-DbaComputerCertificate to support PS 7.3 by @andreasjordan in Fix New-DbaComputerCertificate to support PS 7.3 #8875
• New commands: New-DbaAgentAlert and Install-DbaAgentAdminAlert by @potatoqualitee in New commands: New-DbaAgentAlert and Install-DbaAgentAdminAlert #8876
• Set-DbatoolsInsecureConnection - Persist by default by @potatoqualitee in Set-DbatoolsInsecureConnection - Persist by default #8877
• Add Maintenance Solution to module by @potatoqualitee in Add Maintenance Solution to module #8878
• Test-DbaLastBackup -VerifyOnly report failure when backup file is corrupted by @potatoqualitee in Test-DbaLastBackup -VerifyOnly report failure when backup file is corrupted #8880
• Library Update by @potatoqualitee in Library Update #8881

New Contributors

• @sqlslinger made their first contribution in Fix Copy-DbaSysDbUserObject to include indexes #8668
• @kerneldba made their first contribution in BugFix for Install-DbaInstance.ps1 NoPendingRenameCheck #8802
• @rose-a made their first contribution in Set-DbaNetworkCertificate: Try to determine key algorithm and use appropriate extension class #8818
• @sqlarticles made their first contribution in New-DbaDbUser: Refactor and added contained user creation #8827
• @ft3411 made their first contribution in Get-DbaPermission - Fix missing bracket in SQL statement #8856
• @InDey made their first contribution in Temptables can be used on NonPooledConnections #8764

Full Changelog: v1.1.142...v2.0.0

---

This discussion was created from the release v2.0.0.