Cloud architecture, managed databases, migrations, and cloud operating tradeoffs.
131 associated posts50 primary posts
Today's Office Hours had a ton of technical difficulties because it was my first live stream on both Twitch and TikTok. The first few minutes were cut off, and you can't see the questions onscreen. Nonetheless, there are good answers in here, so let's do it:
https://www.youtube.com/watch?v=Nv0Wnli6kaE
While taking a dip in Cabo, I went through your top-voted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=OaHImrIMM6Y
On a pleasantly mild morning, I sat down on the patio and took your top-voted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=4chYaiYUaSk
When I went through the top-voted questions at https://pollgab.com/room/brento, I didn't have all the answers today:
https://www.youtube.com/watch?v=g6fqxTPnDd0
While in Nashville for a creators conference, I went through your top-voted questions from https://pollgab.com/room/brento.
https://youtu.be/lDdQqlsyGN8
For this month's TSQLTuesday, I asked y'all to describe the most recent issues you closed.
If you ask someone in IT, "What do you do for a living?" they struggle with job titles. They say things like:
Brent says: It's really funny how the world works. I wrote what you see below in December 2023 and scheduled it for publication on January 16th (today), hoping to get help from the community to get this process started. On January 9, before the post went live, David Wiseman submitted a pull request with the first steps! More on that at the end of the post. I'm leaving the post as-written in Dec 2023 because it's still useful.
I woke up on the wrong side of the bed after a nap. How does that even happen?!? To take the edge off, I poured myself a gin & tonic and went through your top-voted questions from https://pollgab.com/room/brento.
https://youtu.be/5lF0RtdBPP8
Lemme start this off by saying this is probably irrelevant to you. (It's irrelevant to me, too.)
If you're strapped for time, just skip past this blog post.
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
On an overcast morning in scenic Camden, Maine, I stood on the docks and took your top-voted questions from https://pollgab.com/room/brento.
https://youtu.be/OFRjC6D7vTs
At least once a month, a client has The Postgres Conversation™ with me.
It happens at the end of a consulting engagement, after we've talked about the work that the team needs to do in order to meet their performance objectives.
After a long trip through Scandinavia, I'm back in the desert. You posted questions at https://pollgab.com/room/brento and I took the hot seat:
https://youtu.be/guzQGYx3R2M
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
If you've been in Azure or Amazon for a few years, you're probably on old, slow hardware.
In the last 3 weeks, I've had two clients who'd both been early cloud adopters. When they'd migrated to the cloud, they both used Azure Ev3 VMs - at the time, a good choice for SQL Server due to its relatively high amount of memory. When the Ev3 VM types were announced in 2017, they were hosted on Intel Broadwell and Haswell processors with 2.3-2.4GHz processing speed.
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.)
On August 30, Azure's Australia East data center had a big problem, affecting customers like Bank of Queensland and Jetstar. Here's the timeline: 30 August 2023 @ 08:41 – Voltage sag occurred on utility power line 30 August 2023 @ 08:43 – Five chillers failed to restart 30 August 2023 @ 10:30 – Storage and SQL…
Today's webcast featured an awful lot of questions from one particular person who was super-active at https://pollgab.com/room/brento:
https://www.youtube.com/watch?v=dKngk_OIwB4
I went through the top-voted questions from https://pollgab.com/room/brento and discussed 'em live on my Twitch channel.
https://youtu.be/tyu0JN7H_hQ
Post your SQL Server and Azure SQL DB questions at https://pollgab.com/room/brento and upvote the ones you'd like to hear me discuss.
https://youtu.be/hZSavloVmuw
