How to assign User Connect Permissions to Azure DB[pastacode lang=”sql” manual=”CREATE%20USER%20%5Bemail%40domain.com%5D%20FROM%20EXTERNAL%20PROVIDER%3B” message=”” highlight=”” provider=”manual”/]How to find current Roles assigned to Azure DB[pastacode lang=”sql” manual=”SELECT%20DISTINCT%20pr.principal_id%2C%20pr.name%2C%20pr.type_desc%2C%20%0A%20%20%20%20pr.authentication_type_desc%2C%20pe.state_desc%2C%20pe.permission_name%0AFROM%20sys.database_principals%20AS%20pr%0AJOIN%20sys.database_permissions%20AS%20pe%0A%20%20%20%20ON%20pe.grantee_principal_id%20%3D%20pr.principal_id%3B” message=”” highlight=”” provider=”manual”/]How […]
Tag: db
There Was a Problem Communicating with the Citrix Delegated Administration Service
I was swapping DB’s on a Citrix cluster , I shutdown the DB’s per Add-PSSnapin Citrix*Set-LogSite -State DisabledSet-LogDBConnection -DataStore Logging -DBConnection $nullSet-MonitorDBConnection -DataStore Monitor -DBConnection $nullSet-MonitorDBConnection -DBConnection $nullSet-AcctDBConnection […]
Modify Fortinet FG-100D to Decrease Fan Noise
Recently I got hold of a Fortinet Lab FG-100D. The Fan in this unit is around 50db and not suitable for a lounge. The device is not […]