The company I'm working for now is preparing to make a major jump to the cloud.  I'm struggling with their reasons for the move, which seem very abstract and...

Thanks for the list....

https://ayende.com/blog/198945-B/on-ai-gpt-and-the-future-of-developers

I prefer:

;


-- ^
-- |
-- |
-- semi colon above because most of you don't use them
WITH mycte ....

typing while not thinking. This is fixed. The no_truncate option is needed

You're one of the lucky ones. Sometimes outsourcing benefits people, but usually when it's a small number. when it's a large group, a few people might make more money, but...

Lol, not sure that's the place for a variable. Silly me still in the habit of typing 2022.

It's fixed.

I created a new body.

There were some connection issues, and I'm guessing I added the question and it didn't save. I didn't notice, so I need to go back and...

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