While in beautiful Haines, Alaska along the Chilkoot River, I stopped to take 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?