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

New-DbaAgentOperator - ensure params are only used when passed in by caller and enable pipeline input (#7188)

* New-DbaAgentOperator - ensure params are only set when passed in by caller

* Incorporating ...

fc20a3d29635d2d4c9305819a73859dccac39b58 authored almost 4 years ago

Merge branch 'development'

f7c0e68da955dde95bbcf79caaef8837fdfed808 authored almost 4 years ago

KB5001090 - CU10 for SQL Server 2019 (#7233)

d6bc0056d987fb46de07ae2c447de36cdf094c1d authored almost 4 years ago

Further tweaks for AppVeyor

niphlod advised to move the param up one so exception is the last param.

also added the param t...

d031278799edafbc50a6af97ba6234ec18f8526e authored almost 4 years ago

Update Install-DbaMaintenanceSolution.ps1

Updated on suggestions from niphlod

512b0ad857065e7ee80dad0934110cd56bee6d9a authored almost 4 years ago

Update Install-DbaMaintenanceSolution.ps1

Added Queue and QueueDatabase to the list of required scripts for anyone who wants to use the Da...

ec7dde6da2029e189db11562b1362502ef3fe50c authored almost 4 years ago

New-DbaAgentJobStep: ensure the job object is reloaded from the server (#7209)

74b56baa04087d0ecbdac4a2a2b5e63ded73bcb6 authored almost 4 years ago

The function works on all databases, but tempdb (#7230)

5b33f70937afd0a8544f1c374bb96f36087a8b8f authored almost 4 years ago

1.0.142

7f5686f252959cb986bfb1236df0d36ee8c5d3bb authored almost 4 years ago

Update readme.md

dacc1985a878b3f4dcb053f262100eb5868de307 authored almost 4 years ago

Copy-DbaDatabase: ensure -Continue functions and that backup info is not duplicated (#7202)

1dcf938a966ffc758f06af33fbacc5a9351500ff authored almost 4 years ago

Get-DbaAgReplica - ensure that EnableException is passed to Get-DbaAvailabilityGroup (#7174)

43a634cab2c3f41df6d709bdd20ff6e509cfb4e5 authored almost 4 years ago

Set-DbaTempDbConfig: allow for multiple strings for -DataPath (#7208)

502a3563790f14ce818002f9e7b8403f6f5cc750 authored almost 4 years ago

Merge branch 'development' into 7143

dd5f8651b2bc8a17b30ba9eee1f12c78b6d244eb authored almost 4 years ago

Merge pull request #7218 from MikeyBronowski/patch-2

Update Add-DbaServerRoleMember.ps1

51d3b5f2760eb2226eab203419cc9993574ac244 authored almost 4 years ago

Merge pull request #7205 from krokofant/patch-1

Fix Get-DbaKbUpdate search (#7204)

08522fb4cdb35553172fdcb97bc0d65e069913ec authored almost 4 years ago

Merge branch 'development' into 7143

2bc8e89de51c7f178fc48ead6c2cbabf8e15f549 authored almost 4 years ago

Fix Copy-DbaDbTableData when new table name has number at start (#7196)

When copying to a new table with the -AutoCreateTable switch, the -replace function when updatin...

68d3a01f7a12829fce4710a4181e41dcfda8f21f authored almost 4 years ago

Test-DbaSpn - ensure the string replacement for port numbers only replaces the instance name portion of the SPN (#7191)

dc7d983260d2c2840b479b64e3b6e53ad135e264 authored almost 4 years ago

Import-DbaCsv - add the integer wrap fix for the result object (#7190)

Write-DbaDbTableData - update documentation and remove the check for a 32 bit integer

c663fe5c39cfe42e2a1e6bb1b5843c7cf10eb578 authored almost 4 years ago

1.0.142

a4a7aae756d504cbd3f7b594eb1279598368de22 authored almost 4 years ago

Set-DbaLogin - implement warning message if policy settings are not enabled (#7183)

2d115b1e5979baa1a21159eae3bc3c18e636b6de authored almost 4 years ago

New commands for interacting with sequence objects (#7181)

6d3ffb933501b83835d1846f6bc5988d0c89d2d9 authored almost 4 years ago

New-DbaDbTable - ensure schema is created if it doesn't exist (#7154)

0bba678d35181188e1db023a0a38fb4685e58e24 authored almost 4 years ago

added cu17 for 2016 (#7221)

7ec6d195fc4128b2882758a24639b8c875fd2e93 authored almost 4 years ago

Update Add-DbaServerRoleMember.ps1

Update description that seemed to be copy/paste from database roles

56c687f5ad17291b1fdda1982dfae87ea31d39d4 authored almost 4 years ago

Fix Get-DbaKbUpdate search (#7204)

3f28df953bec69ece6f56454fd7d32c55d279a77 authored almost 4 years ago

Watch-DbaDbLogin: Enable pipeline input and ensure CMS can be used

4ffbd4eb65fd8eda14beaac3e87ffe51cec11cb5 authored almost 4 years ago

1.0.141

09a536f038615dd6e01feef53d4482e91ba043e1 authored almost 4 years ago

Import-DbaCsv - ensure the reader is closed in the inner loop (#7165)

6336ca8c032541e4d01654e1e466fc06ae9b1993 authored almost 4 years ago

Export-DbaLogin - ensure that 'if not exists' is generated in all cases (#7164)

89a749a38479ea1cdf741170e4d491b48b46cd14 authored almost 4 years ago

Merge pull request #7163 from GLoeffler14/development

Fix New-DBADirectory

223e2dd9f8b7700e60b222943735f99e87229765 authored almost 4 years ago

Merge pull request #7151 from SamWalkerRxSense/circ_ref

Get-DbaDependency - detect a circular reference

bd2c8c2d41bebcb181a2aeeecde7b89c9b425925 authored almost 4 years ago

Add config item to bypass CredSSP initialization (#7150)

* Add config item to bypass CredSSP initialization

* add configuration setting "commands.init...

bc45da7f6d45c1c349374b601af6bd3e9b558510 authored almost 4 years ago

New commands: New-DbaCustomError and Remove-DbaCustomError (#7110)

* New commands: New-DbaCustomError and Remove-DbaCustomError

* Adding the documentation for t...

9b84d3b424c34514f3484a5d5628c52e6b1c4604 authored almost 4 years ago

Fix Get-DbaDatabase join for Azure databases (#7100)

Databases where the owner is not in the sys.database_principals table do not get returned due to...

691a383c7b358de6bc68a5615fa45f0cd8ac20f1 authored almost 4 years ago

Set-DbaLogin - validate the usage of -Unlock and provide a -Force option (#7142)

- Added a -Force param so that an unlock can be done without a password change.
- Added validat...

5d5c7177b02ff6c6faffc21c55288302e257adfd authored almost 4 years ago

Fix invoke-Parallel in PowerShell 7 (#7167)

* fix Invoke-Parallel on PowerShell 7

* test for presence of Get-PSSnapIn command before
t...

b79770a75d4e866a221c1a13fdf5473ad8743283 authored almost 4 years ago

Changing param to 'Schema' (#7178)

101695556ce206976715b7ad530cc6a59a1cfaf7 authored almost 4 years ago

adding new schema functions (#7175)

7103b44e3b82d8c3dc27d7824fae3696ce36c923 authored almost 4 years ago

New commands: Set-DbaDbSchema and Remove-DbaDbSchema (#7157)

* New commands: Set-DbaDbSchema and Remove-DbaDbSchema

- Set-DbaDbSchema allows the schema ow...

aea71abfd6ab6f1cec6118fa714035b1c74080a9 authored almost 4 years ago

Remove-DbaDbMirror - update examples and additional error handling (#7121)

* Remove-DbaDbMirror - update examples and additional error handling

* Removing the tab chara...

61586f037b8258417336888915dc54e4b6eabc7f authored almost 4 years ago

buildreference, added 2017cu23 (#7171)

* added 2017cu23

* fixed json

6b11651714ca681675720d54686335d7d73d6ea9 authored almost 4 years ago

Removed -sqlcredential from the $exists line since no longer needed

e916c9ce343fd12e0c5d409ae8761efc4661a759 authored almost 4 years ago

1.0.140

e900564443303f4600b68077a72f292d89dcef43 authored almost 4 years ago

Update New-DbaDirectory.ps1

a43724e4da29e20a095070e51a8dc7f84daaaa14 authored almost 4 years ago

Update New-DbaDirectory.ps1

0bc3f453668e349815b5744a7fcd49f6f56a7e2c authored almost 4 years ago

add new schema functions (#7156)

fbb7b39f1859ca9ba3283621808061567bae311f authored almost 4 years ago

Update New-DbaDirectory.ps1

Fixes 2 bugs.
1.) the $exists variable did not properly reference the enumerated items inside t...

b692c51bd95b13cfe30103d47493d4c604047049 authored almost 4 years ago

Merge branch 'development' into circ_ref

0de303f26e21563e9e4ff7a4595bbb36db8640f2 authored almost 4 years ago

Move-DbaRegServerGroup, Get-DbaRegServer - update example and ensure properties are set (#7113)

* Move-DbaRegServerGroup - update example for pipeline input

* Get-DbaRegServer - ensure prop...

368aa13c08b99865071a650307e11a9214688b45 authored almost 4 years ago

Invoke-Command2: change session cache key to fix leaks (#7149)

f11bb02e3e311fceee632121e6166a416a7ae73f authored almost 4 years ago

format Get-DbaDependency

ac4b26a4db382f1f6af7e88f3fe0a5c2240ec691 authored almost 4 years ago

remove changes for local testing

14f30f495149b97e3f8fb505449158d16dda7d2a authored almost 4 years ago

support -IncludeSelf flag

79197ef5521379e5bd6fc25f9914755da5243228 authored almost 4 years ago

add read-parents

e12b9337cfa20ac31cb648cbf1ecedb7116b70ac authored almost 4 years ago

Merge pull request #7141 from DiHo78/patch-1

added SQL srv 2016 SP2 CU 16 to buildref-index

fcdb8a232bd33d857e6b0d9d909bff0e30322e0a authored almost 4 years ago

Merge branch 'development' into patch-1

9297cdd520dceb7d9b60c27e9cd6c10551a39f1f authored almost 4 years ago

add new functions & up moduleversion

a50c6ea715903f6efc5f08f464c23b4cbfa8eb07 authored almost 4 years ago

New commands: New-DbaDbSchema and Get-DbaDbSchema (#7125)

* New commands: New-DbaDbSchema and Get-DbaDbSchema

* Removing tab characters in the command ...

2316efeaedd370f1e48381ab8eecfd4f5aa3f4af authored almost 4 years ago

added SQL 2016 SP2 CU 16 to dbatools-buildref-index

CU 16 was missing

79bd4b984ce00f9758b72d0d0f1742af134bb5d4 authored almost 4 years ago

Merge pull request #7108 from iampeterdaniels/fix-Get-DbaDbFile-FILESTREAM

Fix Get-DbaDBFile to return filestream file info, too

23633228477211fe832205657e149a04a479eb3c authored almost 4 years ago

Merge branch 'development' into fix-Get-DbaDbFile-FILESTREAM

5632ced33703a95e76829719d15b732f8a110252 authored almost 4 years ago

1.0.139

7777ff68764279f345234e15bf28ff97da9075dc authored almost 4 years ago

Get-DbaDbFile - Add option to filter files by FileGroup (#7124)

47ff0c53cfbf36162f23f203a64197a28f361697 authored almost 4 years ago

Write-DbaDbTableData.ps1: Moving Connection to Server code to the beginning of the Command code (#7106)

247e2fd17db8357d8e0849b46f16e3ab93c3300e authored almost 4 years ago

Merge branch 'development' into fix-Get-DbaDbFile-FILESTREAM

3310f7d0bab86e0834112d8480bb117778780b74 authored almost 4 years ago

- Adding the fix for the integer wrap to Import-DbaCsv and Write-DbaDbTableData. (#7138)

- Refactoring Copy-DbaDbTableData so that the utility function Get-AdjustedTotalRowsCopied is sh...

206c7bf1abd2bdcc65d3ff2714afd182ba4c50f0 authored almost 4 years ago

Restore-DbaDatabase - updating the documentation for -SqlInstance (#7115)

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

7ceafd26d3685e58d4a68627e9aa732ab87b6fb5 authored almost 4 years ago

Merge branch 'development' into fix-Get-DbaDbFile-FILESTREAM

5d1714503d2810a9663fcef695fa8a630cc6e448 authored almost 4 years ago

1.0.138

4ce9b9190234d3b5674dc2caae445991e3f03ea7 authored almost 4 years ago

Remove-DbaDbOrphanUser - ensure 'drop user' command syntax is valid (#7134)

9ed3752d4e05bc5deb9c7b28b3b63a484550aaa6 authored almost 4 years ago

Invoke-DbatoolsFormatter - remove tabs from code comments (#7128)

61198778d8a64cef1ac0e4fb98e37cd202d838cb authored almost 4 years ago

Import-DbaCsv - ensure consistency in the error handling (#7123)

7531d9929601f2df59021b9ef094650425895625 authored almost 4 years ago

added cu9 for 2019 (#7136)

74903df484e4baa139943ad3123a15f11bd1f83a authored almost 4 years ago

Merge branch 'development' into fix-Get-DbaDbFile-FILESTREAM

b22c5a0861a7cf31bce6f108035caf25ecc5508c authored almost 4 years ago

Merge pull request #7097 from lancasteradam/7090

Set-DbaLogin - add a param so that check_expiration can be set

2371d9ac9b14a36ce7239fa144d10f543b668caa authored almost 4 years ago

Merge branch 'development' into 7090

3031167a5035dc8a050919b231941f796d7b345f authored almost 4 years ago

Changed multiple select list items to coalesce nulls into 0

Multiple size related columns return NULL for FILESTREAM, so
I changed them to coalesce to 0 if ...

68bcb269d0e310c59cdc78817a2995308fd4603b authored about 4 years ago

Fix the from clause so the query returns FILESTREAM files, too

By changing the join to sys.dm_io_virtual_file_stats from INNNER to
LEFT, we now also getg FILES...

0251f10d2e11cfa631d45da4a3a2cd03fe57b42e authored about 4 years ago

VS Code settings - disabling format on save

5d8284bf450032c3cf8bfb3da0b3beae9cb05832 authored about 4 years ago

Incorporating feedback

- Updated help documentation
- Added validation for check_expiration

68f851fedde342d107cd5dafafd1859d85567146 authored about 4 years ago

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

15ef1d7370806a395550ad69e6684a6f33aadf79 authored about 4 years ago

Get-DbaPermission.Tests - reorder the integration tests and add debug messages (#7103)

0c519bf3766b0238197f3da2c736e0ad5901d449 authored about 4 years ago

Merge branch 'development'

5212a71bb71a72307c5eadc884cef1918a83846b authored about 4 years ago

1.0.137

603e9eae3169b1e405d53b9f9ac5787c9da10c27 authored about 4 years ago

Set-DbaLogin - add a param so that check_expiration can be set

- Added a new param so that the check_expiration for the login can be Set-DbaLogin
- Added a new...

3a9aecbdaa2c7b359a734f86c6e856bd73cb3b63 authored about 4 years ago

Get-DbaLogin, Set-DbaLogin, Connect-SqlInstance - block use with Azure via AzureUnsupported param (#7087)

c467d0866824d5f6d8fc3643a196fea6e96b7e13 authored about 4 years ago

Manifest update - add Remove-DbaDbTableData (#7095)

5dcc51e7cce91e18661c985a7a929589ec206028 authored about 4 years ago

Update-DbaServiceAccount - doc example formatting (#7093)

02ea07085ca16e526a50b8d2243e1de7ab79d227 authored about 4 years ago

change encoding of build script

68bef55fc268af1a25150d122147ad03588da5e0 authored about 4 years ago

initial build script

bd6898a41e72f33f6b86c66e68c0e8ff6713821b authored about 4 years ago

core file updates

7cd646f733ccd1c5f32080e43535338702b82ac5 authored about 4 years ago

Get-DbaKbUpdate and Save-DbaKbUpdate - minor fixes (#7077)

b91e8eb7182cea16d7212aab043f9afc6c57e3a8 authored about 4 years ago

New-DbaDbTable - Add support for adding identity column (#7065)

96f3439394faf72e5fc7c51583bc873024cabfe6 authored about 4 years ago

Import-DbaCsv - Add support for Azure SQL Database (#7064)

2adda30fe5bece19a82e5db00d28423b820b3960 authored about 4 years ago

Publish-DbaDacPackage - bacpac file detection, output default path, removed GenerateDeploymentScript param

27b45d177aa7faac7ea72483dd3c8444ec7891f7 authored about 4 years ago

[New Command] Move-DbaDbFile (#6979)

87da1110abd54f22745b661529d06816f389a288 authored about 4 years ago

Fix for Get-DbaDbEncryption returns $null reference error (#7078)

c8b44b1907a0cb087915db5b9ba3585c45e1b270 authored about 4 years ago

Backup-DbaDatabase - update typo in docs

67ac7c98e1daed627ef6637118d136a3cd29831d authored about 4 years ago