Great advice from Steve, and more detailed than my response.

The one thing I have done if the updates aren't too large is save off the data from each loop, so...

bacpac - https://learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-export?view=sql-server-ver17

If you quiesce it is, but a bacpac is essentially this: https://www.sqlservercentral.com/scripts/bcp-out-all-table-data-in-your-database

• for each table in sys.objects

  • bcp out <table name>

I get the cloud move, and...

Unlike Oracle, you can't really have nested transactions.

https://www.brentozar.com/archive/2023/02/can-you-nest-transactions-in-sql-server/

Your best bet is to break this into separate transactions with support for continuing or stopping, and then potentially some logic to...

Unlike Oracle, you can't really have nested transactions.

https://www.brentozar.com/archive/2023/02/can-you-nest-transactions-in-sql-server/

Your best bet is to break this into separate transactions with support for continuing or stopping, and then potentially some logic to...

Don't forget that less data potentially could mean less use of the buffer cache from inefficient queries. Not every query uses and index, so buffer cache can still matter.

plus what's...

Jobs? Agent?

Azure Database can have different performance characteristics than a VM, so be aware. There are some limits here. That being said, you can use serverless and get some scalability,...

Something like this?

with cte as 
(
select 'CCTB' dstrct_code,  '000001719' stock_code, '' WHOUSE_ID, '202404' FULL_ACCT_PER, 12 SOH
UNION ALL select 'CCTB', '000001719', '',     '202401',...

I'd start by empathizing with others and trying to see their point of view. Ask them what/why they like things, what's not working well, etc. Open a dialog from another...

The word that sprang immediately to my eyes was "cutover." The plan is not to migrate service instances to new hosts and verify operations in a rational sequence. The...

The first thing I would do is write a migration plan where the cost of going to the cloud exceeds the savings from the cloud. And if the system...

In your editorial you wrote, "[Hiring managers] also mentioned that while checking LinkedIn, they were turned off by people who hadn't added their picture." WOW, yet another way hiring...

Regarding the picture on LinkedIN thing, I'm not a fan of how I look in ANY pictures of me and actively avoid being photographed if I can help it....

My plan when I reach 60 (in a few years' time) is to ask to take on two people straight out of school or college. I hope to retire...

Good catch. Going too fast on this one and didn't read close enough. Corrected and points awarded back.

I love the second-design idea! That's really cool for pushing people out of their comfort zone. On a similar angle, I like to ask, "Give me a few ways...