Posts by Brent Ozar

[Video] Office Hours in Telluride, Colorado

Videos
0
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.   Here’s what we covered: 00:00 Start 00:36 Ozan: Hi Brent, how should Volume Snapshot Backups (VSS) be configured correctly that it will not freeze the database’s IO for a couple…
Read More

Office Hours: Before Heading Out on Vacation

Videos
1 Comment
I took a break from packing my bags long enough to answer your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 02:42 T-man: Hi BO. A friend has multiple Distributed AGs (on separate business division servers) but needs to share ODS data with each of the DAG DBs. Any near-real time architecture ideas…
Read More

[Video] Office Hours: Stump Me On SQL Server

Videos
0
I went through the top-voted questions from https://pollgab.com/room/brento and discussed ’em live on my Twitch channel.   Here’s what we covered: 00:00 Start 00:39 tanchenglai: Hi Brent! We bought your Level 2 Bundle last year. Recently, we went into frequent thread pool issues; we suspect it is due to high CPU utilization. Our IT manager…
Read More

[Video] Office Hours: Extended Answers Edition

Videos
0
Y’all posted so many good questions at https://pollgab.com/room/brento that I went longer than usual this time: Here’s what we covered in this episode: 00:00 Start 02:17 Tanchenglai: Hi Brent, recently we always ran into thread pool issue. I checked Performance Dashboard and found that CPU spiked over 80% occasionally. I suspect apps can’t connect after…
Read More

[Video] Office Hours While the Pool Refills

Videos
6 Comments
I step away from the backyard long enough to take y’all’s questions from https://pollgab.com/room/brento. Here’s what we covered in this episode: 00:00 Start 02:23 Stockburn: Hi Brent, we are using distributed always on AGs, with a node in AWS for DR. We are thinking of using this to quickly migrate the work load to the…
Read More

[Video] Office Hours: Stump Me With Your Data Questions

Videos
4 Comments
There are only a couple weeks left in this summer’s marathon of Office Hours sessions, which means there’s limited time left to ask your toughest database problems (not trivia questions) at https://pollgab.com/room/brento. Here’s what we covered in this episode: 00:00 Start 03:22 tanchenglai: Hi Brent, I have implemented a system that records data in another…
Read More

[Video] Office Hours: Overheating Cadillac Edition

Videos
2 Comments
I took your questions from https://pollgab.com/room/brento before heading out to pick up my Cadillac from the mechanic. Here’s what we covered: 00:00 Start 04:50 JudgeDredd: Hi Brent, have you ever been asked for opinion/expertise (as a database specialist) in a court trial? If yes, could you share some details? 07:10 Aart Bluestoke: A maximum of…
Read More

Finishing Up Your Free Azure Networking Training

Microsoft Azure
0
To celebrate this month’s launch of our new class, Fundamentals of Azure Networking for the Data Professional, we’re making one video a day completely free. Here’s what’s on tap this week: July 24: Demo: Working With a VPN July 25: Hub and Spoke vs Mesh Design Patterns July 26: Microsoft-Managed Virtual Networks July 27: Demo:…
Read More

[Video] Office Hours: SO MANY Good Questions

Videos
0
Seriously, how do y’all keep coming up with so many great questions? I went through your top-voted questions from https://pollgab.com/room/brento/ on a live stream on my Twitch channel, like I do on most Wednesdays & Thursdays, and really enjoyed these: Here’s what we covered: 00:00 Start 04:14 Groove_timer: Hey Brent, Trying to convince my employer…
Read More

[Video] Office Hours: While Stack Overflow is Down

Videos
5 Comments
Stack Overflow was down, so y’all posted questions at https://pollgab.com/room/brento and I gave ’em my best shot. Here’s what we covered: 00:00 Start 04:33 Amir: Does Az-900 worth the effort and money? What about other microsoft certifications? 06:16 Mr. M: Hi Brent. Which feature in SQL Server you like the most? 08:43 Q-Ent: Hi Brent,I…
Read More

Free Azure Networking Training This Week

Microsoft Azure
2 Comments
To celebrate this month’s launch of our new class, Fundamentals of Azure Networking for the Data Professional, we’re making one video a day completely free. Here’s what’s on tap this week: July 17: Demo: Using Virtual Networks for Data Services July 18: Demo: Private Networks Without Public Access July 19: Demo: Multiple Private Networks July…
Read More

[Video] Office Hours: 30 Minutes of Rapid-Fire (And a Little Burnination)

Videos
1 Comment
Almost all of today’s questions from https://pollgab.com/room/brento were great! Well, except two. Here’s what we covered: 00:00 Start 02:13 Andrei: What’s the appropriate response/punishment for developers who insist on storing json and xml in nvarchar(max) fields? 03:43 JustGoogleIt: What are your thoughts on Jeff Moden’s “Black Arts” Index Maintenance — GUIDs v.s. Fragmentation? How would…
Read More

Free Azure Networking Training This Month!

Microsoft Azure
3 Comments
Raise your hand if you’ve ever blamed the network. You’re responsible for the health, security, and uptime of your company’s data services in Azure. You’ve provisioned a few services, but every now and then, you run into problems making your services reachable and reliable from different users and app servers. You want to understand: Your…
Read More

[Video] Office Hours: DBA & Developer Relationships

Videos
1 Comment
Y’all posted & upvoted questions at https://pollgab.com/room/brento, and we finished up the session talking about the relationships between developers and database administrators. Here’s what we covered: 00:00 Start 02:35 Nortzi: Hi Brent. Is there a way to optimize sorting a result using a column from a different table? Using POC index pattern (partition,order,covering) works great…
Read More