Read our blog for the latest insights on sales and marketing Take Me There

Webinar: Document Merge in wMobile Desktop for GoldMine Register

Amazon RDS May 2020 Update

Released on May 25th, 2020

Amazon RDS for PostgreSQL Supports PostgreSQL 12 and New Minor Versions 11.7, 10.12, 9.6.17, and 9.5.21 in AWS GovCloud (US) Regions

Following the announcement of updates to the PostgreSQL database, AWS has updated Amazon RDS for PostgreSQL in GovCloud (US) to support PostgreSQL major version 12 and minor versions 11.7, 10.12, 9.6.17, and 9.5.21. This release contains bug fixes and improvements done by the PostgreSQL community.  

PostgreSQL 12 includes improved functionality and performance. Version 12 also includes management of indexing, improved partitioning capabilities, JSON path queries per SQL/JSON specifications, nondeterministic collations which support case-insensitive and accent-insensitive comparisons for ICU provided collations, most common-value statistics for improved query plans, creation of generated columns that computes values with an expression, and many additional features. 

The PostgreSQL 12 release updates extensions including PostGIS to version 3.0, PGAudit to version 1.4, wal2json to version 2.1, PLV8 to version 2.3.14, Orafce to version 3.8, pg_repack to version 1.4.5, pg_hint_plan to version 1.3.5.22a77c, and pglogical to version 2.3.0. For minor versions 11.7, 10.12, 9.6.17, and 9.5.21, this release updates the orafce extension to version 3.8 and the wal2json extension to version 2.1.

Amazon RDS for PostgreSQL makes it easy to set up, operate, and scale PostgreSQL deployments in the cloud. Learn more about upgrading your database instances from the Amazon RDS User Guide. See Amazon RDS for PostgreSQL Pricing for pricing details and regional availability. 

Amazon RDS for SQL Server now Supports SQL Server Integration Services (SSIS)

Starting today, Amazon RDS for SQL Server supports SQL Server Integration Services (SSIS) directly on RDS DB instances. There is no additional cost to install SSIS directly on your Amazon RDS DB instance. 

If you are currently running SSIS on Amazon EC2, you can now save costs by running SSIS directly on the same RDS DB instance as your SQL Server database. With SSIS, you can extract and transform data from a wide variety of sources such as XML data files, flat files, and relational data sources, and then load the data into one or more destinations. 

Learn more about how to configure SSIS in RDS from this Blog post and see the Amazon Relational Database Services User Guide for more information. 

Amazon RDS for SQL Server makes it easy to set up, operate, and scale SQL Server deployments in the cloud. See Amazon RDS for SQL Server Pricing for pricing details and regional availability. 

Amazon RDS for SQL Server now Supports SQL Server Reporting Services (SSRS)

Starting today, Amazon RDS for SQL Server supports SQL Server Reporting Services (SSRS), giving you the ability to host the report server web portal on the same Amazon RDS DB instance as your SQL Server database. There is no additional cost to install SSRS directly on your Amazon RDS DB instance. 

If you are currently running SSRS on Amazon EC2, you can now save costs by running SSRS directly on the same RDS DB instance as your SQL Server database. SSRS is currently available on Amazon RDS for SQL Server 2017 on both the Standard and Enterprise editions. 

Learn more about how to configure SSRS in RDS from this Blog post and see the Amazon Relational Database Services User Guide for more information. 

Amazon RDS for SQL Server makes it easy to set up, operate, and scale SQL Server deployments in the cloud. See Amazon RDS for SQL Server Pricing for pricing details and regional availability. 

Amazon RDS for SQL Server Supports Bulk Insert on Highly Available DB Instances Using Amazon S3 Integration

Starting today, Amazon RDS for SQL Server supports S3 integration in both the Multi-AZ and Single-AZ configurations, giving you the ability to transfer files between your DB instance and Amazon S3 using features such as Bulk Insert. 

With the support of S3 integration, you can download .csv, .xml, .txt. and other file types from Amazon S3 directly to your Amazon RDS for SQL Server database and import that data with Bulk Insert. 

See the Amazon Relational Database Services User Guide for more information. 

Amazon RDS for SQL Server makes it easy to set up, operate, and scale SQL Server deployments in the cloud. See Amazon RDS for SQL Server Pricing for pricing details and regional availability. 

Amazon RDS for Oracle now Supports April 2020 Oracle Patch Set Updates (PSU) and Release Updates (RU)

Amazon RDS for Oracle now supports the April 2020 Patch Set Updates (PSU) for Oracle Database 11.2 and 12.1, and April 2020 Release Update (RU) for Oracle Database 12.2, 18c and 19c. 

Oracle PSUs contain bug fixes and other critical security updates. Beginning with Oracle Database version 12.2.0.1, Amazon RDS for Oracle supports Release Updates (RU) in place of the PSU. To learn more about the Oracle PSUs supported on Amazon RDS, please visit the Amazon RDS patch update documentation.  

