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.

Seems to work. Used two databases here:

Results are :

1 X

2 NULL

USE compare2
GO
CREATE TABLE TriggerTest (myid INT, mychar CHAR(1))
GO
CREATE TRIGGER tri_triggertest ON  dbo.TriggerTest FOR INSERT
AS
BEGIN
  ...

Indexing would be the only way I see to make this faster. Whether you use a CASE or Phil's solution, I wouldn't expect one to be appreciably faster.

I did an...

I'd wonder as well if there were some personal connection or perhaps some other non-business reason.

The only reason most people care about where you are in the cloud is governance....