[Video] Office Hours at the Arctic Circle
Just after passing the Arctic Circle marker and celebrating with a glass of champagne, I took your top-voted questions from https://pollgab.com/room/brento.
https://youtu.be/gyyxKrv45bQ
Backup, Restore, and Database Integrity
Backup design, restore testing, integrity checks, and corruption response.
292 associated posts117 primary posts
Production DBA
“Oops, I Lost My Indexes in Azure SQL DB.”
I got an interesting request for consulting, and I'm going to paraphrase it: We were using Azure SQL DB with automatic index tuning enabled for months. Things were going great, but... we just deployed a new version of our code. Our deployment tool made the database schema match our source control, which... dropped the indexes…
[Video] Office Hours: Overly Caffeinated Edition
After consuming waaaay too much coffee, I went through your top-voted questions from https://pollgab.com/room/brento:
https://youtu.be/3IyG_W7go7k
[Video] Office Hours: I Need Your Help with These
Today, I need your help with some of the top-voted questions from https://pollgab.com/room/brento. Chime in in the comments:
https://youtu.be/RatZKWnDMGI
[Video] Office Hours: Really Long (and Really Short) Answers
Today's batch of questions from https://pollgab.com/room/brento requires some really long answers, and some are right to the point.
https://youtu.be/O2mGmlq69B8
[Video] Office Hours in Telluride, Colorado
We headed up to the mountains to get away from the Vegas heat. Before the sun rose, I took your top-voted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=8Xy8oRRVntg
[Video] Office Hours: Azure SQL DB & SQL Server Questions
Post your SQL Server and Azure SQL DB questions at https://pollgab.com/room/brento and upvote the ones you'd like to hear me discuss.
https://youtu.be/hZSavloVmuw
[Video] Office Hours in Glacier Bay, Alaska
Thankfully, we didn't hit any icebergs or glacier droppings, so I put my comfiest coat on to answer your top-voted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=ZIUbZvtPsrc
Production DBA
How to Configure Ola Hallengren’s Database Maintenance Scripts for Backups
Someone told you that you should be using Ola Hallengren's Maintenance Scripts. You've downloaded his Maintenance Solution.sql, you ran it in the master database, and ... now you're not sure what's supposed to happen next. In this post, we'll cover how to configure backups.
First, configure the Agent jobs.
When MaintenanceSolution.sql ran, it created a few Agent jobs. You can see them in SSMS or Azure Data Studio under SQL Server Agent, Jobs:
[Video] Office Hours: Testing the First Responder Kit
I tested the April release of the FRK, then answered your questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=AateYX3bUmw
[Video] Office Hours: 25 Pretty Good Questions
You post questions at https://pollgab.com/room/brento and upvote the ones you'd like to see, and my job is to come up with accurate answers on the fly. Let's see how I did.
https://youtu.be/UtX2rLjewbw
Production DBA
Office Hours Speed Round, Easy Text Answers Edition
Some of the questions y'all post at https://pollgab.com/room/brento have easy one-line answers. Let's knock 'em out:
George: Hi Brent, what recently has been the most challenging/surprising/new-to-you performance issue you have encountered?
[Video] Office Hours: Ask Me Anything at Sea
It was a dark and stormy morning, on the last day of my Panama Canal cruise. Before I perished, I sat down to answer your top-voted questions from https://pollgab.com/room/brento.
https://youtu.be/lAMRoB1LyWE
Slow Startup, Failover, and Restore Times with In-Memory OLTP
When In-Memory OLTP came out, I worked with it briefly, and I remember coming away thinking, "Who in their right mind would actually use this?" I was so horrified that I wrote a presentation about it and gave it at a couple of conferences:
https://www.youtube.com/watch?v=Nlrc56Q4ABQ
[Video] Office Hours at Sea: Heading to Jamaica
I'm on a boat! I'm on a 10-day Panama Canal cruise, and I stopped (well, not the boat) off the coast of Florida to answer questions y'all posted at https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=XLxaHT5tdUU
[Video] Office Hours Brought to You by Quest Software
Today's episode of Office Hours is brought to you by Quest Software. I went through your top-voted questions from PollGab.com/room/brento, and, uh, kinda looked like I was sponsored by Fendi while doing it, hahaha:
https://youtu.be/2NssGp4tays
[Video] Office Hours: Ask Me Anything About SQL Server
Y'all just never run out of interesting questions at https://pollgab.com/room/brento! I'm impressed, got another great round today.
https://youtu.be/LouW_Vxr7Yg
How to Install SQL Server and the Stack Overflow Database on a Mac
To follow along, you'll need:
An Apple Mac with an Apple Silicon processor (M1, M2, etc - not an Intel or AMD CPU)
Azure Data Studio
Docker Desktop 4.25 or newer
An Internet connection
[Video] Office Hours: Holiday Speed Round
Beep beep! Here's a speed round of Office Hours where I rip through a dozen questions in under ten minutes. Want to see your own questions answered? Post 'em and upvote the ones you like at https://pollgab.com/room/brento.
https://youtu.be/qt2mmS0RY5I
[Video] Office Hours: Great Questions, Part 1
Wow, y'all have been posting some great questions at https://pollgab.com/room/brento lately!
https://youtu.be/eIjMqm0b02s
