There's a thing that Google, AWS and Microsoft all have called the "Well Architected Framework" with 5 pillars (AWS invented a 6th pillar later that seems superfluous).  Those pillars...

Thoughtful article, Steve. We're making lots of moves to the cloud. Not all at once, but in pieces. Currently moving test SQL databases to the cloud. I love going...

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