AWS RDS SQL Server Announcements - 2020

AWS RDS SQL Server Announcements - 2020

1.   Amazon RDS for SQL Server Now Supports Joining a Domain Across AWS Accounts and VPCs using Managed Microsoft AD: https://aws.amazon.com/about-aws/whats-new/2020/02/amazon-rds-for-sql-server-now-supports-joining-domain-across-aws-accounts-and-vpcs-using-microsoft-managed-ad/

2.  Amazon RDS for SQL Server now supports Z1d instances: https://aws.amazon.com/about-aws/whats-new/2020/02/amazon-rds-for-sql-server-now-supports-z1d-instances/

3.  Amazon RDS for SQL Server now supports In-Region Read Replicas: https://aws.amazon.com/about-aws/whats-new/2020/04/amazon-rds-for-sql-server-now-supports-in-region-read-replicas/

4.  Amazon RDS for SQL Server supports new Minor Versions: https://aws.amazon.com/about-aws/whats-new/2020/04/amazon-rds-for-sql-server-supports-new-minor-versions/

5.  Amazon RDS for SQL Server now supports Windows authentication in more AWS Regions: https://aws.amazon.com/about-aws/whats-new/2020/05/amazon-rds-for-sql-server-now-supports-windows-authentication-in-more-aws-regions/

6.  Amazon RDS for SQL Server now supports Multifile Native Backups: https://aws.amazon.com/about-aws/whats-new/2020/04/amazon-rds-for-sqlserver-now-supports-multi-file-native-backups/

7.  Amazon RDS for SQL Server now supports SQL Server Analysis Services (SSAS): https://aws.amazon.com/about-aws/whats-new/2020/04/amazon-rds-sql-server-now-supports-sql-server-analysis-service/

8.  Amazon RDS for SQL Server now supports Distributed Transactions: https://aws.amazon.com/about-aws/whats-new/2020/05/amazon-rds-for-sql-server-now-supports-distributed-transactions/

9.   Amazon RDS for SQL Server supports Bulk Insert on highly available DB Instances using Amazon S3 Integration: https://aws.amazon.com/about-aws/whats-new/2020/05/amazon-rds-for-sql-server-now-supports-sql-server-bulk-insert/

10. Amazon RDS for SQL Server now supports SQL Server Reporting Services (SSRS): https://aws.amazon.com/about-aws/whats-new/2020/05/amazon-rds-for-sql-server-now-supports-sql-server-reporting-services/

11. Amazon RDS for SQL Server now supports SQL Server Integration Services (SSIS): https://aws.amazon.com/about-aws/whats-new/2020/05/amazon-rds-for-sql-server-now-supports-sql-server-integration-services/

12. Amazon RDS for SQL Server now supports Windows authentication in the AWS GovCloud (US) Regions: https://aws.amazon.com/about-aws/whats-new/2020/07/amazon-rds-for-sql-server-now-supports-windows-authentication-in-the-aws-govcloud-regions/

13. Amazon RDS for SQL Server Supports Disabling Old Versions of TLS and Ciphers: https://aws.amazon.com/about-aws/whats-new/2020/07/amazon-rds-for-sql-server-supports-disabling-old-versions-of-tls-and-ciphers/

14. Amazon RDS for SQL Server now supports Service Master Key Retention https://aws.amazon.com/about-aws/whats-new/2020/07/amazon-rds-for-sql-server-now-supports-service-master-key-retention/

15. Amazon RDS for SQL Server lowers the cost for High Availability DB Instances: https://aws.amazon.com/about-aws/whats-new/2020/07/amazon-rds-for-sql-server-lowers-cost-for-high-availability-db-instances/

16. Amazon RDS for SQL Server now Supports SQL Server Major Version 2019 https://aws.amazon.com/about-aws/whats-new/2020/08/amazon-rds-for-sql-server-now-supports-sql-server-major-version-2019/

17. Amazon RDS for SQL Server now Supports Trace Flag 692 https://aws.amazon.com/about-aws/whats-new/2020/08/amazon-rds-for-sql-server-now-supports-trace-flag-692/

18. Amazon RDS for SQL Server Now Supports More Time Zones https://aws.amazon.com/about-aws/whats-new/2020/09/amazon-rds-for-sql-server-now-supports-more-time-zones/

19. Amazon RDS for SQL Server Now Supports Native Backup/Restore on DB Instances with Read Replicas https://aws.amazon.com/about-aws/whats-new/2020/09/amazon-rds-for-sql-server-now-supports-native-backup-restore-on-db-instances-with-read-replicas/

