[Video] Office Hours: Icy Strait Point, Alaska
I’m on a boat! We took an Alaska cruise with some friends aboard the Norwegian Jewel. En route to Icy Strait Point, Alaska, I took your top-voted questions from https://pollgab.com/room/brento.
Here’s what we covered:
- 00:00 Start
- 01:40 RollbackIsSingleThread: Hi Brent! If a high-quality blog post involves original ideas, T-SQL, a great demo, and images to prove a point, but uses an AI tool like Grammarly or Google Translate to edit the content, Google might delist it. Any idea?
- 03:27 MyTeaGotCold: Can you think of anything that the Service Broker is the best solution for? Modern alternatives seem better.
- 04:37 JustWondering: Do you have a sense of what percentage of your followers are administering systems that are “custom built” vs “vendor app” dbs?
- 05:13 Miss Minutes: Once SQL AG is stood up with two HA nodes and an offprem DR node, are SQL full backups necessary any longer?
- 05:47 some_like_it_encrypted: Does people use Always Encrypted? I have the feeling that it’s quite an unused feature.
- 06:53 chandwich: Have you ever successfully changed a database collation for a large database with numerous constraints? Any tips for doing this?
- 08:43 Daniel Izzaldin: Hi Brent, do you have a course or do you know a course that teaches you how to become a Consultant.
- 10:29 Logar The Barbarian: Hello! Is sp_DatabaseRestore expected to work with Azure/blob backups? From my review of the GitHub, it does not appear so. If not, what would you suggest for restores to other servers? I like sp_RestoreGene for same servers but it may not work for DR/test restores. Thank you!
- 11:40 Laslzo: When an sp needs a long list of input id’s, do you prefer comma delimited string or a table value param with all the ID’s?
And that zipline that I mention in the video? Yeah, that was pretty awesome.
