Fixed, actually built a question. Not sure what happened here.

What you seem to be doing here is reading data from SQL Server, then processing that and inserting data from SQL Server into another table. There's no reason to do...

You might try and see if SQL Edge works better. It's designed for low resource environments, whereas I think SQL Express tends to eat more RAM. LocalDB might work better,...

Since you are querying in SQL, using something outside of SQL strikes me as a place where things can go wrong with capturing the data, as well as alerting on...

Agree with Grant. Something else I look at is how I can batch part of these things. Think about the process rather than the data. Sometimes temp tables and partial...

that column needs to be in the group by. That is what the error means

If you have 1000+ tables, and you want anytime a user inserts/updates/deletes, and you send alerts, how many is that? Can they even be processed?

Usually I hear this and I...

You're complaining a bit about your process with Microsoft's. My point is that any platform will have bugs and issues, and any patch can cause issues. Microsoft has done a...

Be good to have some sample data and sample results here, also what have you tried?

I'd say there is overhead for the OS with RAM, then add in a VM, and you've added more RAM overhead. SQL Server is very memory hungry, and you are...

https://twitter.com/ItzikBenGan/status/1620580822138118151

I don't know that I consider SQL Server 2019 a mess. There were some CU bugs, and the CU16 log format was a breaking, intentional change. I don't like how...

This essentially initializes the file so that only this backup is written to this file.

Recommended practice, back up each time to a new file.

If this feels complex use Ola's script: https://www.sqlservercentral.com/scripts/sql-server-backup-integrity-check-index-and-statistics-maintenance

This encrypt by default has been a pain, since lots connection strings need altering. thanks for posting the note.