dbatools | PowerShell Ecosystem Directory

Bot releases are hidden (Show)

dbatools - v2.1.20 Latest Release

Published by potatoqualitee 3 months ago

What's Changed

Security updates for SQL 2022, 2019, 2017, 2016 by @MikeyBronowski in https://github.com/dataplat/dbatools/pull/9422
Get-DbaDbStoredProcedure: Moved Test-Bound -ParameterName ExcludeSystemSp outside of nested loop by @ReeceGoding in https://github.com/dataplat/dbatools/pull/9419
Get-DbaDbUdf ExcludeSystemUdf correct logic by @pollusb in https://github.com/dataplat/dbatools/pull/9417
Get-DbaPermission does not process DENY by @pollusb in https://github.com/dataplat/dbatools/pull/9416
ExcludeSystemUser correct logic in Get-DbaDbUser by @pollusb in https://github.com/dataplat/dbatools/pull/9415
Update tests to be able to run them outside of AppVeyor (part 2) by @andreasjordan in https://github.com/dataplat/dbatools/pull/9413

Full Changelog: https://github.com/dataplat/dbatools/compare/v2.1.19...v2.1.20

dbatools - v2.1.19

Published by potatoqualitee 4 months ago

yet another @andreasjordan release 😅 thank you greatly!

What's Changed

New-DbaDbUser: Refactoring and bugfixing by @andreasjordan in https://github.com/dataplat/dbatools/pull/9386
Always use same description for EnableException by @andreasjordan in https://github.com/dataplat/dbatools/pull/9395
Get-DbatoolsError: Use FullyQualifiedErrorId to filter $global:error by @andreasjordan in https://github.com/dataplat/dbatools/pull/9397
Add MSA example by @ben-thul in https://github.com/dataplat/dbatools/pull/9400
Tests: Use Force while importing module to export aliases by @andreasjordan in https://github.com/dataplat/dbatools/pull/9404
Get-DbaDbDetachedFileInfo: Added new versions by @andreasjordan in https://github.com/dataplat/dbatools/pull/9407
Fix .Query() and .Invoke() on server for special connections and enhance exception text by @andreasjordan in https://github.com/dataplat/dbatools/pull/9410
Get- and Copy-DbaDbQueryStoreOption: Fix DBNull issue and add missing Notes property by @andreasjordan in https://github.com/dataplat/dbatools/pull/9409
Update tests to be able to run them outside of AppVeyor by @andreasjordan in https://github.com/dataplat/dbatools/pull/9406
Write-DbaDbTableData: Fix for connections to Azure SQL Database with AccessToken by @andreasjordan in https://github.com/dataplat/dbatools/pull/9401
Export-DbaUser - Refactor T-SQL User-Role Scripting to Eliminate Dependencies by @0x7FFFFFFFFFFFFFFF in https://github.com/dataplat/dbatools/pull/9232

Full Changelog: https://github.com/dataplat/dbatools/compare/v2.1.18...v2.1.19

dbatools - v2.1.18

Published by potatoqualitee 4 months ago

What's Changed

Fix for ConvertTo-DbaDataTable tests by @jpomfret in https://github.com/dataplat/dbatools/pull/9384
Update dbatools-buildref-index.json SQL2019 CU27 by @MikeyBronowski in https://github.com/dataplat/dbatools/pull/9393
Get-DbaRegServer.ps1: Added Wildcard by @ReeceGoding in https://github.com/dataplat/dbatools/pull/9391
New-DbaAgentSchedule: Fix issues with testing for correct dates and times by @andreasjordan in https://github.com/dataplat/dbatools/pull/9389

Full Changelog: https://github.com/dataplat/dbatools/compare/v2.1.17...v2.1.18

dbatools - v2.1.17

Published by potatoqualitee 4 months ago

What's Changed

Import Tests - Add macos 14, which is arm64 by @potatoqualitee in https://github.com/dataplat/dbatools/pull/9365
better docs rendering, aligned with docs page by @niphlod in https://github.com/dataplat/dbatools/pull/9377
Install-DbaFirstResponderKit - Use new script names by @andreasjordan in https://github.com/dataplat/dbatools/pull/9372
Get-DbaProcess: Fix for empty most_recent_sql_handle by @andreasjordan in https://github.com/dataplat/dbatools/pull/9375
Support OwnerLoginName in New-DbaAgentSchedule by @david-garcia-garcia in https://github.com/dataplat/dbatools/pull/9370
Connect-DbaInstance: Fix problems with DAC by @andreasjordan in https://github.com/dataplat/dbatools/pull/9376
New-DbaAgentJobStep: Fix for using DatabaseUser by @andreasjordan in https://github.com/dataplat/dbatools/pull/9380

