Compute, memory, storage, virtualization, and deployment foundations.
309 associated posts101 primary posts
After the PASS Data Community Summit in Frankfurt, Germany, I headed back to Iceland and spent a few more days gallivanting around the country in a Tesla Model Y camper. (Well, "camper" is a glamorous word for it: CampEasy.com puts a mattress in the back. But still.) Today, I'm at Djúpalónssandur, a marvelous black pebble…
For T-SQL Tuesday #199, Koen Verbeeck posed an excellent question: if your company moved up to the cloud, but after migrating, had to come back on-premises, what would be the big problems?
I've had clients in this exact situation! Here are some of my favorite gotchas from those experiences.
You were minding your own business, and all of a sudden it happened.
You glanced at file sizes one day, and your eyes got big. The numbers got a little large while you weren't looking. This is a great time to stop and think about a few changes to the way you're managing this database.
At least once a month, I get this question from a client:
We have big data, and we want to save money. We want to move the older data down to some kind of archives that will cost us less.
When you've got questions about architecture, development, or best practices, post 'em at https://pollgab.com/room/brento, and upvote the ones you'd like to see me cover. It's like free bite-sized consulting.
https://www.youtube.com/watch?v=lCbPSYmCTHg
I'm up in North Bay, Ontario, Canada for the 2026 Can-Am Curling Cup run by Aaron Bertrand - and my team actually won!
Let's bask in the warmth (cough) of our glory as we go through your top-voted questions from https://pollgab.com/room/brento.
Sometimes I really hate my job. Forever now, FOREVER, it's been a standard thing where I can say, "When you're measuring storage performance during index and query tuning, you should always use logical reads, not physical reads, because logical reads are repeatable, and physical reads aren't. Physical reads can change based on what's in cache,…
Yes, I'm back on a cruise ship with another 360 degree video. Lest you think I'm being wildly irresponsible (or responsible perhaps?) with your consulting and training money, be aware that this particular cruise was free thanks to the fine folks in the casino department at Norwegian Cruise Lines. In between beaches and blackjack, let's go through your top-voted questions from https://pollgab.com/room/brento.
Want to ask your own questions or pick the ones I discuss? Head over to https://pollgab.com/room/brento to get involved. In the meantime, let's hang out in the backyard, where Beni makes a special guest appearance.
https://youtu.be/aMMBj4owm3A
When I travel, I try to take y'all with me to really pretty or at least interesting locations. On my Tokyo visit last year, I did Office Hours in Akihabara, the electronics & anime shopping hub. Even though I'm not into anime at all and I don't collect that kind of gear, I wanted to see it because it's famous among geeks.
I really wanted to film Office Hours on the Great Wall of China, but the instant I got out there, I realized it was a lost cause. That place was SO overwhelming - tons of people, frigid winds, heights, totally overwhelming in every way. So, instead you get a nice peaceful park in downtown Zhengzhou,…
I drove the Graffiti Gulf out to The Last Spike (video) outside of Las Vegas and took your top-voted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=XcNJVJ1-XaE
It's the perfect time of year in Las Vegas when we can chill outside by the fire, enjoy a glass of wine, and go through your top-voted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=esMYx_mbfqo
My cruise ship took a detour to Honduras to avoid the hurricane. Let's hang out on the beach and go through your top-voted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=aD7FnCRzJL8
Let's hang out, listen to the peaceful waterfall, and go through your top-voted questions from https://pollgab.com/room/brento. This is kinda the calm before the storm: in another week, I'll be on the road again for a while, hopefully bringing you some fresh Office Hours locations from the Caribbean and Alaska!
https://www.youtube.com/watch?v=hdBa7FKQMWI
Most of the time, we use wait stats to identify SQL Server's bottleneck and focus on what to tune.
However, let's say you've got a really well-tuned SQL Server where:
I strapped on my Apple Vision Pro, updated its OS, and recaptured my persona with the latest updates, and... it's still pretty weird. Let's go through your top-voted questions from https://pollgab.com/room/brento and have a laugh at my hot dog fingers.
https://www.youtube.com/watch?v=tLAEqItBnuI
On a sunny Saturday afternoon, I made myself a highball and went through your top-voted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=_NLtbul3Nyc
I'm back home after a 2-week Iceland vacation. Let's catch up with your top-voted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=PV6MuFQkf5k
I'm in Iceland this week, land of fire and ice, a place I keep coming back to over the years. It's one of my favorite places on earth with stunning scenery, nice folks, and great restaurants. I paused at Godafoss to take your top-voted questions from Pollgab.com/room/brento.
https://www.youtube.com/watch?v=nGoE17cSdl8
