Category: Compute

When you deploy Microsoft SQL Server on AWS, you have many choices for how to optimize the performance, availability, reliability, and costs of your applications. Amazon offers multiple SQL Server versions, broad compute options, and numerous licensing options to optimize usage and reduce costs. You can choose the pay-as-you-go model and use the AWS license-included […]

A best practice for the deployment of AWS resources is to use a configuration system that treats your infrastructure as code. Infrastructure as code is a key enabler of DevOps practices, which bring developers and operations together to collaborate on automating application delivery at scale. By modeling your entire infrastructure as code in AWS CloudFormation […]

Migrating monolithic mission-critical Microsoft SQL Server databases from on-premises to AWS (that is, to SQL Server based on Amazon EC2) is often a challenging task. The challenge comes mostly from the following: A prolonged downtime window during cutovers that can have an adverse impact on the business Challenges involved in keeping the databases (both on-premises […]

This blog post explains how to use PowerShell and native Microsoft SQL Server backups to migrate an on-premises SQL Server database to an Amazon EC2 instance. In general, we recommend that where possible you should make every attempt to migrate your on-premises SQL Server databases to Amazon RDS. You can find more details on how […]

Perfectly sized instances for maximizing Microsoft SQL Server Standard In September, Amazon Web Services announced availability of the new Amazon EC2 x1e.32xlarge instance type with 128 vCPU and 3,904 GiB of memory. Since that announcement, we have heard from customers that they want more instance configuration choices with fewer vCPUs, while maintaining a high ratio […]

Re Alvarez-Parmar is a solutions architect at Amazon Web Services. He helps enterprises achieve success through technical guidance and thought leadership. In his spare time, he enjoys spending time with his two kids and exploring outdoors. At Amazon, we are constantly improving our services to help customers solve their operational problems. One of the features […]

When you’re working with AWS services, Amazon S3 is the first choice to store text data files. In the past, to access S3 data, first you’d download the files and then perform extract, transform, and load (ETL) to load the data into Oracle. This approach has two drawbacks. It takes time to download and perform […]

Linked servers allow Microsoft SQL Server to run SQL Server statements on other instances of database servers. In this blog post, we focus on connectivity to other instances of SQL Server in Amazon RDS, hosted in Amazon EC2, or available from your data centers via a VPN or direct connect. We examine two connectivity scenarios: […]

Andrey Zaychikov is solutions architect at Amazon Web Services In this blog post, I will share experiences from a cross-regional migration of large-scale NoSQL database clusters (from Europe to the U.S.). The migration was a joint project implemented by the Ops team of our reference customer, FunCorp, and AWS Solutions Architects. “Our flagship product, iFunny, […]