Like Jeffrey, I would be cautious about removing sysadmin via an automated task.  One typo in that script and you could blow out all sysadmins.

Permissions are something I prefer not...

I do not have one of those, but I am pretty sure they are essentially just HID's (human interface devices) in Windows and LIKELY is simply a mouse-emulator

I have a...

I would reach out to Microsoft on this one as it sounds like a bug that they will need to fix.

If they are not rendering on workstations, it sounds like the fonts are not properly installed on the workstations.

My first step when working with fonts is to make sure that...

I think you are missing a "LEFT" on your RIGHT.  You have the RIGHT side of the string, but have too much.  So, what you probably want is:

            
December 16, 2020 at 9:22 pm
            
#3821366

            
            
                                                
        

My understanding of this - the assembly needs to be signed outside of SQL Server.  If you have the source code to the assembly, then you should be able to...

Did you follow the directions in the error message?

"By default, only administrators have access to the Integration Services service. On Windows Vista and later, the process must be running with...

My first question would be why are you running that from SSIS?  That feels like overkill when windows task scheduler can handle it perfectly well.  And failing that, SQL Server...

I am pretty sure the proper way to fix that you need to change the service account for the SQL instance to a domain account.  Once that is changed, you...

For the first question - writes refers to changing data.  a SELECT will have 0 writes, while an INSERT, UPDATE, or DELETE will have 0 or more writes.  A "write"...

I can't speak for the scale out part, but for the rest, I think it really depends.

For the ports, I recommend any that are not in use and that your...

To add to Ant-Green's comment, you may want to capture what queries are being run as sa too.  Knowing that sa logged in is one thing, but if it is...

I forgot about the advent of code as well.  They are fun (and challenging) puzzles for sure.  Would be nice if they listed some global "rules" like that the solution...

That is also a lot of NOLOCK hints... are you sure you need those?

I wonder if you'd get a performance boost by dumping the data to a temp table or...

Is this advertising your product or spam?

If you could provide more details about what the tool does and why we would want to use it, without us having to go...