v2.1.2

What's Changed

• Add-DbaAgDatabase - Fix stale cache issue by @andreasjordan in #9101

Full Changelog: v2.1.1...v2.1.2

v2.1.1

What's Changed

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

New Contributors

• @HarrisonLond made their first contribution in #9096
• @agowa made their first contribution in #9094

Full Changelog: v2.1.0...v2.1.1

v2.1.0

What's Changed

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

New Contributors

• @mikeblas made their first contribution in #9000
• @rwestMSFT made their first contribution in #9034

Full Changelog: v2.0.4...v2.1.0

v2.0.4

Surprisingly big version! Thanks again @andreasjordan 🏆

What's Changed

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

Full Changelog: v2.0.3...v2.0.4

v2.0.3

What's Changed

• Update dbatools-buildref-index.json - SQL 2022 CU4 by @MikeyBronowski in #8925
• Install-DbaMaintenanceSolution - fix scheduler, add examples by @potatoqualitee in #8926
• Fix SuspectPage example in documentation by @msgisme in #8928

New Contributors

• @msgisme made their first contribution in #8928

Full Changelog: v2.0.2...v2.0.3

v2.0.2

What's Changed

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

Full Changelog: v2.0.1...v2.0.2

v2.0.1

Thanks to everyone who contributed!

What's Changed

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

New Contributors

• @match-gabeflores made their first contribution in #8885
• @HCRitter made their first contribution in #8896

Full Changelog: v2.0.0...v2.0.1

v2.0.0

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.

Highlighted changes

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

Here are some other highlights people may appreciate

• Support for SQL Server 2022
• The import process should now be much faster, as it now uses compression which requires less reading from disk
• SSIS commands have been added back for the Windows platform
• functions/internal is now public/private (for devs)
• devcontainer now works better (for devs)
• geometry/geography/hierarchyid types now work for people who need them
• Autocomplete has been fixed, so after connecting at least once, hit tab to auto complete SqlInstance, Database, Job and more
• Install-DbaMultiTool now installs sp_help_revlogin
• Network certificate-related commands work better
• Sync-DbaAvailabilityGroup now shows details when -WhatIf is used
• Whatif output has been standardized in all Copy (and Start-DbaMigration) commands
• Test-DbaLastBackup now works even better for more scenarios like copying backups with multiple files
• Ola Hallengren's Maintenance Solution is now included which helps those with offline networks

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

Azure DevOps and Automation changes

When I created an Azure Automation test, I had to install dbatools.library first. You may have to do that for Azure DevOps as well, so be sure to update your pipelines 🚀

Everything that's changed

I'll likely update this README a few times as I discover a few things that I'd like to highlight. I also plan to fix dbatools.io so that I can publish blog posts there again, so keep an eye out for a new fresh Hugo site.

Until then, here is an exhaustive list of the changes that have been made since October.

