AWS Database Blog
Tag: EC2
How to configure SQL Server 2017 on Amazon Linux 2 and Ubuntu AMIs
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 […]
How to architect a hybrid Microsoft SQL Server solution using distributed availability groups
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 […]
Bootstrapping Your Large Production On-Premises SQL Server Databases to Amazon EC2
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 […]
New, Memory-Optimized Amazon EC2 Instance Types Drive Database Workloads
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 […]
Reading Amazon S3 Data from Oracle on Amazon EC2
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 […]
A Large-Scale Cross-Regional Migration of NoSQL DB Clusters
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, […]