Cloud Computing

Today’s a Good Day to Talk to Your Manager About Disaster Recovery.

Last night, two major IT disasters struck: Microsoft Azure’s Central region went down for about 4 hours. The official post-mortem isn’t out yet, but rumor has it that while decommissioning legacy storage services, the product group deleted the wrong thing. Crowdstrike pushed a bad update, leading to blue screens of death on Windows systems worldwide,…
Read More
Brent Reading Book

Interesting Aurora MySQL Feature: The Buffer Pool Survives Restarts

“Documentation! Hey, look at that.” 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. This one’s for the curious folks. AWS Aurora MySQL is Amazon’s flavor of MySQL with their own unique performance and reliability improvements.…
Read More

Finishing Up Your Free Azure Networking Training

Microsoft Azure
0
To celebrate this month’s launch of our new class, Fundamentals of Azure Networking for the Data Professional, we’re making one video a day completely free. Here’s what’s on tap this week: July 24: Demo: Working With a VPN July 25: Hub and Spoke vs Mesh Design Patterns July 26: Microsoft-Managed Virtual Networks July 27: Demo:…
Read More

Free Azure Networking Training This Week

Microsoft Azure
2 Comments
To celebrate this month’s launch of our new class, Fundamentals of Azure Networking for the Data Professional, we’re making one video a day completely free. Here’s what’s on tap this week: July 17: Demo: Using Virtual Networks for Data Services July 18: Demo: Private Networks Without Public Access July 19: Demo: Multiple Private Networks July…
Read More

Free Azure Networking Training This Month!

Microsoft Azure
3 Comments
Raise your hand if you’ve ever blamed the network. You’re responsible for the health, security, and uptime of your company’s data services in Azure. You’ve provisioned a few services, but every now and then, you run into problems making your services reachable and reliable from different users and app servers. You want to understand: Your…
Read More

Adding Managed Instances to SQL Server Distributed Availability Groups

SQL Server Always On Availability Groups help you build a more highly available database server by spanning your database across two or more SQL Server instances. When the primary goes down, the secondary can take over. You can also scale out reads to the secondary servers. Distributed Availability Groups take this a step further and…
Read More

Azure SQL DB Frequently Asked Questions

Azure SQL DB
20 Comments
I’ve seen your search history. 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…
Read More
And it looks bad even in shades.

I Sat Down for an Interview with Forrest Brazeal.

Cloud Computing
6 Comments
Here’s how the interview started: Forrest Brazeal: Brent, you’re a performance specialist who’s worked with massive SQL Server deployments; how does it make you feel when you hear cloud architects saying things like “relational databases don’t scale?” What do you wish they knew? “Time for a smoke break.” Brent Ozar: They’re right. Nothing scales worth a…
Read More

What Do You Do Better Than the Cloud?

Cloud Computing
31 Comments
It sounds like a trick question, but I’m serious. If your company’s management is just now starting to consider the cloud in 2020, your reaction shouldn’t be to cast a shadow on cloud vendors. Instead, think of it as writing your own resume: what the capabilities that you and your team are really proud of?…
Read More