Klaas
Klaas
Hi Mikey thanks for this: the profile-account association is indeed missing and interesting. Since in both cases the associations are fetched via a method, I assume it adds some searching....
@L3onard80 `Get-DbaPermission ... | Select grantstatement` or `Get-DbaPermission ... | Where PermState -eq 'GRANT'` won't do?
@L3onard80 I'm sorry, that was meant as pseudo code. Be careful: Get-DbaPermission will always create a grantstatement and a revokestatement, even if the actual permstate is DENY or anything else....
I would agree if such a parameter made the function faster. If not, filtering should be done with a Where-Object or Where() method. What I see as added value is...
@marcingminski deploy of the dacpac to a Managed Instance fails: - with dbatools: "WARNING: [14:54:11][Install-DbaSqlWatch] DACPAC failed to publish to SqlWatch on myserver.database.windows.net. | Error connecting to [myserver.database.windows.net]: DacInstance with...
tested again with dbatools 1.1.126 => issue is still there
I created this function because at that time the log files held more information than the CommandLog table, e.g. index fragmentation. Now I found those numbers in the [ExtendedInfo] column...
@kisantia it is the first time I try to build a proj, so I have no idea since when this problem exists I can share the proj later (on holiday...
```xml DBA_DB {8FF4226E-F67B-4C5E-BBA1-176896CD6165} Microsoft.Data.Tools.Schema.Sql.Sql150DatabaseSchemaProvider 1033, CI ```
@zijchen "No sources found."