Office Hours: Ask Me Anything in Haines, Alaska

After looking for bears, I took your top-voted questions from https://pollgab.com/room/brento. Here's what we covered:

00:00 Start
00:26 James L: When you were an employee, how did you decide whether to move on to another job? I think a similar dilemma exists when you're trying to decide whether to move your own business into another phase.
01:33 QueDayTa: Hi Brent - Can you point us to what the best practice pattern is for a simple, full table refresh, Oracle-to-SQL Server ETL job? Problems: blocking, locking and execution time. We've resorted to RCSI, DELETE vs TRUNCATE vs ALTER TABLE [...] SWITCH. Thanks.
02:21 Bandhu: In SQL VM is it better to retire excess CPU cores or turn on compression to utilize the excess cores? How do you decide?
03:06 Erzsebet: What are the best and worst use cases you have seen in the field for SQL CLR?
04:08 Frank: Hi Brent! Loved your cloud training course. Followup: How bad is connection stability nowadays compared to on-prem? I read horror stories from the early days of Azure SQL. Is hardening the client code with retry logic everywhere still needed? Thx
05:00 Yusef: We need to regularly update our first responder kit installs. Is the same also true for Ola maintenance scripts and sp_whoisactive?
05:39 Shahid Kapoor: What is your opinion of WorkloadTools for capturing and replaying SQL workloads for perf testing?
05:48 Wilson Souza: Hi Brent ..I have a SQL job scheduled to run at 7:30 PM , but after reboot the server, the schedule changes for 7:30 AM.. SQL server version 2019. Any idea? Thanks for your help
06:37 Rose Noble: What are your pros / cons for long term vs short term DBA contracting?