Office Hours: Ask Me Anything in Icy Strait Point, Alaska

Описание к видео Office Hours: Ask Me Anything in Icy Strait Point, Alaska

I'm in Alaska on a cruise! I took your top-voted database 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?

Комментарии

Информация по комментариям в разработке