My opinion - you get what you pay for.

The authors of the books need to make money, so they write books on what they know.

If free training is what you...

Found this article:

https://dba.stackexchange.com/questions/114572/why-does-updlock-cause-selects-to-hang-lock

From that link, the solution is to have a better index. Now, that being said, I would expect that since you are doing a SEEK, your index is...

Sounds to me like windows permissions are set wrong.  You said you can't access it from Windows run menu OR from SQL Server, this makes sense.  If you have no...

Have you tried using CAST or CONVERT to pick a data type on the column that has an unknown datatype?  Not the best solution, but will solve the problem.

What I...

Gotta love it when SQL can't guess how long the rollback will take so it tells you 0% and 0 seconds.  I've seen that before and there is that panic...

Sorry I couldn't be more help, but I am stumped on this one.

I am confident that restarting the SQL Server service will fix the issue, but I am confused why...

Well, I'm confused... the query I gave should have shown you the rollback status on the query.  Since sysprocesses and sp_who2 are both saying it is rolling back, my next...

Since the query didn't return anything, my thought is the rollback completed successfully. Where are you seeing the "killed/rollback" information?

I am pretty sure that if the SSIS service is not running, you can't do most SSIS related tasks such as deploying to an SSIS catalog.

I am a little surprised...

Our solution is a bit different than yours, but our RTO and RPO drives it differently than yours does.

We used to use maintenance plans, but have switched over to direct...

Pretty sure you are just stuck waiting for it to finish rolling back.

Basically, if the query made changes to anything, SQL needs to undo those changes.

I would check the results...

To me this sounds like the audit is running as a different account than the backup.

When you create the audit file on the local drive, who is the "owner" of...

Since it is going out to a network share, it could be that someone else is doing something on that share at the same time as your backup.  I am...

My first step - check the logs.

Is the error coming from the load balancer or SSRS?  Do you get the same error if  you go directly to the machine rather...

Check your execution plans.  That will be the best way to tell what is changing with performance.

As for returning NULL when there is data, chances are the stored procedure is...