A few things to read and think about:

• https://www.red-gate.com/simple-talk/sql/database-administration/migrating-disk-based-table-memory-optimized-table-sql-server/
• https://bertwagner.com/2018/04/17/in-memory-oltp-a-case-study/
• https://www.sqlskills.com/blogs/erin/migrating-to-in-memory-oltp-whats-stopping-you/
• http://www.sqlservercentral.com/blogs/confessions-of-a-microsoft-addict/2016/12/27/using-memory-optimized-tables-for-reporting/

No mocking needed here. Lots of people don't use MOT (Memory-Optimized Tables) tables yet, so don't worry.

Here are a few thoughts. First, adding a MOT table means a new filegroup...

For the first one, you ought to have a list of checks, and automate these. These are smoke tests, and would be what you'd want to check each time you...

Interesting. One thing, have you restarted SSMS between changing settings?

Not sure that works.

Couple things I found (since my search might be different than yours)

• https://dba.stackexchange.com/questions/122457/misaligned-log-io-issues-and-unmatched-lun-sector-sizes-in-alwayson
• https://www.mssqltips.com/sqlservertip/5942/sql-server-misaligned-log-ios-which-required-falling-back-to-synchronous-io/
• https://blogs.msdn.microsoft.com/saponsqlserver/2014/10/01/message-misaligned-log-ios-which-required-falling-back-to-synchronous-io-in-sql-server-error-log/ (likely not the issue)

I'd first save and restart. The "cannot load xxx" messages sometimes appear as transients.

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