I agree with Grant for the most part. It's hard to say what you should know how to use without knowing your job.

For a developer, I think that the INFORMATION_SCHEMA...

You have to write the logic in the Agent job to do this, and likely set this to be a shell type of job. T-SQL jobs can't see the filesystem.

What does @result contain? also, what is the @response. Not the converted value, but is there XML here?

It is. Fascinating how the workday changes when it's down.

I think it's a great tool, I just wouldn't put it in the middle of the chain. I'd have it as...

Ah, I didn't think the ID was counted, but as it's in every dataframe. I'll correct that.

Renaming the variable as well.

I sure do. Used to lose Internet out here. We were the max distance from the CO (around 19k feet) And there would be intermittent issues at times with either...

@rod

Normal has some odd definitions to people. When I worked in a mainframe environment, we knew thing were going down when everyone stood up in their cubes. This happened multiple...

I know a few people that like the Slack channel sending, which we even added to SQL Monitor at Redgate. I agree a central spot to get some alerts...

LAG is what I'd use as well, though really this is something we want to handle more in the front end as the positioning and rendering of the spaces in...

Rebooted old node and tried again after failover? I assume this is shared storage clustering, so the same master.mdf was scanned with dbcc?

If so, I'd fail back and try again....

Interesting discussion. I'm a fan of unit testing for a few reasons, but not "over testing". Test what you are working on, which might be alter the test.

Here's what I...

That's an interesting idea. Might be worth scanning those, though I'd expect you get some alerts when you apply patches. I haven't heard issues with SQL Server binaries, but I'd...

If someone is loading 27k rows into a dropdown, it can work for search/typing, but the render time might be high.

Any activity for the database should change the timestamp. DBCC does create a snapshot, which I'm guessing marks some sort of item in the file.

For others, use OUTPUT clause - https://docs.microsoft.com/en-us/sql/t-sql/queries/output-clause-transact-sql?view=sql-server-2017