Get-DbaPermission and Get-DbaUserPermission would be the starting point for a permissions extract, is uses the DISA STIG script so people find that a handy one if they need to comply...

If you save the plan as a SQLPLAN file and attach that would be best, failing that use https://www.brentozar.com/pastetheplan/ and share the output link

Once the index is dropped all remnants of it are removed from all system tables, so its like it never existed.

Do you have version control for your database schema, where...

If you use Automatic Seeding, the log is unable to truncate, thus you CANNOT backup the log while seeding is happening, resulting in an impacted RTO/RPO, so you need to...

Its whatever you want to get involved in to be fair.

Welcome and SQLHelp probably the two busiest channels.

BrentOzarUnlimited if you're ever in one of Brent's training classes / live streams...

Can you post the complete error message and obfuscate the servername/loginname etc.

Has the driver you are attempting to use been registered on the SQL server and all client machines where...

Not defending the admins at all, but as RedGate now own PASS and they have just announced the new conference, I guess the likes of Steve / Grant have all...

Yeah thats what I was eluding too.

Something going on with my Visual Studio and not displaying results in the tablix as I have tried to repro this in some way...

Suspect mode is something is wrong with the database, missing files, corruption of header pages, could be a wide variety of issues that cause suspect mode.

Suspect mode is not resolved...

Don’t know the reasoning behind it but since SSMS and the installer became different items the config manager start menu item hasn’t been deployed either.

It’s still on the system as...

Automatic seeding has a number of limitations.

Depending on the size of database(s), network speed between sites, distance between sites, number of databases to seed etc it can take a considerable...

I’d do it as an alter database modify file, offline database, move the file, online the database.

This is just to get around the permission changes which happen with a detach...

You could use two datasets, and filter the second data set.  Data retrieval times would double as your executing the proc twice but that’s how I would implement Brian’s solution.

My...

I take it you have no monitoring software already deployed as that would be the first thing to go check.

If you don't I would suggest getting something in rather than...

Wouldn't a simple filter on the tablix suffice?

Use 3 different expressions

IF 1 THEN IN A and B

IF 2 THEN IN C and B

IF 3 THEN IN D and B