Full Changelog: https://github.com/dataplat/dbatools/compare/v2.1.16...v2.1.17

dbatools - v2.1.16

Published by potatoqualitee 4 months ago

What's Changed

Install-DbaInstance: Enable Instant File Initialization using setup.exe parameter by @andreasjordan in https://github.com/dataplat/dbatools/pull/9358
Invoke-DbaDbLogShipping: Remove Credential from New-Item by @andreasjordan in https://github.com/dataplat/dbatools/pull/9359
Backup-DbaDbMasterKey - Output filename property with file extention by @andreasjordan in https://github.com/dataplat/dbatools/pull/9360
ConvertTo-DbaDataTable handle Dataplat.Dbatools.Utility.DbaDateTime as an array by @jpomfret in https://github.com/dataplat/dbatools/pull/9361
Write-DbaDbTableData - Fail AutoCreateTable if no column definition available by @andreasjordan in https://github.com/dataplat/dbatools/pull/9362

Full Changelog: https://github.com/dataplat/dbatools/compare/v2.1.15...v2.1.16

dbatools - v2.1.15

Published by potatoqualitee 5 months ago

What's Changed

Update Set-DbaNetworkCertificate to work with PowerShell Core when using RSA certificates by @mwilsonin in https://github.com/dataplat/dbatools/pull/9342
New Support for Contained Availability Groups by @serenefiresiren in https://github.com/dataplat/dbatools/pull/9345
Backup-DbaDatabase : add a new switch parameter "NoAppendDbNameInPath" to prevent dbname systematically appended at the end of backup path by @rferraton in https://github.com/dataplat/dbatools/pull/9348
New-DbaAvailabilityGroup: Add support for contained availability groups by @DorBreger in https://github.com/dataplat/dbatools/pull/9352
ConvertTo-DbaDataTable - Fix DbaDateTime issue by @potatoqualitee in https://github.com/dataplat/dbatools/pull/9353
Update dbatools-buildref-index.json SQL 2022 CU13 by @MikeyBronowski in https://github.com/dataplat/dbatools/pull/9354

New Contributors

@mwilsonin made their first contribution in https://github.com/dataplat/dbatools/pull/9342
@serenefiresiren made their first contribution in https://github.com/dataplat/dbatools/pull/9345
@rferraton made their first contribution in https://github.com/dataplat/dbatools/pull/9348
@DorBreger made their first contribution in https://github.com/dataplat/dbatools/pull/9352

Full Changelog: https://github.com/dataplat/dbatools/compare/v2.1.14...v2.1.15

dbatools - v2.1.14

Published by potatoqualitee 6 months ago

Update dbatools library to update RestSharp which had the previous CVE.

Full Changelog: https://github.com/dataplat/dbatools/compare/V2.1.13...v2.1.14

dbatools - V2.1.13

Published by potatoqualitee 6 months ago

This is the official Andreas Jordan release 😅

What's Changed

Get-DbaProcess - Add information about endpoint and DAC by @andreasjordan in https://github.com/dataplat/dbatools/pull/9304
Connect-DbaInstance - Connect DAC to test connection as soon as possible by @andreasjordan in https://github.com/dataplat/dbatools/pull/9305
Install-DbaInstance - Fix issue with MachineLearning by @andreasjordan in https://github.com/dataplat/dbatools/pull/9312
Update buildref by @potatoqualitee in https://github.com/dataplat/dbatools/pull/9323
Copy-DbaCredential - Force DAC as it is needed for decryption by @andreasjordan in https://github.com/dataplat/dbatools/pull/9306
Get-DbaStartupParameter - Remove fixed typing of variables that may change their type by @andreasjordan in https://github.com/dataplat/dbatools/pull/9309
Set-DbaTcpPort - Support multiple ports by @andreasjordan in https://github.com/dataplat/dbatools/pull/9310
Install-DbaDarlingData - Include new procedures by @andreasjordan in https://github.com/dataplat/dbatools/pull/9311
Update-SqlPermission (used by Copy-DbaLogin) - Fix for using LoginRenameHashtable together with user different to login by @andreasjordan in https://github.com/dataplat/dbatools/pull/9313
Backup-DbaDatabase - Use Stop-Function to support EnableException for unverified databases by @andreasjordan in https://github.com/dataplat/dbatools/pull/9317
New-DbaComputerCertificate - Only use MonthsValid for self-signed certificates by @andreasjordan in https://github.com/dataplat/dbatools/pull/9318
Update dbatools-buildref-index.json SQL2019 CU26 by @MikeyBronowski in https://github.com/dataplat/dbatools/pull/9324
Add-DbaDbRoleMember - Add support for adding roles to roles by @andreasjordan in https://github.com/dataplat/dbatools/pull/9319
New-DbaDbTable - Fix some issues by @andreasjordan in https://github.com/dataplat/dbatools/pull/9314
Connect-DbaInstance - Open connection to get CurrentDatabase by @andreasjordan in https://github.com/dataplat/dbatools/pull/9308

