Cloud Computing

Brent Ozar reading

Building a Faux PaaS, Part 3: What the Ideal Engineering Team Looks Like

Background: I’m working with kCura to build a Faux PaaS: something akin to Microsoft’s Azure SQL DB, but internally managed. You can catch up with what we’ve discussed so far in Part 1 and Part 2 of the series. In the last post, I talked about measuring backup and restore throughputs across different instance types, regions, storage configs, and backup locations.…
Read More

#DevIntersection Keynote Notes: Jeffrey Snover on Azure Stack

Preface: data professionals, if you’re in a hurry, skip this post. Nothing in here is directly relevant to your career in the next couple of years. I found it interesting because it explains where Microsoft’s developer story is going, though. At DevIntersection/SQLIntersection today, Microsoft’s Jeffrey Snover (@jsnover) talked about Azure Stack, something data professionals haven’t…
Read More

New White Paper: How to Build a SQL Server Disaster Recovery Plan with Google Compute Engine

You’re a systems administrator or database administrator who wants to protect your production SQL Server. However, you don’t have a separate data center or another colo site. Learn about what we call Log Shipping 2.0 You’re looking for instructions on: How to copy your SQL Server databases to Google Cloud Storage How to spin up…
Read More

New White Paper: How to Build an Always On Availability Group in Google Compute Engine

You’re a database administrator, Windows admin, or developer. You want to build a Microsoft SQL Server environment that’s highly available, and you’ve chosen to use Always On Availability Groups. Our newest white paper – download In this white paper we built with Google, we’ll show you: How to build your first Availability Group in Google…
Read More

SQL Server Timeouts During Backups and CHECKDB

So you’re hosting your SQL Server in the cloud – say Amazon EC2, Azure VM, or Google Compute Engine – and you’ve noticed that when you’re running a backup or a DBCC CHECKDB, you suffer from extreme performance problems. Queries run slow, and even worse, applications report timeout errors even just trying to connect to…
Read More