[Video] Office Hours at Sea: Leaving Juneau
I stopped piloting the ship long enough to answer your top-voted database questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=AtEZMVVVi_U
Cloud and Managed Database Platforms
Cloud architecture, managed databases, migrations, and cloud operating tradeoffs.
131 associated posts50 primary posts
AWS Aurora Cut Our Database Costs for SQL ConstantCare® – Again.
In May, Amazon brought out a new Aurora I/O Optimized Serverless instance type. By switching to it, we cut our database costs by 43% overnight, saving us about $1,200 per month.
No strings attached. Just lower prices.
[Video] Office Hours: Ask Me Anything About Azure SQL DB & MSSQL
Post your questions at https://pollgab.com/room/brento and upvote the ones you'd like to see me answer.
https://youtu.be/V5illj_KOJg
What SQL Server People Should Know About Amazon Aurora Serverless
You, dear reader, are most likely a Microsoft SQL Server user - either a DBA or developer.
Set your pencil down for a second because you're not going to learn about a Microsoft product today, nor are you going to learn something that is going to be immediately useful to you in your job. Today, I'm writing about a completely different product just to give you a better insight on what else is out there.
Production DBA
Office Hours: Questions That Didn’t Make the Cut
Sometimes, y'all post questions at https://pollgab.com/room/brento and they don't get a lot of upvotes, and reading through 'em, I bet it's because other people don't quite understand what you're asking. I think there might actually be a good question at the heart of it, but ... I'm just not sure what it is, and it needs to be rephrased.
[Video] Office Hours: Snowy Michigan Edition
We went up to Michigan to see my dad's side of the family, and the snow came down just in time for our arrival. Always love the fresh snow look.
So I stood outside and took your top-voted questions from https://pollgab.com/room/brento. Let's see what y'all came up with today:
[Video] Office Hours: Great Questions, Part 1
Wow, y'all have been posting some great questions at https://pollgab.com/room/brento lately!
https://youtu.be/eIjMqm0b02s
Production DBA
Office Hours: Gif Reactions Edition
Some of the questions y'all post at https://pollgab.com/room/brento are open-and-shut cases. I was going to do a one-word-answers edition, but I think this is even better: gifs.
GI Joe DBA: Thoughts about IT professionals Unionizing? IT professionals are in demand. Because of our demand, should we use this leverage to unionize, raise the bar, force better health benefits, retirement benefits, etc for ALL.. US Citizens? Ever discuss this with colleagues?
[Video] Office Hours: Hotel Balcony Edition, Part 2
Post your questions at https://pollgab.com/room/brento and upvote the ones you'd like to see me cover. In today's episode, I sit down on a quiet hotel balcony and talk through a bunch of interesting questions:
https://www.youtube.com/watch?v=VJAwgkhq_Z0
[Video] Office Hours in Moab, Utah
On a cross-country trip, I stopped in Moab, Utah and answered your top-voted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=TbrGmJGOL_o
Production DBA
Meme Week: Queue in the Database
When you have a hammer, everything looks like a nail. Unfortunately, a lot of people don't even know how to use a hammer correctly.
You really shouldn't be doing queues in the database because:
[Video] Office Hours: Q&A on the Beach at Sunset
You posted and voted on questions at https://pollgab.com/room/brento and I answer 'em on the beach. It's not your eyes: the camera's hunting for focus a lot in this video.
https://www.youtube.com/watch?v=nSfJmaY5sL8
T-SQL & Development
[Video] PASS Data Community Summit Keynote: 5 Ways the Cloud Impacts Your Career
Succeeding as a data professional is all about placing the right bets at the right times. The more you know about what’s happening around you, the better bets you can place. I’ve been working with databases for over two decades. In this session, I’ll invite you into my home to have a frank, honest discussion…
[Video] Office Hours Speed Round: Quick Answers
Think fast! Not all of the questions at https://pollgab.com/room/brento have long-winded answers. In this 5-minute session, I crank through a bunch of straightforward questions:
https://www.youtube.com/watch?v=cxq1P3mpxaY
[Video] Office Hours in Malibu: Ask Me Anything About SQL Server
I'm up bright and early in Malibu, so let's talk through your highly upvoted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=VwKeu4WAPuI
[Video] Office Hours: Ask Me Anything at the Old Harbor in Reykjavik
On a very chilly morning, I went through your highly-upvoted questions from here and talked through 'em:
https://www.youtube.com/watch?v=lpklTAJdrBE
[Video]: Office Hours at Diamond Beach
I took a break from playing with glacier leftovers at Diamond Beach to answer the questions you upvoted at https://pollgab.com/room/brento/.
https://www.youtube.com/watch?v=K4l522V4h08
[Video] Office Hours: Ask Me Anything About SQL Server in Stokkseyri
Before Fjöruborðið opens for lunch, I answer a few of your questions from https://pollgab.com/room/brento including:
00:00 Introductions
00:29 Peter: What is your opinion about the SQL generated by Entity Framework?
02:00 Peter: When would you switch from EF to stored procedures?
02:45 Always Learning DBA: What are free resources to help me transition into an architect or data scientist role?
04:43 How is the auditing and monitoring different for Azure SQL DB?
06:33 Recap
Production DBA
Database Performance Tuning is Getting Much Harder.
For the last twenty years, SQL Server performance tuning has relied on a few facts: SQL Server provided a lot of performance metrics with thorough documentation from both Microsoft and the community. You could fetch those metrics in a variety of ways, like Perfmon counters and dynamic management views. Many of the metrics were cumulative…
Production DBA
Azure SQL DB Frequently Asked Questions
Let's get you some answers.
Is Azure SQL DB PaaS, IaaS, or SaaS?
Azure SQL DB is platform-as-a-service (PaaS). Microsoft manages most common database tasks for you, and they act as your DBA.
This also means that like a DBA, Microsoft will tell you "no" if you try to implement something that they don't support. There's no negotiations: the answer is just no.
Who is Azure SQL DB for?
Azure SQL DB is a good fit for new applications.
