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

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

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

Update reference in project readme - correction on custom port syntax (#8998)

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

Documentation - correct typo of TThe to The (#9000)

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

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

Test-DbaWindowsLogin - Add support for pipeline input from Get-DbaLogin (#8984)

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

Update build file - SQL 2022 CU5, SQL 2019 CU21 (#8990)

65429845c81af7871efb2a8d10896a1f2cb70e7f authored over 1 year ago by Mikey Bronowski <[email protected]>

Add IsHadrEnabled to default output of Microsoft.SqlServer.Management.Smo.Server (#8983)

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]>

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

Get-DbaStartupParameter - Return debug flags instead of writing warning (#8977)

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

Backup-DbaDatabase - Add database name to error message (#8975)

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

configuration.ps1 - Fix wrong setting of NoRegistry (#8968)

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

Get-DbaDbRoleMember - EnableException support on child function call (#8987)

4e687924e14105445b7e0d96f19f6532ca1b9af6 authored over 1 year ago by Shawn Melton <[email protected]>

Install-DbaMaintenanceSolution - Added InstallJobs switch in examples (#8982)

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

Export-DbaUser - Add support for SQL Server 2022 (#8978)

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

Get-DbaMaintenanceSolutionLog - Update documentation (#8979)

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

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

Get-DbaDatabase - Add RecoveryPending as possible Status (#8965)

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

update version

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

New-DbaAvailabilityGroup - Remove parameter ReadonlyRoutingConnectionUrl (#8960)

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

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

Export-DbaDbRole - Exclude special user dbo (#8963)

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

Get-DbaProductKey - Enable support for SQL Server 2005 (#8961)

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

New-DbaDbUser - Align code with docs (#8957)

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

Copy-DbaDbTableData - Fix test and example for query parameter (#8956)

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

Copy-DbaDatabase - Fix issue while deleting backups (#8954)

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

Get-DbaDbAssembly - Fix filter for name (#8953)

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

Update dbatools-buildref-index.json

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

Get-DbaProductKey - Support SQL Server 2022 (#8952)

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

Install-DbaFirstResponderKit - Use target database on first connect (#8951)

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

New-DbaAvailabilityGroup and Add-DbaAgDatabase: Improve progress bars (#8943)

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

Test-DbaBackupInformation - Fix for database name capitalization changes (#8942)

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]>

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

Get/Test-DbaBuild, handle version "aliases" (#8959)

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

Get-DbaAgentSchedule - Use better switch syntax (#8937)

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

New-DbaAgentSchedule - Fix issue with FrequencyInterval Weekdays (#8938)

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

Fix JobCount returned on schedule creation (#8934)

87c7ae0e4dfb33974b5a7ffd5412891a31693b16 authored over 1 year ago by John McCall <[email protected]>

Fix SuspectPage example in documentation (#8928)

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

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

2.0.3

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

Install-DbaMaintenanceSolution - fix scheduler, add examples (#8926)

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

Update dbatools-buildref-index.json - SQL 2022 CU4 (#8925)

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

2.0.2

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

Install-DbaMaintenanceSolution - Add auto-scheduling (#8911)

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

Get-DbaDbTable - Only return accessible objects (#8913)

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

Update-Dbatools - Deprecate command (#8912)

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]>

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]>

56e236ccb500fcc0d538e87f6cdece04d58a5ea7 authored over 1 year ago by Christian Ritter <[email protected]>

Test-DbaSpn: Support multiple ports per instance (#8901)

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)

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

update tests

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

Update library version with working Analysis Services on Desktop (#8898)

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]>

01ef80b1cb002152079971fbfbf64bb8fcc3b5fe authored over 1 year ago by Christian Ritter <[email protected]>

New-DbaComputerCertificate - Fix immutability issue (#8897)

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

New-DbaCredential - MappedClassType not found (#8892)

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

New Command - Test-DbaAgSpn (#8889)

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

Import-Command: Wait if file in use (#8893)

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

update docs

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

Backup-DbaDatabase - EnableException when appropriate (#8887)

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

#8554 add documentation for importing gzip csv (#8885)

17a7cae0f3ac5eef397d073de005d6260a25fe48 authored over 1 year ago by Gabe Flores <[email protected]>

small changes, more coming soon.

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

bummer -- forgot to add Install-DbaAgentAdminAlert to manifest

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

Library Update (#8881)

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

Test-DbaLastBackup -VerifyOnly report failure when backup file is corrupted (#8880)

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

Add Maintenance Solution to module (#8878)

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

Set-DbatoolsInsecureConnection - Persist by default (#8877)

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

New commands: New-DbaAgentAlert and Install-DbaAgentAdminAlert (#8876)

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

Fix New-DbaComputerCertificate to support PS 7.3 (#8875)

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

Start-DbaMigration - Remove KeepCDC and KeepReplication parameters from detach method (#8871)

056f49405667c559c8fc8909a79b45431bfbc5d5 authored over 1 year ago by Ben Thul <[email protected]>

update version

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

Test-DbaLastBackup - Enable CopyOnly for backups with multiple files (#8868)

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

Invoke-DbaBalanceDataFiles - Skip disk check on non-Windows servers (#8866)

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

Invoke-ManagedComputerCommand - Add explicit SQLWMI import (#8862)

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

Updated Version and changed import routine a lil bit (#8869)

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

Fix/8860 (#8861)

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...

23e78c9f526dd70f3def521eb2a69236325e0482 authored over 1 year ago by jpokras <[email protected]>

Update dbatools-buildref-index.json - SQL 2022 CU3 / SQL 2019 CU20 (#8859)

435f514b4e429f2d691d45ec77e4c17c82a7a679 authored over 1 year ago by Mikey Bronowski <[email protected]>

Update sp_configure properties for 2022 (#8858)

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

Get-DbaPermission - Fix missing bracket in SQL statement (#8856)

3e767d7e0f88b32fd1acd0e657bd8c134bd272a2 authored almost 2 years ago by Tom <[email protected]>

update readme for dbatools 2.0

98925a61d3e6e5b480b633bd0c9bd4d6ab0aede9 authored almost 2 years ago by Chrissy LeMaire <[email protected]>

add new test

b7669fcb3ef63709f1d519c66453a0dfa91332bc authored almost 2 years ago by Chrissy LeMaire <[email protected]>

Fix TEPP/autocomplete (#8854)

773e8f4617671c6cf40bb66ec81543a3df4171cc authored almost 2 years ago by Chrissy LeMaire <[email protected]>

Update to new version (#8852)

5f2876f437501bc41bb34cf1817ac8498257a28d authored almost 2 years ago by Chrissy LeMaire <[email protected]>

Update dbatools-index.json

db025b1b087aff79808cc9a5b6415680c90057a0 authored almost 2 years ago by Chrissy LeMaire <[email protected]>

Standardize Whatif Output (#8846)

2af6205cbfaf6215fe69be1bb1261aad93e6a08f authored almost 2 years ago by Chrissy LeMaire <[email protected]>

Restore-DbaDatabase - Enable summing TotalSize if input is from CliXml exported file (#8848)

8d419b0a08a76ef28ec2b0898c830abf9636137a authored almost 2 years ago by Chrissy LeMaire <[email protected]>

New command - Set-DbatoolsInsecureConnection (#8849)

7633c6c833464738f04ca11cf8a9c5bb08145d6b authored almost 2 years ago by Chrissy LeMaire <[email protected]>

Get-DbaLastGoodCheckDb - Support Azure (#8836)

163a941751f57e2d1d94afea35ecf6b87612572b authored almost 2 years ago by Chrissy LeMaire <[email protected]>

Sync-DbaAvailabilityGroup - Show details for objects being synced when using whatif (#8844)

1b0c7d39749c4f962481d6ed6ac63d6b2598e421 authored almost 2 years ago by Chrissy LeMaire <[email protected]>

Add back SSIS commands for non-core PS (#8843)

18a7e31c73c0433b0eebc764875ec2605ae66fe2 authored almost 2 years ago by Chrissy LeMaire <[email protected]>

Added Filter functionality to Get-DbaDbUserDefinedTableType (#8834)

5a9f1339d4fe376455afa377376abfd75e926758 authored almost 2 years ago by sqlarticles <[email protected]>

Write-HostColor - Fix issue in Linux (#8839)

368fd8d7c5bfd8f092eeb02dde3fdc5db0c112ff authored almost 2 years ago by Chrissy LeMaire <[email protected]>

Attempt to resolve default shell issue in devcontainers (#8837)

4d09cc72d59d9a4833b834d4d6d877a495e15166 authored almost 2 years ago by Chrissy LeMaire <[email protected]>

Skip Setting Default Log Shipping Monitor (#8832)

9c9bb4810956f9fcfbac87ec30f2f9b8c738b59c authored almost 2 years ago by josh <[email protected]>

Find-DbaOrphanedFile - Fix path in non-Windows (#8835)

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)

6b88dcc9492a326727376b7c43990d705d423833 authored almost 2 years ago by Chrissy LeMaire <[email protected]>

Contributing guide update (#8822)

d0ab2114a305ad58b1dd325a7defabb4f1e9cabe authored almost 2 years ago by Shawn Melton <[email protected]>

New-DbaDbUser: Refactor and added contained user creation (#8827)

728fca164b31482370c161dd03528b3188b46f0a authored almost 2 years ago by sqlarticles <[email protected]>

Set-DbaNetworkCertificate: Try to determine key algorithm and use appropriate extension class (#8818)

cf787f466e6136a511c486d02c251a220629c384 authored almost 2 years ago by Alexander Rose <[email protected]>

Implementing Test-DbaPath for Testing Copy Folder for Log Shipping Secondary (#8826)

279e8f250f7b997f60cd8183884dad8fee8a6b52 authored almost 2 years ago by josh <[email protected]>

New-DbaDbSnapshot - Support special characters in database name (#8830)

d028d01de32c3f1352dfbb039786a3b68decdc50 authored almost 2 years ago by Simone Bizzotto <[email protected]>

Updates to devcontainer configuration (#8823)

d7509c6eed18ab9aa5f6eaa11bfc6517aafaecf6 authored almost 2 years ago by Shawn Melton <[email protected]>

Update dbatools-buildref-index.json - SQL 2022 CU2 (#8813)

84c256595b0c016cf95f693f8c9c1f241c7987bd authored almost 2 years ago by Mikey Bronowski <[email protected]>