Isnumeric() isn't perfect. You could get a positive result with a value that can't be used in mathematics. Check your data.

It can.

The scary thing is that some of these attacks might become commonplace to move stock prices and we'd see criminals do some trading about that. Or they might start to...

And poorly doc'd topic.

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...