Find out ENABLED GUEST user in all registered SQL Servers with HTML output via PowerShell

Use PowerShell to determine which registered SQL Servers have the ENABLED GUEST user with HTML output.

Tasks:

1. Extract the list of all registered SQL servers.
2. Get a T-SQL script ready.
3. Get the HTML and CSS style ready.
4. Combine them in PowerShell.

In most cases, locating a user within a SQL server is rather simple. The new system table or the conventional system table can be used.

sysusers
sys.database_principals

However, the user's enabled or disabled status, which is only available through the table, is: sys.sysusers. Let's get right to the coding.

0x80070057: Deploy SSIS Package got assembly error

Error message:

Could not load file or assembly ‘Microsoft.SqlServer.Management.IntegrationServicesEnum, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG)) (mscorlib)

CDC Table Diagram for ODS - Part 1

Finally, I am able to release this from my works. This diagram (part 1 ) was not produced by any ER tool but just via old school way - PowerPoint. 😀😀😀

PDF link here (Diagram PDF download)