Cloud Computing

SQL Server RDS

Amazon Web Services (AWS) is a platform that offers a ton of services ranging from block storage, operating systems, to mail queues, DNS, and caching. When you say “cloud”, a lot of people think of AWS. AWS hosts a variety of businesses, large and small. Unfortunately, you still have to administer and configure your servers.…
Read More

SQL Server Always On Availability Groups in AWS

Many companies are investigating a move into cloud hosting. With the recent release of SQL Server 2012, these very same companies are also looking at a migration to SQL Server 2012 to take advantage of readable secondaries. Combining Amazon Web Services and SQL Server 2012 seems like a perfect match. Unfortunately, there are some gotchas,…
Read More

SQL Azure Frequently Asked Questions

On Monday 2/1, SQL Azure goes commercially live.  Microsoft’s charging for service now, and that means it’s officially official. I talk to a lot of enterprise DBAs, project managers, and developers about SQL Server in the cloud.  Here’s some of the questions I get asked most often. What is SQL Azure? SQL Azure is Microsoft’s…
Read More

Playing Around with SQL Azure and SSMS

The latest build of SQL Server Management Studio for SQL 2008 R2 includes built-in support for SQL Azure.  The November CTP is still only a feature-complete preview, not a release candidate, so don’t go installing it willy-nilly on your production desktop. To use this, you’ll need a SQL Azure account.  You can register for an…
Read More

Microsoft SQL Azure: The Flat Pack Database

Erika’s friends call her “Fancy Feast” because she only likes the best things in life. She’s got champagne tastes, but we can’t afford to buy the best of everything. I recently picked up a coffee table from Ikea, and it got me thinking about SQL Azure.

In a perfect world, I’d have on-premise SQL Server for every database. I’d use cutting-edge storage and cluster everything. But this isn’t a perfect world…

Read More

Sky Blue Screen of Death

I don’t have anything insightful to add, but Microsoft’s Azure cloud service suffered its first nearly day-long outage.  I have this vision of looking up to the clouds and seeing a giant BSOD, only with lighter colors. Might be the flu medicine, though.  I’ll be back in the game tomorrow or Wednesday.
Read More