Full Changelog: https://github.com/dataplat/dbatools/compare/v2.1.12...V2.1.13

dbatools - v2.1.12

Published by potatoqualitee 7 months ago

What's Changed

Get-DbaBackupInformation is not reading values for "IsCopyOnly" attribute. by @david-garcia-garcia in https://github.com/dataplat/dbatools/pull/9294
Update-ServiceStatus - fix cross-domain issue by changing ComputerName to PSComputerName by @fuixx217 in https://github.com/dataplat/dbatools/pull/9288
Get-DbaLogin - clean up old code causing issues by @jpomfret in https://github.com/dataplat/dbatools/pull/9291
change splatting to remove from docs by @jpomfret in https://github.com/dataplat/dbatools/pull/9292
Find-DbaInstance, help more markdown-compatible by @niphlod in https://github.com/dataplat/dbatools/pull/9299
Add-AgDatabase, shorter Example by @niphlod in https://github.com/dataplat/dbatools/pull/9298

New Contributors

@fuixx217 made their first contribution in https://github.com/dataplat/dbatools/pull/9288

Full Changelog: https://github.com/dataplat/dbatools/compare/v2.1.11...v2.1.12

dbatools - v2.1.11

Published by potatoqualitee 7 months ago

What's Changed

changed casing on contributing.md by @KennyNeal in https://github.com/dataplat/dbatools/pull/9269
Export-DbaServerRole: Fix case in sql to fix issues on case sensitive instances by @andreasjordan in https://github.com/dataplat/dbatools/pull/9271
Install-DbaInstance - Enable installation in root folder by @andreasjordan in https://github.com/dataplat/dbatools/pull/9272
Update Format-DbaBackupInformation.ps1 by @0x7FFFFFFFFFFFFFFF in https://github.com/dataplat/dbatools/pull/9277
Select-DbaBackupInformation - fixed example by @0x7FFFFFFFFFFFFFFF in https://github.com/dataplat/dbatools/pull/9276
Remove-DbaReplSubscription - Typo fix in Synopsis by @DiHo78 in https://github.com/dataplat/dbatools/pull/9279
buildref: included CU12 for 2022 by @niphlod in https://github.com/dataplat/dbatools/pull/9278
Get-DbaReplPublication - fix example by @DiHo78 in https://github.com/dataplat/dbatools/pull/9274

Full Changelog: https://github.com/dataplat/dbatools/compare/v2.1.10...v2.1.11

dbatools - v2.1.10

Published by potatoqualitee 7 months ago

THIS RELEASE ADDRESSES TWO CVE'S

This update addresses two CVE's, one in Microsoft.Data.SqlClient and one in Azure.Identity. Thanks to @garyhampson for the update on dbatools.library https://github.com/dataplat/dbatools.library/pull/7

See this announcement from Microsoft for more details.

Essentially:

If you are using Microsoft.Data.SqlClient, anywhere (.NET Core, .NET 6/7/8, .NET Framework) and you are using a version that is vulnerable you must update your NuGet package reference to an updated version: 2.1.7, 3.1.5, 4.0.5, or 5.1.3

An updated version of Microsoft.Data.SqlClient, version 5.1.4, was also released that upgrades the Azure.Identity dependency version to 1.10.3 , which addresses CVE-2023-36414 in that library. (release notes) (download)

What's Changed

Added documentation for PR #6777 (Query Store Set and Get functions shouldn't try to get data from model) by @ReeceGoding in https://github.com/dataplat/dbatools/pull/9266
Skip Failing Replication Tests by @potatoqualitee in https://github.com/dataplat/dbatools/pull/9268
update dbatools library by @potatoqualitee in https://github.com/dataplat/dbatools/pull/9267
Install-DbaMaintenanceSolution does not work inside a container by @david-garcia-garcia in https://github.com/dataplat/dbatools/pull/9252

New Contributors

@david-garcia-garcia made their first contribution in https://github.com/dataplat/dbatools/pull/9252

Full Changelog: https://github.com/dataplat/dbatools/compare/v2.1.9...v2.1.10

dbatools - v2.1.9

Published by potatoqualitee 7 months ago

