dbatools | PowerShell Ecosystem Directory

Bot releases are visible (Hide)

dbatools - v2.1.0

Published by potatoqualitee about 1 year ago

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

dbatools - v2.0.4

Published by potatoqualitee over 1 year ago

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

dbatools - v2.0.3

Published by potatoqualitee over 1 year ago

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

dbatools - v2.0.2

Published by potatoqualitee over 1 year ago

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

dbatools - v2.0.1

Published by potatoqualitee over 1 year ago

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

dbatools - v2.0.0

Published by potatoqualitee over 1 year ago

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:

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

New Contributors

@sqlslinger made their first contribution in https://github.com/dataplat/dbatools/pull/8668
@kerneldba made their first contribution in https://github.com/dataplat/dbatools/pull/8802
@rose-a made their first contribution in https://github.com/dataplat/dbatools/pull/8818
@sqlarticles made their first contribution in https://github.com/dataplat/dbatools/pull/8827
@ft3411 made their first contribution in https://github.com/dataplat/dbatools/pull/8856
@InDey made their first contribution in https://github.com/dataplat/dbatools/pull/8764

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

dbatools - v1.1.142

Published by potatoqualitee almost 2 years ago

What's Changed

Get-DbaAgBackupHistory - Add LsnSort by @TakeshiKovacs in https://github.com/dataplat/dbatools/pull/8604
Get-DbaDbCertificate: Add DatabaseId to the return object by @lancasteradam in https://github.com/dataplat/dbatools/pull/8605

New Contributors

@TakeshiKovacs made their first contribution in https://github.com/dataplat/dbatools/pull/8604

Full Changelog: https://github.com/dataplat/dbatools/compare/v1.1.141...v1.1.142

dbatools - v1.1.141

Published by potatoqualitee almost 2 years ago