aws

Long Term Backup Storage With Amazon Glacier

November 20, 2012

A while back, Jes asked who’s taking your backups. Making sure you have good backups is important. How much thought are you giving to handling historical backups? Right now, there’s a really good chance that you’re using a solution based on tape. While tape backups work, there’s a better way. How Are You Archiving Backups Right…

The Trouble with Keys

September 25, 2012

Jeremiah Peschka

Architecture

architecture, aws, azure, cloud, sql server

Scaling up is hard: big hardware gets expensive fast. Scaling out is equally difficult; interesting design problems creep in to scale out solutions. One of the more troublesome issues architects face when scaling out is the issue of distributing identity. It’s often advantageous for object identity to be unique and portable across all database instances…

Amazon Web Services Architect Training Recap

September 17, 2012

Brent Ozar

Amazon Web Services (AWS), Cloud Computing, SQL Server

amazon, amazon web services, aws, cloud

Going into Amazon Web Services (AWS) architecture training last week, I expected to get whiteboard-level training for project planners, and it met expectations. We spent time talking about how Amazon’s most popular services fit together and how they can be used to solve our business needs. Nothing in the training itself was groundbreaking for me – I keep…

Why I’m at Amazon Architect Training This Week

September 11, 2012

Brent Ozar

Amazon Web Services (AWS), Architecture, Cloud Computing

amazon web services, aws, training

People bring me in when they’re having data problems. They can’t store data fast enough, they can’t make it reliable enough, they can’t hire people to manage it, etc. When I’m in the conference room, it’s because there’s a fire in the disco datacenter. You know how it is as a DBA, though – DBA…

AlwaysOn Availability Groups in AWS Revisited

July 10, 2012

Jeremiah Peschka

Always On Availability Groups, Amazon Web Services (AWS)

always on, availability groups, aws

If you’ve ever wanted to use the cloud for a DR site, there’s good news: as of this week you can use AlwaysOn Availability Groups and set up an asynchronous replica of your data into Amazon Web Services (AWS). If you’re already in the cloud, or if you were holding off, this means that you…

SQL Server Always On Availability Groups in AWS

April 24, 2012

Jeremiah Peschka

Always On Availability Groups, Cloud Computing

always on, availability groups, 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,…