[Video] Office Hours: 22 Good Questions and a Stinker
Brent Ozar Blog
by Brent Ozar
4d ago
Lots of good questions on today’s broadcast! If you’d like to submit one, go to https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. Here’s what we covered today: 00:00 Start 01:05 Testing123: When inserting or updating data into a table, from a concurrency perspective, does it make sense to break up the complicated SELECT logic into a staging table and then bulk load/update the data into the destination. i.e. Will SQL only grab exclusive locks at the end of the tran? 03:00 Curious DBA: Hi Brent. What query tuning approach would you take to force SQL Server to do m ..read more
Visit website
[Video] Office Hours: Quickie Before Dinner
Brent Ozar Blog
by Brent Ozar
5d ago
Before heading out to dinner, I went through your highly-upvoted questions from https://pollgab.com/room/brento. Here’s what we covered in this episode: 00:00 Start 00:20 Mert: Hi Brent, what is the relation between AlwaysOn and Windows Failover Cluster? Is WFC an obligation or a choice for creating an Always On availability group? It will be nice if you address the topic with shapes visually. Thanks. 01:12 LemonOnAPear: Whats your favorite SQL Server bug / story about a bug? 02:26 franklwambo: Have you plans to ship the current or future SQL server training classes to pluralsight? my compan ..read more
Visit website
Office Hours, ChatGPT Edition: AI Answers 4 of Your Questions
Brent Ozar Blog
by Brent Ozar
6d ago
In a recent Office Hours post, David Reabow suggested letting ChatGPT answer a few of the questions y’all posted at http://pollgab.com/room/brento/. Brilliant! Let’s see how it does. I purposely cherry-picked the questions that I thought ChatGPT would have the easiest time answering. Rollback is single threaded asks: Hi Brent! An update statement has blocked all other sessions. What should I do? Killing it, restarting SQL server service, waiting, etc. What’s your opinion? Thanks! ChatGPT answered: If an update statement has blocked all other sessions, there are a few options to consider: Moni ..read more
Visit website
[Video] Office Hours: Ten Minutes of SQL Server Answers
Brent Ozar Blog
by Brent Ozar
1w ago
ChatGPT, Resource Governor, manually created stats, Always Encrypted, and as always, fragmentation: let’s answer your questions from https://pollgab.com/room/brento. Here’s what we covered today: 00:00 Start 01:13 Timbalero: Hi Brent. my friend knows your view on rebuilding indexes. He also thinks that external index fragmentation affects pretty much only readahead scans. For scientific purposes, what metrics should he look at to see if defrag makes a difference (if only marginal)? 02:21 chandwich: Hey Brent! What kind of advantages (or disadvantages) do you anticipate with the recent emerge ..read more
Visit website
Bite-Sized Office Hours: Q&A on TikTok
Brent Ozar Blog
by Brent Ozar
1w ago
Wanna learn about SQL Server and the Microsoft data platform, but you don’t wanna sit through long videos? Enjoy short videos on TikTok? I’ve got just the thing: I’m taking the best Q&A from Office Hours and putting ’em out as individual videos. That way, as you’re swiping through practical jokes, friendship goals, candid idiocy, music reimaginations, and dog tips, you can also learn a little in bite-sized chunks, too. @brentozarultd Do you have any resources/tips on a new dba needing to inventory the servers/instances/databases at a company? I have around 30 servers that I want to st ..read more
Visit website
[Video] Office Hours: Ask Me Anything About SQL Server
Brent Ozar Blog
by Brent Ozar
1w ago
Y’all just never run out of interesting questions at https://pollgab.com/room/brento! I’m impressed, got another great round today. Here’s what we covered: 00:00 Start 00:25 Chrisbell: Recently we’ve been facing thread starvation issues. How can we troubleshoot it when even sp_whoisactive ( even with DAC ) is unresponsive and takes forever to return a result set ? How can we get to the root cause of this since its all happening within a few seconds ? 01:24 Lu: We disable TLS 1.0 and 1.1 on our windows servers; how to affect the SQL server and SSIS jobs? 05:19 Macrieum: Hi Brent, I am at the ..read more
Visit website
[Video] Office Hours: Back Live on Twitch Again
Brent Ozar Blog
by Brent Ozar
2w ago
After I stopped selling live classes, I took some time off all live broadcasting period. It was a nice couple of months over the holidays, had a good time with the family, and now I’m starting to fire up my Twitch channel again. I’m not setting a schedule yet, just broadcasting when I have time available, so if you want to get alerted when I start streaming, subscribe to that channel and turn on notifications. Here are the questions we discussed: 00:00 Start 06:17 JimLic: In moving to new physical servers with virtual disks which are claimed to be ‘better’ than our old physical disks, replic ..read more
Visit website
How to Install SQL Server and the Stack Overflow Database on a Mac
Brent Ozar Blog
by Brent Ozar
3w ago
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.16.1 or newer An Internet connection In Docker Desktop, go into Settings, Features in Development, and check the box for “Use Rosetta.” That’s the new 4.16 feature that allows you to run Intel-focused apps like Microsoft SQL Server on Apple Silicon. 1. Download & Run the SQL Server Container We’ll follow the instructions from Microsoft’s documentation, but I’m going to abbreviate ’em here to keep ’em simple. Open Terminal and get ..read more
Visit website
[Video] Office Hours: Bad Hair Edition
Brent Ozar Blog
by Brent Ozar
3w ago
I am waaaay overdue for a haircut, but instead of being a responsible adult, I stopped to take your questions from https://pollgab.com/room/brento. 00:00 Start 00:43 Mike: We have 3 Dell PowerEdge R630 servers with SQL Server installed. Everything functions for 3.5 years straight. How long is it expected to work? 01:30 Shalom: What are the worst incidents that you have witnessed due to SQL errors being routed to a mail folder that nobody ever reviewed? 02:40 TheBigMC: Hi Brent. I’m about to start a new job where I’ll be looking after 100 SQL Servers. I’ve been told that’s a guess. How can I ..read more
Visit website
Office Hours: Bad Questions Edition
Brent Ozar Blog
by Brent Ozar
3w ago
Normally, y’all post and upvote great questions at https://pollgab.com/room/brento, but in today’s episode, y’all upvoted some stinkers. Buckle up. 00:00 Start 00:47 SQLKB: Hi, according to sp_BlitzCache I usually have more than 260k plans in cache, created in the past 1 hour, is it a big number? Comparing number of plans from exec_query_stats vs exec_cached_plans the numbers are 260k vs 130k , what could cause the diff between those numbers? 02:23 Chase C: What do the options under linked server provider settings mean? “Allow inprocess” is frustratingly un-googleable and my technical manual ..read more
Visit website

Follow Brent Ozar Blog on Feedspot

Continue with Google
OR