github.com/dataplat/dbatools commits | Ecosyste.ms: OpenCollective

changed casing on contributing.md (#9269)

1934a6973a0185810fff2963185290a761be1942 authored 10 months ago by KennyNeal <[email protected]>

Update dbatools-index.json

ed7f53d81f28cea1e4b691f2d92b8b6042802d12 authored 10 months ago by Chrissy LeMaire <[email protected]>

Install-DbaMaintenanceSolution does not work inside a container (#9252)

Co-authored-by: Chrissy LeMaire <[email protected]>

ccaa682d510942fa3c2393268ae2bd449dbb0268 authored 10 months ago by Davvid <[email protected]>

update dbatools library (#9267)

d23f1b3b2c85fdfc899169ffbb11fc321c9b34b9 authored 10 months ago by Chrissy LeMaire <[email protected]>

Merge branch 'development' of https://github.com/dataplat/dbatools into development

9588ee493935910b48387800d91dd47f3e68993d authored 10 months ago by Chrissy LeMaire <[email protected]>

PULL_REQUEST_TEMPLATE -- remove dated warning

c62e0605267af445a0c8f63ec292e293ada5485a authored 10 months ago by Chrissy LeMaire <[email protected]>

Skip Failing Replication Tests (#9268)

62d7a77349b399c3cbb53951309b523d71339267 authored 10 months ago by Chrissy LeMaire <[email protected]>

Added documentation for PR #6777 (Query Store Set and Get functions shouldn't try to get data from model) (#9266)

524b0991064f4062e0245ffb2661b5acb8d8a9f8 authored 10 months ago by Reece Goding <[email protected]>

2.1.9

2d35be306005ca247341ac4fdcea5fb1c87b93b7 authored 10 months ago by Chrissy LeMaire <[email protected]>

Restore-DbaDatabase - improve warning output for standby mode databases (#9230)

Co-authored-by: Shawn Melton <[email protected]>

da391a942db8e3cc02401f5735d3f8987ee0c558 authored 10 months ago by 0x7FFFFFFFFFFFFFFF <[email protected]>

Multiple Functions - Remove Stop-Function ErrorRecord parameter use outside of try-catch blocks (#9227)

d50b8120d2bcd6748087a1da98a2791dc9393f4b authored 10 months ago by 0x7FFFFFFFFFFFFFFF <[email protected]>

New-DbaComputerCertificate, options for Algorithm and Period validity (#9264)

Co-authored-by: Daniel Merchant <[email protected]>

6e96ba8908706770fe7e4eee125ea24fdfdc8bed authored 10 months ago by daniel-merchant <[email protected]>

Copy-DbaCredential: Fix for credentials with square brackets in it's name - Issue #9242 (#9243)

Co-authored-by: Ivan Vacho <[email protected]>

e72e1a4e458338cfbeae7615d6b2ef86481ce078 authored 10 months ago by ibaxo <[email protected]>

Set-DbaAgentSchedule should check for not null on enddate (#9257)

54c8d25efd199a5af7686567bf4c9ed3bcb73b5f authored 10 months ago by John McCall <[email protected]>

Fix minor typo in CONTRIBUTING.md (#9260)

Co-authored-by: Ben Thul <[email protected]>

9d8571e5949fe646a8991af08c75d0eb625fae6e authored 10 months ago by Ben Thul <[email protected]>

Project readme update - update command count reference (#9228)

Co-authored-by: Shawn Melton <[email protected]>
Co-authored-by: Jess ...

a160e261ad508b6e778ed5fabbcc51a702146c6a authored 11 months ago by 0x7FFFFFFFFFFFFFFF <[email protected]>

2.1.8

71920cb9245349581e70a54eed447959a8d34ba1 authored 11 months ago by Chrissy LeMaire <[email protected]>

Invoke-DbaQuery, fixed example for TVP (#9247)

be3976daf25bb16e9c0b98903cd811906683ce6d authored 11 months ago by Simone Bizzotto <[email protected]>

Update Get-DbaWaitStatistic.ps1 to be in sync with the Paul Randal script it copies from (fixes 9251) (#9249)

e13f779f8ccdc38c4fbda3c731243d2439af2c6f authored 11 months ago by Reece Goding <[email protected]>

Update dbatools-buildref-index.json SQL 2019 cu25 (#9244)

b74083c6e9b1c88bc7c884a707fc2f4b02e02762 authored 11 months ago by Mikey Bronowski <[email protected]>

2.1.7

419963993aadae04914b8686641b251f2a558be3 authored 12 months ago by Chrissy LeMaire <[email protected]>

Update Get-DbaFile.ps1 (#9202)

3d0b877ff7485018a61c9d4a5ad6df7854057d7d authored 12 months ago by 0x7FFFFFFFFFFFFFFF <[email protected]>

Copy-DbaDatabase - doc update (#9200)

Co-authored-by: Chrissy LeMaire <[email protected]>
Co-authored-by: Shawn...

b27370ea4102548497e572e71b37e1e6759177f1 authored 12 months ago by 0x7FFFFFFFFFFFFFFF <[email protected]>

Get-DbaCmObject - Improved CIM ErrorHandling (#9107)

f6d99c0c08ef1315a49ef7a9c4e7e77ca6a95384 authored 12 months ago by Friedrich Weinmann <[email protected]>

Update-DbaInstance: Fix typo in warning message (#9213)

502a3086c00be72bbc72504ffcc45b0c4503e0b7 authored 12 months ago by Dick Pluim <[email protected]>

Invoke-DbaQuery, support reuse of parameters (#9221)

11b251a11a54ae9c81630639c7990a8a2a54bed9 authored 12 months ago by Simone Bizzotto <[email protected]>

Grant-DbaAgPermission - Update Type description (#9201)

e09b82bed2b775da1cb149dfb9209f598f97b5ae authored 12 months ago by 0x7FFFFFFFFFFFFFFF <[email protected]>

Update Set-DbaDbQueryStoreOption.ps1 (#9205)

56d716a32a0007d3963e1414ce8a27ff656b4ac3 authored 12 months ago by Tom Rees <[email protected]>

Added several security patches related to CVE-2024-0056 + SQL 2022 CU11 (#9207)

5a8b8dc26efb428dfb494f987f7e13d3faf249d1 authored 12 months ago by Mikey Bronowski <[email protected]>

Copy-DbaDbTableData: Add missing database parameter when connecting to target (#9193)

e6941ec910a81a6afc94a3f15170d09e5d7ff84f authored about 1 year ago by Andreas Jordan <[email protected]>

Get-DbaAgentSchedule: Fix description output for hourly jobs (#9194)

b36ddcf68783c30de8c1f32306ca16928e22b32c authored about 1 year ago by Andreas Jordan <[email protected]>

2.1.6 update

b4ce4b332aac0af0a33080ea4f5089381daacb10 authored about 1 year ago by Chrissy LeMaire <[email protected]>

remove arm64 for now

7ee4b00241ccf5f2c8727039e32b9e0b0df53e78 authored about 1 year ago by Chrissy LeMaire <[email protected]>

SQL Server 2019 CU 24 (#9185)

e6a30eed501f5ba858af0606bf2c9015bea83a6c authored about 1 year ago by Randolph West MSFT <[email protected]>

Get-DbaPermission - fix returning Null in field 'Securable' (#9171)

663f450b6fe07423e646ec375a2371e69aec4bca authored about 1 year ago by uncletimmy3 <[email protected]>

Update dbatools-buildref-index.json SQL 2022 CU10 (#9167)

6872543e46ecffeb826a879b76b96961614a3d3a authored about 1 year ago by Mikey Bronowski <[email protected]>

Fix non-Windows Import Errors (#9158)

7edecc836a80fc7fef0e552154aab881bc47bef2 authored about 1 year ago by Chrissy LeMaire <[email protected]>

duplicate

7d2d194916016ca9063701947c0a7ee638746da2 authored about 1 year ago by Chrissy LeMaire <[email protected]>

Config - do not attempt HKCU on macOS or Linux (#9157)

8b82020ac08541ed9270de2be924d5688d8bb9d3 authored about 1 year ago by Chrissy LeMaire <[email protected]>

Install-DbaInstance - Fix for installing MachineLearning in SQL Server 2022 (#9153)

ee81aac86a1dbe440303cb9f6851470fd069d4cc authored about 1 year ago by Chrissy LeMaire <[email protected]>

Encryption Check - Add support for string settings (#9154)

f73dede54cc47d0a48c306105f904c22e57f7e1d authored about 1 year ago by Chrissy LeMaire <[email protected]>

Backup-DbaDatabase - allow users to specify no compression (#9151)

21aa6ff74155d6ef537fd461d9eda82fbebe21a4 authored about 1 year ago by Ben Thul <[email protected]>

New-DbaEndPoint - Fix Auth Order Param issue (#9155)

60ae3eb1e52ae6178b2c8e337dedbb0fe2a7b6fd authored about 1 year ago by Chrissy LeMaire <[email protected]>

2.1.5

714219ca70578fd032c8aa31d7054234e76d5b61 authored about 1 year ago by Chrissy LeMaire <[email protected]>

Update Set-DbaAgentJobStep Retry null check (#9148)

54ce4c6fb246475520b37cf6653d2cccd14c0e6d authored about 1 year ago by tyndur <[email protected]>

Set-DbaDbCompatbility - Fix for using piped input and don't trust master compatibility level (#9146)

368ea57efc8e01959f226b0f9643972bfec069d6 authored about 1 year ago by Andreas Jordan <[email protected]>

New-DbaEndpoint - New parameter AuthenticationOrder (#9145)

ed4c3ec7d9619650026ad6fae8bf22b5a964edc9 authored about 1 year ago by Andreas Jordan <[email protected]>

Connect-DbaInstance - Change EncryptConnection to a switch with a default of $true (#9143)

f3fad5a8c37de559088a16179c9892841c4c392b authored about 1 year ago by Andreas Jordan <[email protected]>

Add-DbaAgDatabase - Use ExecuteAs with restore to set correct database owner (#9144)

818dd39e15a64d2002cf0203b49f0c4bd7284219 authored about 1 year ago by Andreas Jordan <[email protected]>

Update dbatools-buildref-index.json - Added 11.0.7512 (#9142)

66ed5405a83137167c30b8a416891482808b15e4 authored about 1 year ago by Andreas Jordan <[email protected]>

Update Get-DbaDbBackupHistory.ps1 (#9138)

0f7bb63b4ce0677d3e28552b41aa649e75302a68 authored about 1 year ago by 0x7FFFFFFFFFFFFFFF <[email protected]>

2.1.4

2d66eb885cf5f2adad13725f992473cef48a5769 authored about 1 year ago by Chrissy LeMaire <[email protected]>

SQL Server 2019 and 2022 CUs: Update dbatools-buildref-index.json (#9127)

Co-authored-by: Chrissy LeMaire <[email protected]>

ce7e8a23b2d638749b0bf7fd1d3e7506dcbb002d authored about 1 year ago by Randolph West MSFT <[email protected]>

2.1.3

e52756e48130a633bda82cb12c1b0ceadfc83cf6 authored over 1 year ago by Chrissy LeMaire <[email protected]>

Update dbatools-buildref-index.json Added security updates addressing (#9126)

60d526a5e9c44e67e4cdd3dd2f33a8a36274258a authored over 1 year ago by Mikey Bronowski <[email protected]>

Set-DbaNetworkCertificate - Support localhost and use it as default for SqlInstance (part 2) (#9125)

6d4fea0dd6954a1c57c878931edef22926bb13b0 authored over 1 year ago by Andreas Jordan <[email protected]>

Install-DbaInstance - Use maximum length for random password (#9119)

Co-authored-by: Chrissy LeMaire <[email protected]>

9edc7673424e93c23f60cfad2569bdc1e9c44e54 authored over 1 year ago by Andreas Jordan <[email protected]>

Remove-DbaDatabaseSafely - Fix Exception handling (#9115)

Co-authored-by: Chrissy LeMaire <[email protected]>

f6a2b7ba7daeff8c622bac4e79b8e203626a1d5c authored over 1 year ago by Andreas Jordan <[email protected]>

Invoke-DbaDbDataMasking - Use correct logging command (#9117)

Co-authored-by: Chrissy LeMaire <[email protected]>

a2e11f9028f8ff729252b55665358b8948952f1b authored over 1 year ago by Andreas Jordan <[email protected]>

Copy-DbaDbTableData - Enable failback to default group (#9122)

166663b13313e488729f77e300d404dbb7cd8ed2 authored over 1 year ago by Ben Thul <[email protected]>

Set-DbaDbCompression, prefer online rebuilds where possible (#9118)

0bfa72b5591561394c7b6a7dda4113e743c41478 authored over 1 year ago by Simone Bizzotto <[email protected]>

Set-DbaNetworkCertificate - Support localhost and use it as default for SqlInstance (#9098)

44fd060cd365029f4999e718728018680177341a authored over 1 year ago by Christian Ritter <[email protected]>

remove arm64, sql containerno longer supported

f3798e201e087863d45aa8acacdb7d647b2277e7 authored over 1 year ago by Chrissy LeMaire <[email protected]>

Add repl commands to the psm1 (#9124)

e89435ad7367f9252f0e193ef8126788b9a82a08 authored over 1 year ago by Jess Pomfret <[email protected]>

Get-DbaAgListener - Fix filtering for listener names (#9108)

73ff74e4efe569025bd4c544837ff71b790c8ed7 authored over 1 year ago by Andreas Jordan <[email protected]>

Remove-DbaDatabaseSafely - Fix usage of Stop-Function (#9109)

Co-authored-by: Chrissy LeMaire <[email protected]>

4829c78860dd50a63d879892366f15ca26a40c6d authored over 1 year ago by Andreas Jordan <[email protected]>

2.1.2

c253ff5e44dfb6193c5cc63e3e898143371d9fa3 authored over 1 year ago by Chrissy LeMaire <[email protected]>

Add-DbaAgDatabase - Fix stale cache issue (#9101)

Co-authored-by: Chrissy LeMaire <[email protected]>

5d27f6094e5cd14bb571eebbeff78b45dabaef89 authored over 1 year ago by Andreas Jordan <[email protected]>

Update dbatools-index.json

5f774b920a10c96149c7e042d11a2515a1e894eb authored over 1 year ago by Chrissy LeMaire <[email protected]>

Fix stale cache issue in Add-DbaAgDatabase (#9094)

Signed-off-by: Klaus Frank <[email protected]>
Co-authored-by: Chrissy LeM...

447ae1e8ec36a3b2499916952a5746d2551a9945 authored over 1 year ago by Klaus Frank <[email protected]>

update deps, update module version

f7c8a4ecb7ac423c5e4a59b114c854c47d85570a authored over 1 year ago by Chrissy LeMaire <[email protected]>

Disable New-DbaDbSnapshot tests for now

776a016748ee473ff498ee87f40de49c5a38bccf authored over 1 year ago by Chrissy LeMaire <[email protected]>

Test-DbaConnection - Fix for wrong data in failed connections (#9096)

59e3476e5f9c8e9d6d659a5def2823e97ebda847 authored over 1 year ago by Harrison Lond <[email protected]>

Test-DbaLoginPassword, use parametrized query (#9097)

e344ef8e887627abec6a0a550657f8706a569929 authored over 1 year ago by Simone Bizzotto <[email protected]>

Add replication support to dbatools! (#8958)

Co-authored-by: ClaudioESSilva <[email protected]>
Co-authored-by: Shawn Melton <11204251...

85c8f21da28eae59cf5f34130de1dabcececc1a0 authored over 1 year ago by Jess Pomfret <[email protected]>

2.1.0

0a7ef7477f61fcc3ae77a55e97b1a76b3cc2a92f authored over 1 year ago by Chrissy LeMaire <[email protected]>

Copy-DbaDatabase - Use correct variable for testing for same database (#9032)

Co-authored-by: Shawn Melton <[email protected]>
Co-authored-by: Chris...

25d6d0ae1e9687b1796f034dd4b89789ed5f98b2 authored over 1 year ago by Andreas Jordan <[email protected]>

New-DbaDbUser - Fix issue that prevented new user creation in all databaess (#9078)

81ebba2b070cdef0450a5c15e9ef61977295b7b6 authored over 1 year ago by sqlarticles <[email protected]>

Find-DbaInstance - Fix regex for UDP Search (#9072)

c984b2e14f9586def9be59b3a7a49a6848f392ff authored over 1 year ago by uncletimmy3 <[email protected]>

added cu8 for 2022 (#9082)

7f5e149311f317e9a40953c1f4d953c0ae27d4ef authored over 1 year ago by Simone Bizzotto <[email protected]>

Add SQL Server 2019 CU22 (#9058)

432aebdff27c9102c56b76dea9ff886b4e663235 authored over 1 year ago by Randolph West MSFT <[email protected]>

Add SQL Server 2022 CU7 (#9056)

214943a476d38da266455ea2a124dd44901d03b0 authored over 1 year ago by Mikey Bronowski <[email protected]>

fix typo in Get-DecryptedObject.ps1 (#9054)

Co-authored-by: Jess Pomfret <[email protected]>

72f8abf8a3095cc3885af89ad468247ccb876915 authored over 1 year ago by Dirk Hondong <[email protected]>

Update dbatools-buildref-index.json (#9034)

1d6f8da5dc1336a1a2059f78301c2919e265909a authored over 1 year ago by Randolph West MSFT <[email protected]>

Improve formatting (#9026)

64cf64aa5649e9ce39b01ad92fce11b0d43a3097 authored over 1 year ago by Andreas Jordan <[email protected]>

Get-DbaProductKey - Continue on error (#9023)

da1ed459ae0c9683e45eb1ddd8d241cb503cff4d authored over 1 year ago by Andreas Jordan <[email protected]>

change backupDate fixes #9024 (#9025)

7df7772c6dde7d725a800b6db870f266d60fb7c6 authored over 1 year ago by Jess Pomfret <[email protected]>

New-DbaAgentSchedule - Don't allow shorter intervals than 10 seconds (#9020)

0d834691269b7484c580540366aee323ee019adb authored over 1 year ago by Andreas Jordan <[email protected]>

Copy-DbaDatabase - Fix documentation for parameter BackupRestore (#9018)

99c143924aaeb9f7630fc7aea3dd5f3c7da2ffb7 authored over 1 year ago by Andreas Jordan <[email protected]>

Copy-DbaDatabase - Add missing parameter validation (#9002)

Co-authored-by: Andreas Jordan <[email protected]>

fb33da92434458723b36468fff665ac1e75c3565 authored over 1 year ago by Mike Blaszczak <[email protected]>

Copy-DbaSystemDbUserObject - Create schema with correct owner (#9017)

519566ba3ddda3bdba898e69a65ccf9f918d22df authored over 1 year ago by Andreas Jordan <[email protected]>

Convert-DbaIndexToTable - Fix for [n]varchar(max) (#9014)

50becdebf6271ca23f1ed3a4cf5d245e0b2519a5 authored over 1 year ago by Andreas Jordan <[email protected]>

Invoke-DbaDbDataGenerator / Get-DbaRandomizedValue - Fix precision for datatime datatype (#9016)

de6fffcd6627a49ade1ac78f8553231f379755da authored over 1 year ago by Andreas Jordan <[email protected]>

Read-DbaXEFile - Refactoring to get the command working again (#9007)

9a49a6f6774c09486abf1fa43137466a062fddb9 authored over 1 year ago by Andreas Jordan <[email protected]>

Copy-DbaDatabase - Set correct database offline on source server when using both -NewName and -SetSourceDatabaseOffline (#9004)

b0942403365877e88569b91745b60fa68b777459 authored over 1 year ago by Andreas Jordan <[email protected]>

Test-DbaDbCompatibility - Determining target compatibility level based on server version (#8992)

e5470352c98296b3666f9d6b75b87042fee61133 authored over 1 year ago by Andreas Jordan <[email protected]>

Copy-DbaSsisCatalog - Fix building IntegrationServices object (#9005)

acc8bb30bd3394984f70bdb064574aaad1021135 authored over 1 year ago by Andreas Jordan <[email protected]>

Get-DbaMemoryUsage - New parameters for regex string to support non US systems (#8976)

b1f2ba8327452f707608c312944a2cc896f45298 authored over 1 year ago by Andreas Jordan <[email protected]>

Update-DbaServiceAccount - Add information about supported services and versions (#8981)

546ea0f2387bf9d1712ab3c63bf692b95ca816a4 authored over 1 year ago by Andreas Jordan <[email protected]>

New-DbaLogShippingPrimaryDatabase / New-DbaLogShippingSecondaryPrimary - Add missing parameter name (#8971)

Co-authored-by: Chrissy LeMaire <[email protected]>

f9b8c0087cc4a56af071c4098d294083b09fb2b2 authored over 1 year ago by Andreas Jordan <[email protected]>