Cloud Computing

Running SQL Server in the Cloud: 2017 Edition

Cloud Computing
25 Comments
You have two basic options: Infrastructure as a Service (IaaS) is just VMs running in someone else’s data center – be it Amazon, Google, or Microsoft. Job duties for a DBA are the same as on-premises virtual machines: you manage HA, DR, patching, backups, and performance tuning. It’s just that you may have slightly different…
Read More

An Expensive Reason To Avoid AGs In Azure

Cash Rules Most people, when they get through paying for Azure, and SQL Server Enterprise Licensing, are left with a hole in their wallet that could only be filled with something that says “Bugatti”, and has a speedometer with an infinity sign at the end. Recently, while working with a client, I found out that…
Read More
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

Microsoft Azure
7 Comments
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

Announcing Google Managed PostgreSQL (and why SQL Server DBAs should care)

You’ll notice that we’ve been blogging and writing a lot about Google here this week. I gotta tell you – it’s totally bizarre sitting in a Google Cloud Next conference session in San Francisco, watching presenters using Macs, coding with Visual Studio Code, demonstrating SQL Server. I even talked to a SQL Server DBA attendee yesterday…
Read More

New White Paper: SQL Server Performance Tuning in Google Compute Engine

You’re a database administrator, Windows admin, or developer. You might even be a marmot. You’re building your first SQL Servers in Google Compute Engine, and you’re stuck at the create instance screen. How many CPUs should you use? How much memory? How are you supposed to configure storage? Will it be fast enough, and what…
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

Always On Availability Groups Now Supported in Google Compute Engine

I’m excited to finally be able to talk about something Erik, Tara, and I have been working on for the last few months. Here in the SQL Server community, when I mention cloud, you probably think of two companies: Microsoft and Amazon. We’ve been blogging about SQL in AWS for years, and Microsoft throws a…
Read More

7 Things I Learned About Aurora at AWS re:Invent 2016

Richie and I attended the AWS re:Invent conference in Vegas last week. Here’s some of my favorite takeaways about Amazon Aurora, their homegrown relational database with MySQL compatibility. 1. AWS has a grudge against Larry Ellison. Andy Jassy’s keynotes made repeated jokes about Oracle’s cloud product (or lack thereof), the high cost of proprietary databases,…
Read More