There's clearly a memory shortage somewhere. There are lots of memory clerks in the SQL OS, so I was thinking to reduce this to be sure the max memory is...

Disclosure: I work for Redgate Software

At Redgate, we have various automation tools to help deploy database changes automatically. Other vendors to as well. There are also ways with MIcrosoft using...

Thanks for the update, and I agree. Sounds like networking. Be interested in the solution if you find it.

Never used it in Britain, but I did use a EuroRail pass thirty years ago to travel around the continent. I wonder how many will stop going now altogether. I...

Not necessary, but I'd argue it's a good practice and habit to get into. It clearly sets out the transaction, which can be lost in code, and it allows you...

Smoke Tests - http://softwaretestingfundamentals.com/smoke-testing/

The idea is that you decide what things need to be working for your application to be stable. This might be

• The service is running
• Any...

And use try..catch

I did see this (https://social.msdn.microsoft.com/Forums/sqlserver/en-US/60d20f7a-8d64-48b1-ade9-8ba648e5945c/there-is-insufficient-system-memory-in-resource-pool-default-to-run-this-query). I might reduce my memory slightly and give the OS more and see if that helps./

I look at this in two ways. One is that you have scripts to run which are specific to a db (check something, verify something, etc.). In these cases, you...

This sentence doesn't quite make sense: Honestly, I do not know how they are trying to auto deploying like generating script in VS and running need to confirm

Doesn't your schema...

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.