Hard to tell without code and output given.

Which user? Do you mean the user that you specify as the credential when you create the linked server? This is a credential on the remote database that you have...

It's not quite clear what you mean by API and what you're doing with FileStream (FS).

This is designed to give concurrent access to blob items at a higher rate than...

Please don't cross post.

Replies here: https://www.sqlservercentral.com/forums/topic/sql-filestream-concurrency-support-2

How are the jobs structured? If you are looking for a specific db, is this because you don't care about some, or you really need to know whether to respond?...

You would have a job that runs something like this:

SELECT sj.name
   , DATEDIFF(MINUTE, sja.start_execution_date, GETDATE()) AS MinuteExecuting
   , sja.start_execution_date
FROM msdb.dbo.sysjobactivity AS sja
INNER JOIN...

happy to help. A common mistake that people make.

Couple things. Is port 1434 opened for UDP or TCP? The former is needed.

If you get the port for the named instance, can you connect remotely? This is in the...

That's a good test. Did the person with the cert try anything outside of the training? Did they actually write their own trigger or just read about how they work?

Those...

Good comments. The certifications do show some motivation and effort. Not sure they do a lot to test competency, but at least you know someone can learn and memorize something,...

A double-edged sword, but I...

This is definitely a big theme through my career. Trust is very easy to lose and tough to regain. If you can't be sure don't promise.

I'm not the cleverest...

Databases are separate things.

You could query for select count(*) from sys.fulltext_indexes and run that through a loop or sp_msforeach_db to execute in every database. That's the only way you can...

Express has little power and data limits. If they live with those, and perhaps they can, then it will work fine.

I'd think there is some admin headaches, someone might move a file or delete something thinking it's not important. There might be corruption that goes undetected, but those are really...