[Video] Office Hours Q&A: Abrupt Exit Edition
Last week, we had an abrupt intro, and this week, we have an abrupt ending when my camera overheats, hahaha:
https://www.youtube.com/watch?v=pQOk2N3ljCc
Backup, Restore, and Database Integrity
Backup design, restore testing, integrity checks, and corruption response.
292 associated posts117 primary posts
[Video] Office Hours: Abrupt Intro Edition
Today's Office Hours had a ton of technical difficulties because it was my first live stream on both Twitch and TikTok. The first few minutes were cut off, and you can't see the questions onscreen. Nonetheless, there are good answers in here, so let's do it:
https://www.youtube.com/watch?v=Nv0Wnli6kaE
Production DBA
As a SQL Server DBA, Postgres Backups Surprised Me.
I've worked with Microsoft SQL Server for so long that I just kinda took backups for granted. We run a backup command, and SQL Server: Logs activity to the transaction log while the backup is running Reads the exact contents of the database files, and writes them out to a backup file When it's done,…
[Video] Office Hours with a Special Guest: Count Distinct
I was busy, so I asked a friend to fill in for me and answer your top-voted questions from https://pollgab.com/room/brento. He did a pretty good job:
https://youtu.be/oaRIxcf8sKE
Production DBA
Two Tweaks for Faster Backups with Ola Hallengren’s Scripts
Ola Hallengren's free maintenance solution is widely used as a replacement for SQL Server maintenance plans. It's a more powerful, flexible tool for backups, corruption checking, and index & statistics updates. If you're using it for backups, there are two quick, easy changes that can dramatically reduce your nightly job runtimes. First, set @NumberOfFiles =…
[Video] Office Hours: 16 Questions
Like Sixteen Candles, but different: I go through your top-voted questions from https://pollgab.com/room/brento. Strangely, my video and audio is ever so slightly out of sync in this episode.
https://www.youtube.com/watch?v=mmward6JyOw
[Video] Database Answers in Hong Kong
As my time in Hong Kong came to an end, I sat inside on a foggy morning and hit your top-voted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=jylCG2l6YSA
[Video] Office Hours: 25 Answers in 10 Minutes
It's time for a speed round, a rapid-fire tour of your top-voted questions from https://pollgab.com/room/brento:
https://youtu.be/NzO-MN8VJiE
[Video] Office Hours: Speed Round
Not all of the questions y'all post at https://pollgab.com/room/brento require long-winded answers. Let's conquer 22 questions in 15 minutes!
https://www.youtube.com/watch?v=XGvqkIRwupk
[Video] Office Hours: Hot Tub Edition
Today's Office Hours comes from a very different office! I climbed into the hot tub to review your top-voted questions from https://pollgab.com/room/brento. Don't worry, the webcast is completely safe for work.
https://www.youtube.com/watch?v=e1jg1_uHBxM
[Video] Office Hours: Ask Me Anything About the Microsoft Data Platform
Forgive the hoarse voice - I'm recovering from something COVID-ish. I went through your top-voted questions from https://pollgab.com/room/brento and did my best:
https://youtu.be/x-x4j_VND-s
[Video] Office Hours: Oddball Questions Edition
The last Office Hours of 2023 featured some oddball questions from https://pollgab.com/room/brento. Not bad, just ... odd.
https://youtu.be/prkpWssHsaE
[Video] Office Hours: Wrong Side of the Bed Edition
I woke up on the wrong side of the bed after a nap. How does that even happen?!? To take the edge off, I poured myself a gin & tonic and went through your top-voted questions from https://pollgab.com/room/brento.
https://youtu.be/5lF0RtdBPP8
[Video] Office Hours: Sunshine Edition
You know how this works: you posta the questions at https://pollgab.com/room/brento, and I giva the answers:
https://youtu.be/o1pDHHDS4R0
[Video] Office Hours: Live on Black Friday Edition
On Black Friday, I took a break from answering support emails to hit your top-voted questions from https://pollgab.com/room/brento.
https://youtu.be/ridbqcclXuY
[Video] Office Hours: Black Friday Promo Edition
In this episode, a lot of the questions triggered mentions of our Black Friday Sale, on now!
https://www.youtube.com/watch?v=9UU3Rj4CaVM
[Video] Office Hours: Brent’s Cursed Technology Edition
I first answered these while standing at a harbor in Maine, but upon arriving home, I realized my camera had failed to record any audio. Doh! So I took the list of questions from https://pollgab.com/room/brento and streamed 'em from my home office in Vegas instead.
https://youtu.be/IwAz7lCZK_Y
Office Hours, Silent Film Edition
Hey, remember in yesterday's video how I said I was having a really bad day? Well, here's how bad it was - I recorded two videos in a row, and I forgot to turn my microphone on for the second video.
https://www.youtube.com/watch?v=JXcDlrLXZvw
[Video] Halloween Office Hours in Salem, MA
I visited friends in Salem, Massachusetts, home of the 1692 witch trials, and it turns out Salem is a great place to visit around Halloween! There were tours, characters in costume, witch gear shops, and all kinds of spooky-themed happenings.
I sat down outside of the Charter Street Cemetery to take your top-voted questions from https://pollgab.com/room/brento:
[Video] Office Hours with a Surprise Special Guest
I have a special guest star on today's episode: Pinal Dave dropped by the house! We went through a few of the top-voted questions from https://pollgab.com/room/brento.
https://youtu.be/vXuzpa41BW8
