Posts by Brent Ozar

[Video] Office Hours at the Munch Museum in Oslo

Videos
2 Comments
While in Norway for Data Saturday Oslo, I set up my camera gear by the Munch Museum to answer your top-voted questions from PollGab.com/room/brento. I later found out it’s pronounced ‘monk’, not ‘munch’, so there’s that. I also fell in love with his giant mural The Sun, probably one of my top 5 favorite paintings…
Read More

[Video] Office Hours at Svínafellsjökull Glacier in Iceland

Videos
0
Got Azure SQL DB and SQL Server questions? Post them at https://pollgab.com/room/brento and I’ll answer the top-voted ones. This episode comes to you from the most hike-friendly glacier in Iceland, one where you can park your car and step onto the glacier 15-20 minutes later after an easy walk. (I’m not standing on the glacier…
Read More

12 Office Hours Questions I Don’t Have Answers For

SQL Server
28 Comments
Hey, you! You look smart. Here are highly-upvoted questions that fellow readers submitted at https://pollgab.com/room/brento that I don’t have answers for. If you’d like to jump into the comments, you can reference questions by number with your answers. Time to show off your brains! Kansas4444 asks: Hi Brent, do you have any advice on calculating…
Read More

Announcing SQLBits 2024: 19-23 March, Near London

SQLBits
3 Comments
I hate picking favorites, but I gotta be honest: SQLBits is my favorite conference. Sure, like any conference, it has workshops, training days, and even a free community day, but the icing on the crumpet is the attendee party. Every year, Bits goes all out to pick a theme and throw a monster Friday night…
Read More

[Video] Office Hours at Breiðamerkursandur, Diamond Beach

Videos
1 Comment
Post your Azure SQL DB and SQL Server questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss. In this episode, I’m overlooking Breiðamerkursandur, Diamond Beach, one of the most Instagrammed places in Iceland. Here’s a shot from a prior trip when I climbed up on one of the icebergs: This time…
Read More

What’s Faster: IN or OR? Columnstore Edition

Pinal Dave recently ignited a storm of controversy when he quizzed readers about which one of these would be faster on AdventureWorks2019: SELECT * FROM Sales.SalesOrderHeader WHERE CustomerID IN (1, 2, 3); SELECT * FROM Sales.SalesOrderHeader WHERE CustomerID = 1 OR CustomerID = 2 OR CustomerID = 3; 123456789 SELECT *FROM Sales.SalesOrderHeaderWHERE CustomerID IN (1,…
Read More

[Video] Office Hours at Jökulsárlón Glacial Lagoon

Videos
2 Comments
Post your Azure SQL DB and SQL Server questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss. In this episode, I’m at Jökulsárlón Glacial Lagoon, a wonder of nature, watching the icebergs pile up, stuck in the lagoon due to the incoming high tides. Here’s what we covered: 00:00 Start 01:15…
Read More

[Video] Office Hours at the Blue Lagoon

Videos
3 Comments
Road trip time! I’m recovering from jet lag after flying over to Iceland, so I went through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:55 Shehroz Sabzwari: What are your pros / cons for running on-prem SQL Server in a VM versus bare metal? 02:04 adba: what are your recommendations for…
Read More

[Video] Office Hours: Overly Caffeinated Edition

Videos
2 Comments
After consuming waaaay too much coffee, I went through your top-voted questions from https://pollgab.com/room/brento: Here’s what we covered: 00:00 Start 03:53 It’s ‘a me: Is there a feature in SQL that Microsoft abandoned that you wish they had perfected? 05:43 TheEveryDayDBA: My friend asks, he is using sp_blitzIndex on a OLAP db workload. Quite a…
Read More

[Video] Office Hours: All About Miles Edition

Videos
6 Comments
Today’s webcast featured an awful lot of questions from one particular person who was super-active at https://pollgab.com/room/brento: Here’s what we covered: 00:00 Start 00:03 Miles: Hi Brent, I am aware of “sp_statement” completed and sp_batch_completed events in trace and extended events. But, what is the use of rpc_completed event? How this event will be helpful…
Read More
Office Hours - ask me anything.

[Video] Office Hours: I Need Your Help with These

Videos
2 Comments
Today, I need your help with some of the top-voted questions from https://pollgab.com/room/brento. Chime in in the comments: 00:00 Start 00:52 Accidental DBA: Hello Brent. Thank you for keeping your Q& A sessions entertains and informative. My question is non-technical…Have you ever said this to your client? You keep using that word. I don’t think…
Read More