What's Changed

Project readme update - update command count reference by @0x7FFFFFFFFFFFFFFF in https://github.com/dataplat/dbatools/pull/9228
Fix minor typo in CONTRIBUTING.md by @ben-thul in https://github.com/dataplat/dbatools/pull/9260
fix: Set-DbaAgentSchedule should check for not null on enddate by @lowlydba in https://github.com/dataplat/dbatools/pull/9257
Copy-DbaCredential: Fix for credentials with square brackets in it's name - Issue #9242 by @ibaxo in https://github.com/dataplat/dbatools/pull/9243
New-DbaComputerCertificate, options for Algorithm and Period validity by @daniel-merchant in https://github.com/dataplat/dbatools/pull/9264
Multiple Functions - Remove Stop-Function ErrorRecord parameter use outside of try-catch blocks by @0x7FFFFFFFFFFFFFFF in https://github.com/dataplat/dbatools/pull/9227
Restore-DbaDatabase - improve warning output for standby mode databases by @0x7FFFFFFFFFFFFFFF in https://github.com/dataplat/dbatools/pull/9230

New Contributors

@ibaxo made their first contribution in https://github.com/dataplat/dbatools/pull/9243

Full Changelog: https://github.com/dataplat/dbatools/compare/v2.1.8...v2.1.9

dbatools - v2.1.8

Published by potatoqualitee 8 months ago

What's Changed

Update dbatools-buildref-index.json SQL 2019 cu25 by @MikeyBronowski in https://github.com/dataplat/dbatools/pull/9244
Update Get-DbaWaitStatistic.ps1 to be in sync with the Paul Randal script it copies from (fixes 9251) by @ReeceGoding in https://github.com/dataplat/dbatools/pull/9249
Invoke-DbaQuery, fixed example for TVP by @niphlod in https://github.com/dataplat/dbatools/pull/9247

New Contributors

@ReeceGoding made their first contribution in https://github.com/dataplat/dbatools/pull/9249

Full Changelog: https://github.com/dataplat/dbatools/compare/v2.1.7...v2.1.8

dbatools - v2.1.7

Published by potatoqualitee 9 months ago

What's Changed

Get-DbaAgentSchedule: Fix description output for hourly jobs by @andreasjordan in https://github.com/dataplat/dbatools/pull/9194
Copy-DbaDbTableData: Add missing database parameter when connecting to target by @andreasjordan in https://github.com/dataplat/dbatools/pull/9193
Added several security patches related to CVE-2024-0056 + SQL 2022 CU11 by @MikeyBronowski in https://github.com/dataplat/dbatools/pull/9207
Update Set-DbaDbQueryStoreOption.ps1 by @tominyorks in https://github.com/dataplat/dbatools/pull/9205
Grant-DbaAgPermission - Update Type description by @0x7FFFFFFFFFFFFFFF in https://github.com/dataplat/dbatools/pull/9201
Invoke-DbaQuery, support reuse of parameters by @niphlod in https://github.com/dataplat/dbatools/pull/9221
Update-DbaInstance: Fix typo in warning message by @pluim003 in https://github.com/dataplat/dbatools/pull/9213
Get-DbaCmObject - Improved CIM ErrorHandling by @FriedrichWeinmann in https://github.com/dataplat/dbatools/pull/9107
Copy-DbaDatabase - doc update by @0x7FFFFFFFFFFFFFFF in https://github.com/dataplat/dbatools/pull/9200
Update Get-DbaFile.ps1 by @0x7FFFFFFFFFFFFFFF in https://github.com/dataplat/dbatools/pull/9202

New Contributors

@tominyorks made their first contribution in https://github.com/dataplat/dbatools/pull/9205
@pluim003 made their first contribution in https://github.com/dataplat/dbatools/pull/9213

Full Changelog: https://github.com/dataplat/dbatools/compare/v2.1.6...v2.1.7

dbatools - v2.1.6

Published by potatoqualitee 10 months ago

What's Changed

Update dbatools-buildref-index.json SQL 2022 CU10 by @MikeyBronowski in https://github.com/dataplat/dbatools/pull/9167
Get-DbaPermission - fix returning Null in field 'Securable' by @uncletimmy3 in https://github.com/dataplat/dbatools/pull/9171
SQL Server 2019 CU 24 by @rwestMSFT in https://github.com/dataplat/dbatools/pull/9185

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

dbatools - v2.1.5

Published by potatoqualitee 12 months ago

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

dbatools - v2.1.4

Published by potatoqualitee about 1 year ago

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

dbatools - v2.1.3

Published by potatoqualitee about 1 year ago

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