Amazon RDS for Oracle makes it easy to set up, operate, and scale Oracle Database deployments in the cloud. See the Amazon RDS for Oracle Database Pricing page for complete regional availability information.  

Amazon RDS for PostgreSQL Supports R5, M5, and T3 Instance Types now Available in AWS China (Beijing) Region, Operated by Sinnet and in AWS China (Ningxia) Region, Operated by NWCD

You can now launch R5, M5, and T3 instance types when using Amazon RDS for PostgreSQL.  

R5 instances are the latest generation of memory optimized instances that deliver 5% additional memory per vCPU than R4, with the largest size providing 768 GiB of memory. In addition, R5 instances deliver a 10% price per GiB improvement and a ~20% increase in CPU performance over R4. 

M5 instances are the latest generation of General Purpose Instances and provide improved performance over M4 instances. This family provides a balance of compute, memory, and network resources, and is a good choice for many database workloads. 

T3 instances are the next generation burstable general-purpose instances that provide a baseline level of CPU performance with the ability to burst CPU usage at any time for as long as required. T3 instances offer a balance of compute, memory, and network resources and are ideal for database workloads with moderate CPU usage that experience temporary spikes in use. 

Amazon RDS database instances running PostgreSQL versions 9.6.16 and higher, 10.11 and higher, 11.6 and higher, and 12.2 and higher are supported with these new instance types. You can easily scale up to these new instance classes by modifying your existing DB instance in the AWS RDS Management Console

Please refer to the Amazon RDS User Guide for more details and refer to Amazon RDS Pricing for pricing details. 

Amazon RDS for SQL Server now Supports Distributed Transactions

Starting today, Amazon RDS for SQL Server supports distributed transactions using Microsoft Distributed Transaction Coordinator (MSDTC). You can execute distributed transaction on DB instances that are domain joined using the AWS Directory Service for Microsoft Active Directory

With MSDTC you can either execute the transaction using SQL Server as the Transaction manager using linked servers, or you can promote MSDTC running on the same host as the Client application to the role of Transaction manager. 

Learn more about how to configure MSDTC in RDS from this Blog post, and see the Amazon Relational Database Services User Guide for more information. 

Amazon RDS for SQL Server makes it easy to set up, operate, and scale SQL Server deployments in the cloud. See Amazon RDS for SQL Server Pricing for pricing details and regional availability. 

Amazon RDS Performance Insights Supports SQL-Level Metrics on Amazon Aurora with MySQL Compatibility

Amazon RDS Performance Insights supports SQL-level metrics on Amazon Aurora with MySQL-compatibility, a relational database built for the cloud. With RDS Performance Insights SQL-level metrics, you can identify high-frequency, long-running, and stuck SQL queries in seconds.  

Previously, gathering performance data on a database required configuration and maintenance of monitoring applications and related resources. Correlating performance data took hours without specialized expertise. To find a query of interest, such as a stuck or long-running SQL query, meant investigating each query one at a time.  

RDS Performance Insights allows non-experts and experts to identify top SQL loads and from where they originated on a visual dashboard in seconds. Now, RDS Performance Insights also collects SQL-level metrics such as average latency, calls per second, and rows returned per call. You can determine if a SQL query takes too long to complete or if a particular SQL query is called at a different rate than you expect and then make improvements to your application such as optimizing a slow SQL query, adding an index to your database, and scaling your database. 

Amazon RDS Performance Insights is a database performance tuning and monitoring feature of RDS that allows you to visually assess the load on your database and determine when and where to take action. With one click in the Amazon RDS Management Console, you can add a fully managed performance monitoring solution to your Amazon RDS database. RDS Performance Insights is included with supported Amazon Aurora clusters and Amazon RDS instances and stores seven days of performance history in a rolling window at no additional cost. If you need longer-term retention, you can choose to pay for up to two years of performance history retention.  

For a complete list of regions where RDS Performance Insights is offered, see AWS Regions. To learn more about RDS Performance Insights and supported database engines, read the Amazon RDS User Guide.  

Amazon RDS for SQL Server now Supports Windows Authentication in more AWS Regions

Amazon RDS for SQL Server expands support for Windows authentication using the AWS Managed Microsoft AD service in more AWS Regions. You can now use Windows authentication in these additional Regions: US West (N. California), South America (São Paulo), Asia Pacific (Mumbai), EU (Paris), and Asia Pacific (Hong Kong).

To join your Amazon RDS DB instances to a domain in a different account, share your AWS Managed Microsoft AD directory from the directory owner account and join the shared domain seamlessly using the AWS Management Console or CLI. Please refer to the Joining your Amazon RDS DB instance across accounts to a single shared domain blog post for more details.

Amazon RDS for SQL Server makes it easy to set up, operate, and scale SQL Server deployments in the cloud. See Amazon RDS for SQL Server Pricing for pricing details and regional availability. 

« Back to Releases

Trustpilot