20. Amazon RDS for SQL Server Now Supports SQL Server Reporting Services (SSRS) on SQL Server 2016 https://aws.amazon.com/about-aws/whats-new/2020/09/amazon-rds-for-sql-server-now-supports-ssrs-on-sql-server-2016/

21. Amazon RDS for SQL Server Now Supports High Availability in AWS US West (Northern California) Region https://aws.amazon.com/about-aws/whats-new/2020/09/amazon-rds-for-sql-server-now-supports-high-availability-in-northern-california/

22. Amazon RDS for SQL Server now supports Database Mail https://aws.amazon.com/about-aws/whats-new/2020/11/amazon-rds-sql-server-supports-database-mail/

23. Amazon RDS for SQL Server now supports the Business Intelligence Suite on SQL Server 2019 https://aws.amazon.com/about-aws/whats-new/2020/11/amazon-rds-for-sql-server-now-supports-the-business-intelligence/

24. Introducing Amazon RDS Service Delivery Partners https://aws.amazon.com/about-aws/whats-new/2020/12/introducing-amazon-rds-service-delivery-partners/

AWS RDS SQL Server Announcements - 2019

AWS RDS SQL Server Announcements - 2019

1.    Amazon RDS SQL Server Supports differential and log and restores: https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-for-sql-server-now-supports-differential-restores-and-log-restores/ 

2.    Amazon RDS SQL Server now supports logs to cloudwatch: https://aws.amazon.com/about-aws/whats-new/2019/11/now-publish-log-files-amazon-rds-sql-server-amazon-cloudwatch/ 

3.    Amazon RDS SQL Server now supports high availability in more regions (BJS, ARN, HKG, and BAH): https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-for-sql-server-adds-high-availability-support-in-additional-aws-regions/ 

4.    Amazon RDS SQL Server S3 file transfers allowing for Bulk insert to work on Single AZ instances (multi-az support in Q1 020): https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/User.SQLServer.Options.S3-integration.html 

5.    Amazon RDS SQL Server supports outbound network access (cross vpc linked servers now supported):https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-sql-server-supports-outbound-network-access/ 

6.    Amazon RDS SQL Server now supports X1e and X1 instances: https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-for-sql-server-now-supports-x1-and-x1e-instance-types/ 

7.    Amazon RDS SQL Server now supports R5s and T3s: https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-for-sql-server-now-supports-r5-and-t3-instance-types/ 

8.    Amazon RDS SQL Server now supports 8xl and 16xl for nitro instances: https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-for-sql-server-now-supports-additional-instance-sizes/

9.     Amazon RDS now supports Storage Auto Scaling: https://aws.amazon.com/about-aws/whats-new/2019/06/rds-storage-auto-scaling/

10.  Amazon RDS for SQL Server now supports additional instance sizes: https://aws.amazon.com/about-aws/whats-new/2019/06/rds-storage-auto-scaling/

11.  Amazon RDS Performance Insights Supports Counter Metrics on Amazon RDS for SQL Server: https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-performance-insights-supports-counter-metrics-on-amazon-rds-for-sql-server/

12.  Amazon RDS SQL Server now supports changing the server-level collation: https://aws.amazon.com/about-aws/whats-new/2019/08/amazon-rds-sql-server-supports-changing-server-level-collation/

13.  Amazon RDS for SQL Server now Supports Multi-File Native Restores: https://aws.amazon.com/about-aws/whats-new/2019/06/amazon-rds-for-sql-server-now-supports-multi-file-native-restores/

14.  Amazon RDS for SQL Server now Supports SQL Server Audit: https://aws.amazon.com/about-aws/whats-new/2019/05/amazon-rds-for-sql-server-supports-sql-server-audit/

15.  Amazon RDS for SQL Server Now Supports Always On Availability Groups for SQL Server 2017: https://aws.amazon.com/about-aws/whats-new/2019/05/amazon-rds-for-sql-server-now-supports-always-on-availability-groups-for-sql-server-2017/

16.  Amazon RDS for SQL Server Increases the Database Limit Per Database Instance up to 100: https://aws.amazon.com/about-aws/whats-new/2019/05/amazon_rds_for_sql_server_increases/

17.  Performance Insights is Generally Available on Amazon RDS for SQL Server: https://aws.amazon.com/about-aws/whats-new/2019/03/performance-insights-is-generally-available-for-sql-server/

AWS RDS SQL Server Version List