• Update PR template with updated final pruning date (today -- repo is now 85MB) by @potatoqualitee in #8637
• Bug Fix 8626 Export-DbaUser by @potatoqualitee in #8641
• Add Certificate and CertificateName aliases for EncryptorName by @potatoqualitee in #8653
• Fix Copy-DbaSysDbUserObject to include indexes by @sqlslinger in #8668
• Add 2022 support by @potatoqualitee in #8682
• Add force on encryption commands to auto create cert with specified encryptor name by @potatoqualitee in #8683
• Install-DbaInstance - drive path helper by @potatoqualitee in #8684
• Address SQL Server 2022 issue with Test-DbaDbCompatibility by @wsmelton in #8706
• Create Azure Automation Test and execute it from GitHub Actions by @potatoqualitee in #8709
• Add try/catch for containers without the hostname command by @potatoqualitee in #8710
• Enable Set-DbaDbCompatibility to support SQL Server 2022 by @sanderstad in #8717
• Find-DbaInstance - Correct SqlConnect check, update test to not be Appveyor specific by @wsmelton in #8725
• Update dbatools.library and dbatools.core.library dependency versions by @potatoqualitee in #8734
• Reenable Azure Automation Test by @potatoqualitee in #8736
• Set-DbaDbCompatability - breaking change, code cleanup, add integration testing by @wsmelton in #8724
• Install-DbaInstance - Support SQL Server 2022 by @andreasjordan in #8735
• Rename directories to align with better practices by @potatoqualitee in #8737
• Fix DAC alerts and errors by @potatoqualitee in #8738
• Remove install.ps1 by @potatoqualitee in #8740
• Remove dbatools.core.library dependency, use only dbatools.library by @potatoqualitee in #8741
• Register-DbatoolsConfig - Add example that shows -PassThru by @jpomfret in #8758
• Update dbatools-buildref-index.json - multiple security updates + CUs for SQL 2019/2022 by @MikeyBronowski in #8760
• Test-DbaSpn - Remove the version lookup by @wsmelton in #8779
• Invoke-DbaBalanceDataFiles: fix for VLDBs by @lancasteradam in #8776
• Update Add-DbaExtendedProperty.ps1 - removed examples from Get* function as they are not valid here by @MikeyBronowski in #8786
• Get-DbaDbSchema: returning standard properties on the return object by @lancasteradam in #8775
• Get-DbaDbDbccOpenTran: Add DatabaseId to the return object by @lancasteradam in #8781
• Get-DbaDbCompression: Add DatabaseId to the return object by @lancasteradam in #8769
• Add new function - Invoke-DbaDbAzSqlTips by @jpomfret in #8755
• Add ARM64 Self-Hosted Runner by @potatoqualitee in #8788
• Add support for geometry/geography/hierarchyid types by @potatoqualitee in #8789
• New-DbaConnectionString - Support older compatibility by @potatoqualitee in #8791
• Allow disabling logging, TEPP, and maintenance by @wsmelton in #8792
• Export credential by @ACALVETT in #8794
• BugFix for Install-DbaInstance.ps1 NoPendingRenameCheck by @kerneldba in #8802
• Install-DbaMultiTool: add sp_help_revlogin to script list by @lowlydba in #8804
• docs: fix template typo by @lowlydba in #8806
• Install-DbaInstance: Fix for using default Feature parameter with SQL Server 2022 by @andreasjordan in #8812
• Update dbatools-buildref-index.json - SQL 2022 CU2 by @MikeyBronowski in #8813
• Updates to devcontainer configuration by @wsmelton in #8823
• New-DbaDbSnapshot - Support special characters in database name by @niphlod in #8830
• Implementing Test-DbaPath for Testing Copy Folder for Log Shipping Secondary by @sqldeployhelmet in #8826
• Set-DbaNetworkCertificate: Try to determine key algorithm and use appropriate extension class by @rose-a in #8818
• New-DbaDbUser: Refactor and added contained user creation by @sqlarticles in #8827
• Contributing guide update by @wsmelton in #8822
• Fix: Copy-DbaDatabase: prevent dropping of destination databases if destination is the source by @potatoqualitee in #8831
• Find-DbaOrphanedFile - Fix path in non-Windows by @potatoqualitee in #8835
• Skip Setting Default Log Shipping Monitor by @sqldeployhelmet in #8832
• Attempt to resolve default shell issue in devcontainers by @potatoqualitee in #8837
• Write-HostColor - Fix issue in Linux by @potatoqualitee in #8839
• Added Filter functionality to Get-DbaDbUserDefinedTableType by @sqlarticles in #8834
• Add back SSIS commands for non-core PS by @potatoqualitee in #8843
• Sync-DbaAvailabilityGroup - Show details for objects being synced when using -WhatIf by @potatoqualitee in #8844
• Get-DbaLastGoodCheckDb - Support Azure by @potatoqualitee in #8836
• New...

v1.1.142

What's Changed

• Get-DbaAgBackupHistory - Add LsnSort by @TakeshiKovacs in #8604
• Get-DbaDbCertificate: Add DatabaseId to the return object by @lancasteradam in #8605

New Contributors

• @TakeshiKovacs made their first contribution in #8604

Full Changelog: v1.1.141...v1.1.142

v1.1.141

What's Changed

• Import-DbaCsv - Unlock CSV file after import by @MarkPflug in #8596
• Get-DbaDbBackupHistory: Add DatabaseId to the return object by @potatoqualitee in #8597
• Get-DbaDbView - Fix for missing InstanceName by @andreasjordan in #8601
• Update-DbaMaintenanceSolution - Fix for case-sensitive database name by @andreasjordan in #8600

Full Changelog: v1.1.140...v1.1.141