Ecosyste.ms: OpenCollective
An open API service for software projects hosted on Open Collective.
github.com/dataplat/dbatools
🚀 SQL Server automation and instance migrations have never been safer, faster or freer
https://github.com/dataplat/dbatools
update version
76e5c2d32f32dd3540a3b6fefd6f3c8c32c8f18d authored almost 3 years ago
76e5c2d32f32dd3540a3b6fefd6f3c8c32c8f18d authored almost 3 years ago
Restore-DbaDatabase - fix example (#8255)
9cf0cd352c02a2728b602f0fe9d8764c07cdddea authored almost 3 years ago
9cf0cd352c02a2728b602f0fe9d8764c07cdddea authored almost 3 years ago
Set-DbaAgentJobStep: fix documented default for OnFailAction (#8246)
485f68dea6bb3394915aad01c301713f88173300 authored almost 3 years ago
485f68dea6bb3394915aad01c301713f88173300 authored almost 3 years ago
update version
314ad0a7ed1776a483d0c7579b39278a74d88ec3 authored almost 3 years ago
314ad0a7ed1776a483d0c7579b39278a74d88ec3 authored almost 3 years ago
Set-DbaNetworkConfiguration - Only use WMI over WinRM (#8243)
a3579a5ab888e4477c543066a8dc8fb185038de4 authored almost 3 years ago
a3579a5ab888e4477c543066a8dc8fb185038de4 authored almost 3 years ago
Remove-DbaFirewallRule - Fix for using SqlInstance with more that one instance (#8242)
b200df53262feecbbb15e7f2cb401f097342049c authored almost 3 years ago
b200df53262feecbbb15e7f2cb401f097342049c authored almost 3 years ago
update version
9e755414c3e3fd216b7f53c37d27849a7b7162e4 authored almost 3 years ago
9e755414c3e3fd216b7f53c37d27849a7b7162e4 authored almost 3 years ago
New-DbaAgentJob - better performance (#8235)
2cbdda599fa04932e8a993c5ebd86174ffd1fdd6 authored almost 3 years ago
2cbdda599fa04932e8a993c5ebd86174ffd1fdd6 authored almost 3 years ago
Install-DbaInstance - Add support for cluster installation (#8236)
743dcd98122c5e01a2d3da87a587cae383e55b12 authored almost 3 years ago
743dcd98122c5e01a2d3da87a587cae383e55b12 authored almost 3 years ago
Install-DbaMaintenanceSolution: Return SqlInstance as string, not obj (#8239)
b4039abff9516da1b67478c1dab0ecb064c2d355 authored almost 3 years ago
b4039abff9516da1b67478c1dab0ecb064c2d355 authored almost 3 years ago
Get-DbaDatabase - Cleanup test (#8238)
0571e756128c416ac3521b0b6784d53133044528 authored almost 3 years ago
0571e756128c416ac3521b0b6784d53133044528 authored almost 3 years ago
Backup-DbaDatabase - Fix issue with ReplaceInName and piped in databases (#8115)
dc89416207a5333d4130543766d004483de2aa95 authored almost 3 years ago
dc89416207a5333d4130543766d004483de2aa95 authored almost 3 years ago
Copy-DbaDbMail - support for getting mail server passwords - fixes #7824 (#8230)
a19676ef42304388f9c599a6410e64ebdaa82afc authored almost 3 years ago
a19676ef42304388f9c599a6410e64ebdaa82afc authored almost 3 years ago
fix json
26f64c32ad6ffb90f2489e837d2299edf39dba0e authored almost 3 years ago
26f64c32ad6ffb90f2489e837d2299edf39dba0e authored almost 3 years ago
Start-DbaDbEncryption - Fix for encrypting multiple databases at once (#8234)
05f2a6e16cf26a17aa46e460d19b7c72821cd407 authored almost 3 years ago
05f2a6e16cf26a17aa46e460d19b7c72821cd407 authored almost 3 years ago
update version
48041b386334f328d4855221b72dba256ee48aca authored almost 3 years ago
48041b386334f328d4855221b72dba256ee48aca authored almost 3 years ago
Get-DbaDatabase / Compare-DbaCollationSensitiveObject - Removed mandatory from value parameter (#8229)
5cce10b897a14f60428d6fe63330d099df0da5de authored almost 3 years ago
5cce10b897a14f60428d6fe63330d099df0da5de authored almost 3 years ago
New-DbaAgentJob: use Get command to return consistent results (#8233)
8501e94766a6a00eeb8217bbfe87c0bd83d2a03e authored almost 3 years ago
8501e94766a6a00eeb8217bbfe87c0bd83d2a03e authored almost 3 years ago
Install-DbaInstance - Support installation of Failover Cluster Instance (#8221)
b36df173c89fcac7471ba4b35f954ccfb456f6df authored almost 3 years ago
b36df173c89fcac7471ba4b35f954ccfb456f6df authored almost 3 years ago
Backup-DbaDatabase - Avoid reading database (#8224)
b39a001e0076c4b55f47820d64a8f1066a4908a9 authored almost 3 years ago
b39a001e0076c4b55f47820d64a8f1066a4908a9 authored almost 3 years ago
Get-DbaUserPermission - Refactoring again (#8228)
714b4bdd42a4c19d3c290d0a367f0268f7d34bb2 authored almost 3 years ago
714b4bdd42a4c19d3c290d0a367f0268f7d34bb2 authored almost 3 years ago
Invoke-ManagedComputerCommand - Fix to enable retry again (#8226)
13a40eabaa1611d3897345a29a82d3ec6fc517e7 authored almost 3 years ago
13a40eabaa1611d3897345a29a82d3ec6fc517e7 authored almost 3 years ago
update version
e4dd095fd418330f0455f0c0be01b653b7b0f6e4 authored almost 3 years ago
e4dd095fd418330f0455f0c0be01b653b7b0f6e4 authored almost 3 years ago
Temporarily revert Get-DbaUserPermission refactor (#8227)
ebb7b7260fb851fee322656cf70907c7e804701a authored almost 3 years ago
ebb7b7260fb851fee322656cf70907c7e804701a authored almost 3 years ago
update version
aaae06f5004c90774a13acd856e0817fe42c5705 authored almost 3 years ago
aaae06f5004c90774a13acd856e0817fe42c5705 authored almost 3 years ago
Set-DbaNetworkConfiguration - Add parameter IpAddress (#8222)
4111bd1d891c411c77afe38c5a8446ea6e29e154 authored almost 3 years ago
4111bd1d891c411c77afe38c5a8446ea6e29e154 authored almost 3 years ago
Issue #8208 - Query Store tests for msdb and Trace Flags (#8219)
ed7fb661e90da7b841649d750a339dbfe0f342e2 authored almost 3 years ago
ed7fb661e90da7b841649d750a339dbfe0f342e2 authored almost 3 years ago
Copy-DbaDbTableData - doc update correcting parameter reference (#8194)
1663aa9efb7a9c8fcdd7b91ae76672d799fb7516 authored almost 3 years ago
1663aa9efb7a9c8fcdd7b91ae76672d799fb7516 authored almost 3 years ago
Get-DbaUserPermission - Refactoring (#8220)
4e834a7de6680ee8647ae380e4fb51975f69c6ad authored almost 3 years ago
4e834a7de6680ee8647ae380e4fb51975f69c6ad authored almost 3 years ago
update version
faa035890cbc16022c52ca014eca089c8f08db3e authored almost 3 years ago
faa035890cbc16022c52ca014eca089c8f08db3e authored almost 3 years ago
Add DatabaseID to the return object for backup commands (#8204)
07c4dc2682b5072208e1c1e33729541b0eb7ee84 authored almost 3 years ago
07c4dc2682b5072208e1c1e33729541b0eb7ee84 authored almost 3 years ago
Add-DbaAgReplica - Support non-english systems (#8211)
e8361960046b8fe28ef89105c982519527bd8955 authored almost 3 years ago
e8361960046b8fe28ef89105c982519527bd8955 authored almost 3 years ago
Get-DbaRunningJob - Use Refresh to get up to date information (#8201)
4e9fac12b98db39b706906a83d1482a0ef5f24a7 authored almost 3 years ago
4e9fac12b98db39b706906a83d1482a0ef5f24a7 authored almost 3 years ago
Documentation - Fixing a few typos (#8213)
f356de08a70a46817302a171bd896bba6903fcf3 authored almost 3 years ago
f356de08a70a46817302a171bd896bba6903fcf3 authored almost 3 years ago
update version
90e13308a90fb0fc8536fe8b630dedbf2b9cf9cf authored almost 3 years ago
90e13308a90fb0fc8536fe8b630dedbf2b9cf9cf authored almost 3 years ago
Add-DbaAgDatabase - Use ReuseSourceFolderStructure with restore (#8203)
d4138d3fb815133dd7f1602c84ecb95d87d8e5a1 authored almost 3 years ago
d4138d3fb815133dd7f1602c84ecb95d87d8e5a1 authored almost 3 years ago
update version
c3c96c45333c58bbd113b0c6c2a043a5f7ce6e23 authored almost 3 years ago
c3c96c45333c58bbd113b0c6c2a043a5f7ce6e23 authored almost 3 years ago
[Get-DbaDbPartitionScheme] - adds filtering by name (#8162)
ca718a5bcaa41215fd5111f795a5e402f7e1a336 authored almost 3 years ago
ca718a5bcaa41215fd5111f795a5e402f7e1a336 authored almost 3 years ago
[Get-DbaDbPartitionFunction] - adds filtering by name (#8161)
33f39be93b00077f7bfc9e013ba5525b65a54596 authored almost 3 years ago
33f39be93b00077f7bfc9e013ba5525b65a54596 authored almost 3 years ago
Invoke-DbaQuery, introduce noexec (#8196)
48b56363f6c6220fffaafaaf389bc33d475a341e authored almost 3 years ago
48b56363f6c6220fffaafaaf389bc33d475a341e authored almost 3 years ago
update version
e7a2ddf023573a92dda196de5ee2829c819ecdea authored almost 3 years ago
e7a2ddf023573a92dda196de5ee2829c819ecdea authored almost 3 years ago
New-DbaCredential - Able to create without password (#8191)
03a669785a00f848998a42035363df95b7dce6e4 authored almost 3 years ago
03a669785a00f848998a42035363df95b7dce6e4 authored almost 3 years ago
update version
2f9039c9594ea945d5a04b50230551cc96bcd6e2 authored almost 3 years ago
2f9039c9594ea945d5a04b50230551cc96bcd6e2 authored almost 3 years ago
Update dbatools.psm1
1161139590ccf5f03de229a2c54242efec8ec0ea authored almost 3 years ago
1161139590ccf5f03de229a2c54242efec8ec0ea authored almost 3 years ago
Add SMO already loaded warning (#8184)
fixes #8168
70724d8507a1cba72714ea4e61b8b8771e499de2 authored almost 3 years ago
Availability Groups: Some more fixes for granting permissions (#8185)
93ffa68b3560ce9e12d319c8958e28b18ef0eff2 authored almost 3 years ago
93ffa68b3560ce9e12d319c8958e28b18ef0eff2 authored almost 3 years ago
Find-DbaInstance - Add SqlInstance to default output (#8188)
9739e8051a658d6ffd3c65b28a21e0bdf5206b6a authored almost 3 years ago
9739e8051a658d6ffd3c65b28a21e0bdf5206b6a authored almost 3 years ago
Invoke-DbaQuery - Initialize $Err to prevent conflict with session variable (#8189)
8d5c1a5f0593c5dcd83e490e494268ca2cf3ba1c authored almost 3 years ago
8d5c1a5f0593c5dcd83e490e494268ca2cf3ba1c authored almost 3 years ago
Move cluster perms to Add-DbaAgReplica from New-DbaAvailabilityGroup (#8181)
298d198bf834f4b358d6ed7ea20492b803dac82a authored almost 3 years ago
298d198bf834f4b358d6ed7ea20492b803dac82a authored almost 3 years ago
Invoke-DbaDbLogShipping - Fix issues with Restore*Folder (#8157)
cee76547d28d1cd71c1d3f2c759692135d810d36 authored almost 3 years ago
cee76547d28d1cd71c1d3f2c759692135d810d36 authored almost 3 years ago
Invoke-DbaDbUpgrade - Change target recovery time if needed (#8165)
24806aa0c02609b2287f075eda5f83b5463f91b8 authored almost 3 years ago
24806aa0c02609b2287f075eda5f83b5463f91b8 authored almost 3 years ago
Get-DbaDbFile: add Database ID (#8175)
7332d26885cc2fb7cc157f4f54f0987a9fcea6a7 authored almost 3 years ago
7332d26885cc2fb7cc157f4f54f0987a9fcea6a7 authored almost 3 years ago
Set-DbaResourceGovernor: reuse server object (#8180)
9959b49bf83ae080d642a48f96ca767af48db91a authored almost 3 years ago
9959b49bf83ae080d642a48f96ca767af48db91a authored almost 3 years ago
fix/centralize ag createanydatabase perms (#8182)
- Not needed in New-DbaAvailabilityGroup since it is handled in both Replica and Database AG Add...
f89b5a989505a8cecc211c8872901fda08c50ca5 authored almost 3 years ago
update version
6341d43ece150c3317d6f1f004473066cfd048c2 authored almost 3 years ago
6341d43ece150c3317d6f1f004473066cfd048c2 authored almost 3 years ago
Set-DbaResourceGovernor: use SqlCredential, not Credential (#8171)
aaefbbee36acc71387a94cd5bb171b4e9f7eb41a authored almost 3 years ago
aaefbbee36acc71387a94cd5bb171b4e9f7eb41a authored almost 3 years ago
Update-DbaServiceAccount - Fix for named instances with certificate (#8164)
7dd96da3ac045fd18ade0f49cc54c2b1da0dacc8 authored almost 3 years ago
7dd96da3ac045fd18ade0f49cc54c2b1da0dacc8 authored almost 3 years ago
Get-DbaStartupParameter - variable names casing (#8172)
2b294fadbf2a7aec9df58829fe3519840415dcd1 authored almost 3 years ago
2b294fadbf2a7aec9df58829fe3519840415dcd1 authored almost 3 years ago
[Copy-DbaAgentJob] - Excludes AnalysisQuery and AnalysisCommand from dependent database jobstep check (#8174)
3fe841a4540a3eb689956a3b6ca32c0305eef766 authored almost 3 years ago
3fe841a4540a3eb689956a3b6ca32c0305eef766 authored almost 3 years ago
update version
afc0895b9a6927c19c935a86f711a6fd6bb9453d authored almost 3 years ago
afc0895b9a6927c19c935a86f711a6fd6bb9453d authored almost 3 years ago
Export-DbaScript - Reset ScriptingOptionsObject on failure (#8154)
f843de446bfca0dc12a2dea6a4a840b4e9e5f688 authored almost 3 years ago
f843de446bfca0dc12a2dea6a4a840b4e9e5f688 authored almost 3 years ago
Stop-Command - Fix wrong exception messages (#8153)
57651e96105d271085b116bcb68f09efdd4f7bfc authored almost 3 years ago
57651e96105d271085b116bcb68f09efdd4f7bfc authored almost 3 years ago
Invoke-DbaDbLogShipping / New-DbaLogShippingPrimaryDatabase - Fix issues with backup compression (#8156)
b2a4cf0840c418a007fbc5ddc0b25b96f4146381 authored almost 3 years ago
b2a4cf0840c418a007fbc5ddc0b25b96f4146381 authored almost 3 years ago
[Get|Start|Stop|Restart]-DbaService - Add parameter SqlInstance (#8159)
17c095f50254e44ac84b3629511f2faf5caadf23 authored almost 3 years ago
17c095f50254e44ac84b3629511f2faf5caadf23 authored almost 3 years ago
make sure tests are run according to pester.groups (#8160)
a9afcf24c0d0f6743cc24dcfbe675c59b175c6b6 authored almost 3 years ago
a9afcf24c0d0f6743cc24dcfbe675c59b175c6b6 authored almost 3 years ago
update version
7907811925ae7d26572831e31b5308bcde00002a authored almost 3 years ago
7907811925ae7d26572831e31b5308bcde00002a authored almost 3 years ago
New-DbaDbTable - Drop table if creation fails and change DefaultEx to DefaultExpression (#8150)
0bdf79c6e369e6318b958e0f06f5417ed315dbb7 authored almost 3 years ago
0bdf79c6e369e6318b958e0f06f5417ed315dbb7 authored almost 3 years ago
Set-DbaDbCompression - Refactoring (#8148)
ce9d2c3d7fa226b0ccc69d5eedc353e1060bf214 authored almost 3 years ago
ce9d2c3d7fa226b0ccc69d5eedc353e1060bf214 authored almost 3 years ago
update version
d23d6c575a596e8cd4eb991b4dcaa159bb258b5d authored almost 3 years ago
d23d6c575a596e8cd4eb991b4dcaa159bb258b5d authored almost 3 years ago
Get-DbaDbRestoreHistory: new param to return history by restore type (#8151)
0ad1bd7a8a31716979e32624fa17c86b3c7d9db4 authored almost 3 years ago
0ad1bd7a8a31716979e32624fa17c86b3c7d9db4 authored almost 3 years ago
Get-DbaUserPermissions Exclude Securables (#8149)
eb79e8b4ab7bea63e5ae5d80bf16e4f085ec3fa1 authored almost 3 years ago
eb79e8b4ab7bea63e5ae5d80bf16e4f085ec3fa1 authored almost 3 years ago
update version
630c038fb2e1f097b2c5b21a355acf61729add09 authored almost 3 years ago
630c038fb2e1f097b2c5b21a355acf61729add09 authored almost 3 years ago
add commands
58c37bcdca4ba07c20b23b40fb3e31b25ada9aaa authored almost 3 years ago
58c37bcdca4ba07c20b23b40fb3e31b25ada9aaa authored almost 3 years ago
Remove-DbaDbPartitionFunction + test (#8147)
16501798cc93f5fbbf327754ceda4641c070f679 authored almost 3 years ago
16501798cc93f5fbbf327754ceda4641c070f679 authored almost 3 years ago
Remove-DbaDbPartitionScheme + tests (#8146)
00ad118b4791b097b6c2cefde7e37c61c1273d26 authored almost 3 years ago
00ad118b4791b097b6c2cefde7e37c61c1273d26 authored almost 3 years ago
New-DbaAgentOperator - FailsafeNotificationMethod validation incorrect (#8145)
tekst error
a753d0f2e3a56124f90aadb26b049f19bbf78919 authored almost 3 years ago
Connect-DbaInstance - Remove legacy code (#8143)
7b376b8888a9a255fef00f599d5052e6c0d97ed3 authored almost 3 years ago
7b376b8888a9a255fef00f599d5052e6c0d97ed3 authored almost 3 years ago
update version
4a59ef92a87ff075b052caac213990cffd0f9fef authored almost 3 years ago
4a59ef92a87ff075b052caac213990cffd0f9fef authored almost 3 years ago
[Set-DbaAgentAlert] - Added ShouldProcess to the Rename to fix #8137 (#8138)
a7b08cf62c0b4abc0f4ddfc0c1275a32bb7126ba authored almost 3 years ago
a7b08cf62c0b4abc0f4ddfc0c1275a32bb7126ba authored almost 3 years ago
[Set-DbaAgentJobStep] - Added ShouldProcess to the Rename to fix #8140 (#8141)
e4fd5797ccdaa4d5b8970b4aaeeed223451c50cd authored almost 3 years ago
e4fd5797ccdaa4d5b8970b4aaeeed223451c50cd authored almost 3 years ago
New-DbaDbTable - Add DefaultEx to support functions as defaults for string types (#8142)
166bb57465947cb5a561de277268b8c3ceb72b4c authored almost 3 years ago
166bb57465947cb5a561de277268b8c3ceb72b4c authored almost 3 years ago
Test-DbaConnection - support usage of FQDN when testing TcpPort (#8139)
ddf83a4f8cef648c5383cdc57660a831fc42538c authored almost 3 years ago
ddf83a4f8cef648c5383cdc57660a831fc42538c authored almost 3 years ago
Find-DbaDbDuplicateIndex - Add the attribute "IsUnique" to the output (#8136)
17662e39d2d8ec995d31c84d24cb56c04659c201 authored almost 3 years ago
17662e39d2d8ec995d31c84d24cb56c04659c201 authored almost 3 years ago
Add-DbaAgDatabase - Add parameter AdvancedBackupParams (#8135)
2fc3fc77383a3baeb51756aef3f3888baac228d9 authored almost 3 years ago
2fc3fc77383a3baeb51756aef3f3888baac228d9 authored almost 3 years ago
Save-DbaCommunitySoftware - Fix path when saving version.txt (#8134)
c848742c686b37424c3ffcd56a14b6a1ce60cb20 authored almost 3 years ago
c848742c686b37424c3ffcd56a14b6a1ce60cb20 authored almost 3 years ago
add Remove-DbaDbCheckConstraint
f38b5b22666169bc644f4b4c8f92a3af31b21783 authored almost 3 years ago
f38b5b22666169bc644f4b4c8f92a3af31b21783 authored almost 3 years ago
Remove-DbaDbCheckConstraint - new command (#8132)
c598fb7301a653dc65a03067b81639d4109e9db9 authored almost 3 years ago
c598fb7301a653dc65a03067b81639d4109e9db9 authored almost 3 years ago
Refactoring of Copy-DbaCredential and Export-DbaCredential (#8129)
5181b7b6495412890840931f368a9d8e51c2fff2 authored almost 3 years ago
5181b7b6495412890840931f368a9d8e51c2fff2 authored almost 3 years ago
update version
dd7eb54d9b847faa919c737df2b7a12752d46ec1 authored almost 3 years ago
dd7eb54d9b847faa919c737df2b7a12752d46ec1 authored almost 3 years ago
Add FileType parameter to Set-DbaDbFileGrowth (#8131)
068c9c4d0e9c0c9cd919e68059995f72ea890d5f authored almost 3 years ago
068c9c4d0e9c0c9cd919e68059995f72ea890d5f authored almost 3 years ago
Restore-DbaDatabase - Make continue CBH less confusing (#8130)
eb041f6d7b3155333d9315d5e07ada0d924ff4ca authored almost 3 years ago
eb041f6d7b3155333d9315d5e07ada0d924ff4ca authored almost 3 years ago
update version
598f77ebb187bb6818523875091e186758610f8c authored almost 3 years ago
598f77ebb187bb6818523875091e186758610f8c authored almost 3 years ago
*-DbaFirewallRule - support markdown style on website (#8128)
77e5f10f0f64e50cb25a51c522bee0ebb0444c17 authored almost 3 years ago
77e5f10f0f64e50cb25a51c522bee0ebb0444c17 authored almost 3 years ago
update version
1c35c4cf0070673dfeaf0b2a476eca3512db9edb authored almost 3 years ago
1c35c4cf0070673dfeaf0b2a476eca3512db9edb authored almost 3 years ago
Get-DecryptedObject - Fix some issues (#8127)
bbc557a27dc45197feab3a4391f7b2c6016f88ab authored almost 3 years ago
bbc557a27dc45197feab3a4391f7b2c6016f88ab authored almost 3 years ago
DbaFirewallRule - Create, get and remove rules for dedicated admin connection (DAC) (#8122)
e40eaa22fb00d4a2528ed9a38d2cf3e98ac4ebc2 authored almost 3 years ago
e40eaa22fb00d4a2528ed9a38d2cf3e98ac4ebc2 authored almost 3 years ago
New-DbaLinkedServer: allow for updates to the security context setting (#8113)
88b8265cbb258f4bd64f2b5b83bba33d91693b52 authored almost 3 years ago
88b8265cbb258f4bd64f2b5b83bba33d91693b52 authored almost 3 years ago
Install-DbaInstance - fix typo in documentation (#8126)
77bb63d9ce4c1190708de282e713de9b97b29579 authored almost 3 years ago
77bb63d9ce4c1190708de282e713de9b97b29579 authored almost 3 years ago
Standardize Cert / Master Key / Service Master Key backups (#8106)
4f2df04ebdcba0bf980416ffa9b1b4ef27571f4b authored almost 3 years ago
4f2df04ebdcba0bf980416ffa9b1b4ef27571f4b authored almost 3 years ago
Do not load XEvents DLLs on ARM64 (#8124)
837994a37b694e0ef2eb2ea4874fd4ea8386f38e authored almost 3 years ago
837994a37b694e0ef2eb2ea4874fd4ea8386f38e authored almost 3 years ago