AWS RDS SQL Server 2017 Builds
RDS SQL Server version	SQL Server Build	KB / Description
SQL Server 2017 14.00.3223.3.v1	14.0.3223.3	4508218 Cumulative update 16 (CU16) for SQL Server 2017
SQL Server 2017 14.00.3192.v1	14.0.3192.2	4505225 Security update for SQL Server 2017 CU15 GDR: July 9, 2019
SQL Server 2017 14.00.3049.1.v1	14.0.3049.1	4483666 On-demand hotfix update package for SQL Server 2017 Cumulative update 13 (CU13)
SQL Server 2017 14.00.3035.2.v1	14.0.3035.2	4293805 Security update for the Remote Code Execution vulnerability in SQL Server 2017 CU: August 14, 2018
SQL Server 2017 14.00.3015.40.v1	14.0.3015.40	4052987 Cumulative update 3 (CU3) for SQL Server 2017 – Security Advisory ADV180002
SQL Server 2017 14.00.1000.169.v1	14.0.1000.169	Microsoft SQL Server 2017 RTM
AWS RDS SQL Server 2016 Builds
RDS SQL Server version	SQL Server Build	KB / Description
SQL Server 2016 13.00.5426.0.v1	13.0.5426.0	4505830 Cumulative update 8 (CU8) for SQL Server 2016 Service Pack 2
SQL Server 2016 13.00.5366.0.v1	13.0.5366.0	4505222 Security update for SQL Server 2016 SP2 CU7 GDR: July 9, 2019
SQL Server 2016 13.00.5292.0.v1	13.0.5292.0	4488536 Cumulative update 6 (CU6) for SQL Server 2016 Service Pack 2
SQL Server 2016 13.00.5216.0.v1	13.0.5216.0	4458871 Cumulative update 3 (CU3) for SQL Server 2016 Service Pack 2
SQL Server 2016 13.00.4522.0.v1	13.0.4522.0	4293808 Security update for the Remote Code Execution vulnerability in SQL Server 2016 SP1 CU: August 14, 2018
SQL Server 2016 13.00.4466.4.v1	13.0.4466.4	4057119 Cumulative update 7 (CU7) for SQL Server 2016 Service Pack 1 – Security Advisory ADV180002
SQL Server 2016 13.00.4451.0.v1	13.0.4451.0	4040714 Cumulative update 5 (CU5) for SQL Server 2016 Service Pack 1
SQL Server 2016 13.00.4422.0.v1	13.0.4422.0	4013106 Cumulative update 2 (CU2) for SQL Server 2016 Service Pack 1
SQL Server 2016 13.00.2164.0.v1	13.0.2164.0	3182270 Cumulative update 2 (CU2) for SQL Server 2016
AWS RDS SQL Server 2014 Builds
RDS SQL Server version	SQL Server Build	KB / Description
SQL Server 2014 12.00.6293.0.v1	12.0.6293.0	4505422 Security update for SQL Server 2014 SP3 CU3 GDR: July 9, 2019
SQL Server 2014 12.00.5571.0.v1	12.0.5571.0	4052725 Cumulative update package 10 (CU10) for SQL Server 2014 Service Pack 2 – Security Advisory ADV180002
SQL Server 2014 12.00.5546.0.v1	12.0.5546.0	4013098 Cumulative update package 5 (CU5) for SQL Server 2014 Service Pack 2
SQL Server 2014 12.00.5000.0.v1	12.0.5000.0	SQL Server 2014 Service Pack 2 (SP2)
AWS RDS SQL Server 2012 Builds
RDS SQL Server version	SQL Server Build	KB / Description
SQL Server 2012 11.00.7462.6.v1	11.0.7462.6	4057116 Description of the security update for SQL Server 2012 SP4 GDR: January 12, 2018 – Security Advisory ADV180002
SQL Server 2012 11.00.6594.0.v1	11.0.6594.0	4013104 Cumulative update package 8 (CU8) for SQL Server 2012 Service Pack 3
SQL Server 2012 11.00.6020.0.v1	11.0.6020.0	SQL Server 2012 Service Pack 3 (SP3)
SQL Server 2012 11.00.5058.0.v1 except US East (Ohio), Canada (Central), and Europe (London)	11.0.5058.0	SQL Server 2012 Service Pack 2 (SP2)
Date	Information
July 12, 2019	The Amazon RDS team deprecated support for Microsoft SQL Server 2008 R2 in June 2019.
April 25, 2019	Before the end of April 2019, you will no longer be able to create new Amazon RDS for SQL Server database instances using Microsoft SQL Server 2008R2.