Ecosyste.ms: OpenCollective

An open API service for software projects hosted on Open Collective.

dbatools

PowerShell module to help SQL Server Pros be more productive.
Collective - Host: opensource - https://opencollective.com/dbatools - Website: https://dbatools.io - Code: https://github.com/sqlcollaborative/dbatools

Get-DbaDbBackupHistory - support AvailabilityGroupName for Raw parameter output (#8974)

github.com/dataplat/dbatools - b21b7e87133a40f1539c456a3108919fc6a5d647 authored over 1 year ago by Andreas Jordan <[email protected]>
Update reference in project readme - correction on custom port syntax (#8998)

github.com/dataplat/dbatools - e996def8426806ce94c4c0f8790d3d1e433d5e16 authored over 1 year ago by Mike Blaszczak <[email protected]>
Documentation - correct typo of TThe to The (#9000)

github.com/dataplat/dbatools - b191b390dfadb7383a1db639bde2f5dfbb3c65b4 authored over 1 year ago by Shawn Melton <[email protected]>
address typo of "TThe" when "The" was intended

this addresses issue 8999
https://github.com/dataplat/dbatools/issues/8999

github.com/dataplat/dbatools - ade224689fa216fd541e6532652c014b64d71205 authored over 1 year ago by Mike Blaszczak <[email protected]>
Test-DbaWindowsLogin - Add support for pipeline input from Get-DbaLogin (#8984)

github.com/dataplat/dbatools - ca8084fdca9e2d4a99e2d20610262cf784c6126f authored over 1 year ago by Andreas Jordan <[email protected]>
Update build file - SQL 2022 CU5, SQL 2019 CU21 (#8990)

github.com/dataplat/dbatools - 65429845c81af7871efb2a8d10896a1f2cb70e7f authored over 1 year ago by Mikey Bronowski <[email protected]>
Add IsHadrEnabled to default output of Microsoft.SqlServer.Management.Smo.Server (#8983)

github.com/dataplat/dbatools - 53f58c5313c938398a2f0b4dfd55aafdf791c406 authored over 1 year ago by Andreas Jordan <[email protected]>
Connect-DbaInstance - Fix for using a connection string (#8962)

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

github.com/dataplat/dbatools - aaaa2ae74dac7bf24f9665a5e8d2e34898770de3 authored over 1 year ago by Andreas Jordan <[email protected]>
Get-DbaStartupParameter - Return debug flags instead of writing warning (#8977)

github.com/dataplat/dbatools - 87a973bcb974d03329734242cc156661e1101a46 authored over 1 year ago by Andreas Jordan <[email protected]>
Backup-DbaDatabase - Add database name to error message (#8975)

github.com/dataplat/dbatools - 842e8a3f05d1362c40987b906c06a2ba9daab44c authored over 1 year ago by Andreas Jordan <[email protected]>
configuration.ps1 - Fix wrong setting of NoRegistry (#8968)

github.com/dataplat/dbatools - b90d8c7153c78226e923ac0be987d0f934e72ff2 authored over 1 year ago by Andreas Jordan <[email protected]>
Get-DbaDbRoleMember - EnableException support on child function call (#8987)

github.com/dataplat/dbatools - 4e687924e14105445b7e0d96f19f6532ca1b9af6 authored over 1 year ago by Shawn Melton <[email protected]>
Install-DbaMaintenanceSolution - Added InstallJobs switch in examples (#8982)

github.com/dataplat/dbatools - 9aa95718f864063c68642183dc2d85c7c676cc28 authored over 1 year ago by Andreas Jordan <[email protected]>
Export-DbaUser - Add support for SQL Server 2022 (#8978)

github.com/dataplat/dbatools - c455938c5a50f69a7db866c6429377eaf22d33c1 authored over 1 year ago by Andreas Jordan <[email protected]>
Get-DbaMaintenanceSolutionLog - Update documentation (#8979)

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

github.com/dataplat/dbatools - 9daac3bed3233631cd017bad3c8830c333f6e02c authored over 1 year ago by Andreas Jordan <[email protected]>
Get-DbaDatabase - Add RecoveryPending as possible Status (#8965)

github.com/dataplat/dbatools - 0433f3260cc448b8ca932b8da4a4b777a656768a authored over 1 year ago by Andreas Jordan <[email protected]>
update version

github.com/dataplat/dbatools - cb4fec178bdc37f6a50716769dcadce517da1199 authored over 1 year ago by Chrissy LeMaire <[email protected]>
New-DbaAvailabilityGroup - Remove parameter ReadonlyRoutingConnectionUrl (#8960)

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

github.com/dataplat/dbatools - 969374605ae79082cddd558bf5d5cab7e8b3891d authored over 1 year ago by Andreas Jordan <[email protected]>
Export-DbaDbRole - Exclude special user dbo (#8963)

github.com/dataplat/dbatools - 3b0907da118a85b2e913ed46b06401d0a0bd6336 authored over 1 year ago by Andreas Jordan <[email protected]>
Get-DbaProductKey - Enable support for SQL Server 2005 (#8961)

github.com/dataplat/dbatools - 8a0bff4c07c6a6a4e4e705ec490848068ab695c4 authored over 1 year ago by Andreas Jordan <[email protected]>
New-DbaDbUser - Align code with docs (#8957)

github.com/dataplat/dbatools - a398d2fb07c7a4503a607a0e1afcf5f98d7b2152 authored over 1 year ago by Andreas Jordan <[email protected]>
Copy-DbaDbTableData - Fix test and example for query parameter (#8956)

github.com/dataplat/dbatools - 62e6234a6b0e7bc38756e0f5aefd08331199cd70 authored over 1 year ago by Andreas Jordan <[email protected]>
Copy-DbaDatabase - Fix issue while deleting backups (#8954)

github.com/dataplat/dbatools - 07118109762045cbc2878f1a64df6be399c85575 authored over 1 year ago by Andreas Jordan <[email protected]>
Get-DbaDbAssembly - Fix filter for name (#8953)

github.com/dataplat/dbatools - 902fad9acd521c7c2b9195c7fbc1e949ff28e9d4 authored over 1 year ago by Andreas Jordan <[email protected]>
Update dbatools-buildref-index.json

github.com/dataplat/dbatools - f51ade57b3280d947c4492898e41e4a1018403be authored over 1 year ago by Chrissy LeMaire <[email protected]>
Get-DbaProductKey - Support SQL Server 2022 (#8952)

github.com/dataplat/dbatools - 4e4551cb9d43407073de073bac16e511a64d909e authored over 1 year ago by Andreas Jordan <[email protected]>
Install-DbaFirstResponderKit - Use target database on first connect (#8951)

github.com/dataplat/dbatools - 0043221863f2d5ff7932a6f171bf68157c4b96df authored over 1 year ago by Andreas Jordan <[email protected]>
New-DbaAvailabilityGroup and Add-DbaAgDatabase: Improve progress bars (#8943)

github.com/dataplat/dbatools - 98ef0a454954b462ae26f9d04791524815f7b4c1 authored over 1 year ago by Andreas Jordan <[email protected]>
Test-DbaBackupInformation - Fix for database name capitalization changes (#8942)

github.com/dataplat/dbatools - fc6293255b0f1da83092867ca4fcf4c2351dff7b authored over 1 year ago by Andreas Jordan <[email protected]>
Watch-DbaDbLogin - Only write to target and don't watch target (#8936)

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

github.com/dataplat/dbatools - 617a162bd10be02b24155fe74ae4eb641316d917 authored over 1 year ago by Andreas Jordan <[email protected]>
Get/Test-DbaBuild, handle version "aliases" (#8959)

github.com/dataplat/dbatools - c8ca1abc080cc1534cd900403fb5f56cbde2e218 authored over 1 year ago by Simone Bizzotto <[email protected]>
Get-DbaAgentSchedule - Use better switch syntax (#8937)

github.com/dataplat/dbatools - f0958c11f1e944aab4da6a800474c276634a7fa9 authored over 1 year ago by Andreas Jordan <[email protected]>
New-DbaAgentSchedule - Fix issue with FrequencyInterval Weekdays (#8938)

github.com/dataplat/dbatools - 98103a53dc304c2721ad72d5f8bbd1faf990dc6b authored over 1 year ago by Andreas Jordan <[email protected]>
Fix JobCount returned on schedule creation (#8934)

github.com/dataplat/dbatools - 87c7ae0e4dfb33974b5a7ffd5412891a31693b16 authored over 1 year ago by John McCall <[email protected]>
Fix SuspectPage example in documentation (#8928)

github.com/dataplat/dbatools - a0d3acc4f3913925ec0288c276ad1526397a231d authored over 1 year ago by msgisme <[email protected]>
Update dbatools.psd1

Invoke-DbaAzSqlDbTip was listed in psd1 as Tips so easn't exporting

github.com/dataplat/dbatools - 5d731c18cbcfbc8f11683b9eaa0207e9ca7731a2 authored over 1 year ago by Jess Pomfret <[email protected]>
2.0.3

github.com/dataplat/dbatools - 4558b4c2419d451f9de2bfee1458314fa7f2f159 authored over 1 year ago by Chrissy LeMaire <[email protected]>
Install-DbaMaintenanceSolution - fix scheduler, add examples (#8926)

github.com/dataplat/dbatools - 20ae33ef61f47913b016316ffdb7b9bcc3d13055 authored over 1 year ago by Chrissy LeMaire <[email protected]>
Update dbatools-buildref-index.json - SQL 2022 CU4 (#8925)

github.com/dataplat/dbatools - acf82d83601d5345b823c69265c852a9c20e8f20 authored over 1 year ago by Mikey Bronowski <[email protected]>
2.0.2

github.com/dataplat/dbatools - 40ee686a495e40ea5064843f9ea25fcb2d51b603 authored over 1 year ago by Chrissy LeMaire <[email protected]>
Install-DbaMaintenanceSolution - Add auto-scheduling (#8911)

github.com/dataplat/dbatools - 63cb56ba18991b3cc713cbe831459f67b9b52fc1 authored over 1 year ago by Chrissy LeMaire <[email protected]>
Get-DbaDbTable - Only return accessible objects (#8913)

github.com/dataplat/dbatools - 6271e095d965d1ad5050c520a4a6045b4271e438 authored over 1 year ago by Chrissy LeMaire <[email protected]>
Update-Dbatools - Deprecate command (#8912)

github.com/dataplat/dbatools - eb079a591427eeb10680a9d00690e4e0ddac4e57 authored over 1 year ago by Chrissy LeMaire <[email protected]>
Documentation: removed wrong examples in synopsis; fixed issue #8908 #8907 (#8910)

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

github.com/dataplat/dbatools - 4e8b002b8622f4941d9960af02db7362a1fad38b authored over 1 year ago by Christian Ritter <[email protected]>
Documentation fixes - fixed issue #8906 and #8905 (#8909)

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

github.com/dataplat/dbatools - 56e236ccb500fcc0d538e87f6cdece04d58a5ea7 authored over 1 year ago by Christian Ritter <[email protected]>
Test-DbaSpn: Support multiple ports per instance (#8901)

github.com/dataplat/dbatools - 16d95fd1b4bec9e256001a709a709e7d1eedd92a authored over 1 year ago by Andreas Jordan <[email protected]>
Connect-DbaInstance: Use parameter or config for TrustServerCertificate for connections from registered servers (#8900)

github.com/dataplat/dbatools - 544ac3d76a6040726b70f8024e422f81967d4771 authored over 1 year ago by Andreas Jordan <[email protected]>
update tests

github.com/dataplat/dbatools - 88dc002b38d22a6787e01ece8c4e9647a3e9f8d9 authored over 1 year ago by Chrissy LeMaire <[email protected]>
Update library version with working Analysis Services on Desktop (#8898)

github.com/dataplat/dbatools - 8452dc71325e5861f3db075186adf9fe1415b4b5 authored over 1 year ago by Chrissy LeMaire <[email protected]>
Refactored function to improve code clarity and fix issue #8807 (#8896)

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

github.com/dataplat/dbatools - 01ef80b1cb002152079971fbfbf64bb8fcc3b5fe authored over 1 year ago by Christian Ritter <[email protected]>
New-DbaComputerCertificate - Fix immutability issue (#8897)

github.com/dataplat/dbatools - 06d7aba2c1c0ad01e673acce4d0175c863dabeea authored over 1 year ago by Chrissy LeMaire <[email protected]>
New-DbaCredential - MappedClassType not found (#8892)

github.com/dataplat/dbatools - 83a5b99e26284e9dff54a6ecf6e0f281ff8c8bf6 authored over 1 year ago by Chrissy LeMaire <[email protected]>
New Command - Test-DbaAgSpn (#8889)

github.com/dataplat/dbatools - dcd1dfc8f544c5e4d61b20f66070d11b77fea5b4 authored over 1 year ago by Chrissy LeMaire <[email protected]>
Import-Command: Wait if file in use (#8893)

github.com/dataplat/dbatools - c6035efbf6cbbc42583f8c34dc55d2e02e05f3c9 authored over 1 year ago by Chrissy LeMaire <[email protected]>
update docs

github.com/dataplat/dbatools - cd748944af563eaea4e87fe1cc829e6b222c20ed authored over 1 year ago by Chrissy LeMaire <[email protected]>
Backup-DbaDatabase - EnableException when appropriate (#8887)

github.com/dataplat/dbatools - 99cc47d42e00a3450c4af53e18b0c275743e0bff authored over 1 year ago by Chrissy LeMaire <[email protected]>
#8554 add documentation for importing gzip csv (#8885)

github.com/dataplat/dbatools - 17a7cae0f3ac5eef397d073de005d6260a25fe48 authored over 1 year ago by Gabe Flores <[email protected]>
small changes, more coming soon.

github.com/dataplat/dbatools - dd8eb389614cf8c135b1ab04c7fe23ac90c2f55e authored over 1 year ago by Chrissy LeMaire <[email protected]>
bummer -- forgot to add Install-DbaAgentAdminAlert to manifest

github.com/dataplat/dbatools - 008bcde471f87a973fbeb40db19bccb56a670ea5 authored over 1 year ago by Chrissy LeMaire <[email protected]>
Library Update (#8881)

github.com/dataplat/dbatools - ffb7b37460c087bcce0c220273ed0cd46958a9e7 authored over 1 year ago by Chrissy LeMaire <[email protected]>
Test-DbaLastBackup -VerifyOnly report failure when backup file is corrupted (#8880)

github.com/dataplat/dbatools - 32502acc824ebb8ec8d8a5791fe88e848acea101 authored over 1 year ago by Chrissy LeMaire <[email protected]>
Add Maintenance Solution to module (#8878)

github.com/dataplat/dbatools - 9ada728b9e63c7dab29a79d95b19607bee4824d2 authored over 1 year ago by Chrissy LeMaire <[email protected]>
Set-DbatoolsInsecureConnection - Persist by default (#8877)

github.com/dataplat/dbatools - e46e043dd80c9d91753c06da4ca54e7325abd1bf authored over 1 year ago by Chrissy LeMaire <[email protected]>
New commands: New-DbaAgentAlert and Install-DbaAgentAdminAlert (#8876)

github.com/dataplat/dbatools - 6392d000c31769020c2a7ce7418872826c2855aa authored over 1 year ago by Chrissy LeMaire <[email protected]>
Fix New-DbaComputerCertificate to support PS 7.3 (#8875)

github.com/dataplat/dbatools - 0073c5cf5e6439d402fdaf812c7896014209d53e authored over 1 year ago by Andreas Jordan <[email protected]>
Start-DbaMigration - Remove KeepCDC and KeepReplication parameters from detach method (#8871)

github.com/dataplat/dbatools - 056f49405667c559c8fc8909a79b45431bfbc5d5 authored over 1 year ago by Ben Thul <[email protected]>
update version

github.com/dataplat/dbatools - ee73fc6c3b9714d5983094845981511a6d9573b8 authored over 1 year ago by Chrissy LeMaire <[email protected]>
Test-DbaLastBackup - Enable CopyOnly for backups with multiple files (#8868)

github.com/dataplat/dbatools - 1c0e311048dcd0e1fff8a093a41fc70afbcd5c38 authored over 1 year ago by Chrissy LeMaire <[email protected]>
Invoke-DbaBalanceDataFiles - Skip disk check on non-Windows servers (#8866)

github.com/dataplat/dbatools - e94f6cfe01725f51a047433fe936279431c55e6c authored over 1 year ago by Chrissy LeMaire <[email protected]>
Invoke-ManagedComputerCommand - Add explicit SQLWMI import (#8862)

github.com/dataplat/dbatools - a14865224ddff1ff176585628174b0b48e13363b authored over 1 year ago by Chrissy LeMaire <[email protected]>
Updated Version and changed import routine a lil bit (#8869)

github.com/dataplat/dbatools - 447ce7c3b740e28adbe1d9e38dc9fbf6d211fc2a authored over 1 year ago by Chrissy LeMaire <[email protected]>
Fix/8860 (#8861)

github.com/dataplat/dbatools - 3d307fbf5d0412208411d634f51ebf70589e5f63 authored over 1 year ago by Simone Bizzotto <[email protected]>
Temptables can be used on NonPooledConnections (#8764)

Co-authored-by: Jack Pokras <[email protected]>
Co-authored-by: Chrissy LeMaire <clemaire...

github.com/dataplat/dbatools - 23e78c9f526dd70f3def521eb2a69236325e0482 authored over 1 year ago by jpokras <[email protected]>
Update dbatools-buildref-index.json - SQL 2022 CU3 / SQL 2019 CU20 (#8859)

github.com/dataplat/dbatools - 435f514b4e429f2d691d45ec77e4c17c82a7a679 authored over 1 year ago by Mikey Bronowski <[email protected]>
Update sp_configure properties for 2022 (#8858)

github.com/dataplat/dbatools - 030d1eec85cb67c3b2bedf5ebd39aaf65b94d78b authored over 1 year ago by Chrissy LeMaire <[email protected]>
Get-DbaPermission - Fix missing bracket in SQL statement (#8856)

github.com/dataplat/dbatools - 3e767d7e0f88b32fd1acd0e657bd8c134bd272a2 authored almost 2 years ago by Tom <[email protected]>
update readme for dbatools 2.0

github.com/dataplat/dbatools - 98925a61d3e6e5b480b633bd0c9bd4d6ab0aede9 authored almost 2 years ago by Chrissy LeMaire <[email protected]>
add new test

github.com/dataplat/dbatools - b7669fcb3ef63709f1d519c66453a0dfa91332bc authored almost 2 years ago by Chrissy LeMaire <[email protected]>
Fix TEPP/autocomplete (#8854)

github.com/dataplat/dbatools - 773e8f4617671c6cf40bb66ec81543a3df4171cc authored almost 2 years ago by Chrissy LeMaire <[email protected]>
Update to new version (#8852)

github.com/dataplat/dbatools - 5f2876f437501bc41bb34cf1817ac8498257a28d authored almost 2 years ago by Chrissy LeMaire <[email protected]>
Update dbatools-index.json

github.com/dataplat/dbatools - db025b1b087aff79808cc9a5b6415680c90057a0 authored almost 2 years ago by Chrissy LeMaire <[email protected]>
Standardize Whatif Output (#8846)

github.com/dataplat/dbatools - 2af6205cbfaf6215fe69be1bb1261aad93e6a08f authored almost 2 years ago by Chrissy LeMaire <[email protected]>
Restore-DbaDatabase - Enable summing TotalSize if input is from CliXml exported file (#8848)

github.com/dataplat/dbatools - 8d419b0a08a76ef28ec2b0898c830abf9636137a authored almost 2 years ago by Chrissy LeMaire <[email protected]>
New command - Set-DbatoolsInsecureConnection (#8849)

github.com/dataplat/dbatools - 7633c6c833464738f04ca11cf8a9c5bb08145d6b authored almost 2 years ago by Chrissy LeMaire <[email protected]>
Get-DbaLastGoodCheckDb - Support Azure (#8836)

github.com/dataplat/dbatools - 163a941751f57e2d1d94afea35ecf6b87612572b authored almost 2 years ago by Chrissy LeMaire <[email protected]>
Sync-DbaAvailabilityGroup - Show details for objects being synced when using whatif (#8844)

github.com/dataplat/dbatools - 1b0c7d39749c4f962481d6ed6ac63d6b2598e421 authored almost 2 years ago by Chrissy LeMaire <[email protected]>
Add back SSIS commands for non-core PS (#8843)

github.com/dataplat/dbatools - 18a7e31c73c0433b0eebc764875ec2605ae66fe2 authored almost 2 years ago by Chrissy LeMaire <[email protected]>
Added Filter functionality to Get-DbaDbUserDefinedTableType (#8834)

github.com/dataplat/dbatools - 5a9f1339d4fe376455afa377376abfd75e926758 authored almost 2 years ago by sqlarticles <[email protected]>
Write-HostColor - Fix issue in Linux (#8839)

github.com/dataplat/dbatools - 368fd8d7c5bfd8f092eeb02dde3fdc5db0c112ff authored almost 2 years ago by Chrissy LeMaire <[email protected]>
Attempt to resolve default shell issue in devcontainers (#8837)

github.com/dataplat/dbatools - 4d09cc72d59d9a4833b834d4d6d877a495e15166 authored almost 2 years ago by Chrissy LeMaire <[email protected]>
Skip Setting Default Log Shipping Monitor (#8832)

github.com/dataplat/dbatools - 9c9bb4810956f9fcfbac87ec30f2f9b8c738b59c authored almost 2 years ago by josh <[email protected]>
Find-DbaOrphanedFile - Fix path in non-Windows (#8835)

github.com/dataplat/dbatools - a51387aab148ae467d40d176aa9018b7c0d6b749 authored almost 2 years ago by Chrissy LeMaire <[email protected]>
Fix: Copy-DbaDatabase: prevent dropping of destination databases if destination is the source (#8831)

github.com/dataplat/dbatools - 6b88dcc9492a326727376b7c43990d705d423833 authored almost 2 years ago by Chrissy LeMaire <[email protected]>
Contributing guide update (#8822)

github.com/dataplat/dbatools - d0ab2114a305ad58b1dd325a7defabb4f1e9cabe authored almost 2 years ago by Shawn Melton <[email protected]>
New-DbaDbUser: Refactor and added contained user creation (#8827)

github.com/dataplat/dbatools - 728fca164b31482370c161dd03528b3188b46f0a authored almost 2 years ago by sqlarticles <[email protected]>
Set-DbaNetworkCertificate: Try to determine key algorithm and use appropriate extension class (#8818)

github.com/dataplat/dbatools - cf787f466e6136a511c486d02c251a220629c384 authored almost 2 years ago by Alexander Rose <[email protected]>
Implementing Test-DbaPath for Testing Copy Folder for Log Shipping Secondary (#8826)

github.com/dataplat/dbatools - 279e8f250f7b997f60cd8183884dad8fee8a6b52 authored almost 2 years ago by josh <[email protected]>
New-DbaDbSnapshot - Support special characters in database name (#8830)

github.com/dataplat/dbatools - d028d01de32c3f1352dfbb039786a3b68decdc50 authored almost 2 years ago by Simone Bizzotto <[email protected]>
Updates to devcontainer configuration (#8823)

github.com/dataplat/dbatools - d7509c6eed18ab9aa5f6eaa11bfc6517aafaecf6 authored almost 2 years ago by Shawn Melton <[email protected]>
Update dbatools-buildref-index.json - SQL 2022 CU2 (#8813)

github.com/dataplat/dbatools - 84c256595b0c016cf95f693f8c9c1f241c7987bd authored almost 2 years ago by Mikey Bronowski <[email protected]>