[Video] Office Hours: 21 Good Questions
This one is a 3-part episode: I take 21 questions from https://pollgab.com/room/brento and then later, work on First Responder Kit pull requests.
https://youtu.be/MNwCDQX8zl4
Query Optimization and Execution Plans
How SQL Server compiles, optimizes, and executes individual queries.
573 associated posts292 primary posts
[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: Really Good Questions Edition
Y'all were on fire in this one! You posted great questions at https://pollgab.com/room/brento and I worked through 'em:
https://youtu.be/JDTS5KnqewA
[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 at Megunticook Falls in Camden, Maine
While in historic and beautiful Camden to hang out with friends, I went to Megunticook Falls and answered your top-voted questions from https://pollgab.com/room/brento.
https://youtu.be/QA8jlLfsC0U
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] Office Hours: Yes, I’m In the Same Shirt
Why yes, I'm wearing the same shirt as the video from "yesterday". Why do you ask? Stop paying attention to that, and check out the top-voted questions from https://pollgab.com/room/brento.
https://youtu.be/_vpHLQYpARM
[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 at the Northernmost Town in the World
Despite its location, Hammerfest, Norway attracts countless tourists eager to see the festival celebrating one of the world's favorite rappers. Did I get that right? I'm not sure I got that right. There's also fierce competition for the title of northernmost town: nearby Honningsvåg Norway also wants that claim, but with a population of only…
Production DBA
Something’s Up with Parallelism in Azure SQL DB Serverless
Or perhaps another way to phrase that is, Microsoft is up to something with parallelism. I don't know how long it's been this way - could even be since the launch of Azure SQL DB Serverless - but I just now noticed it while helping a client with a slow query. When you view an…
[Video] Office Hours at Dyrhólaey Overlooking Puffins & Black Sand Beach
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 Dyrhólaey, where I was completely surprised to find puffins at this time of year.
https://www.youtube.com/watch?v=vIVKXZfAzwE
[Video] Office Hours at Svínafellsjökull Glacier in Iceland
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 in this - I'm in front of it.)
[Video] Office Hours at Breiðamerkursandur, Diamond Beach
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:
Performance Tuning
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:
[crayon-6a736f1c3a50c416359571/]
I laughed so hard when I saw the storm of responses on Twitter. People sure do get passionate about this kind of thing. If you ever wanna witness patience and generosity in action, look at Pinal's responses to this tweet.
[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 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
Office Hours: Before Heading Out on Vacation
I took a break from packing my bags long enough to answer your top-voted questions from https://pollgab.com/room/brento.
https://youtu.be/PtUUzsEcPQs
[Video] Office Hours: Extended Answers Edition
Y'all posted so many good questions at https://pollgab.com/room/brento that I went longer than usual this time:
https://www.youtube.com/watch?v=f3sFkvgPPFQ
[Video] Office Hours While the Pool Refills
I step away from the backyard long enough to take y'all's questions from https://pollgab.com/room/brento.
https://youtu.be/xPn6wdlVgt0
