Updating sql server 2016
You can also force all connections to your DB instance to use SSL.If you force connections to use SSL, it happens transparently to the client, and the client doesn't have to do any work to use SSL.
Amazon RDS currently supports Multi-AZ deployments for SQL Server using SQL Server Mirroring as a high-availability, failover solution.The DB instance class you need depends on your processing power and memory requirements. The following are the latest-generation DB instance classes supported for Microsoft SQL Server. Any user who creates a database is assigned to the db_owner role for that database and has all database-level permissions except for those that are used for backups. The following server-level roles are not currently available in Amazon RDS: AWS Services in Scope have been fully assessed by a third-party auditor and result in a certification, attestation of compliance, or Authority to Operate (ATO).For more information, see AWS Services in Scope by Compliance Program.With Amazon RDS, you can create DB instances and DB snapshots, point-in-time restores, and automated or manual backups.DB instances running SQL Server can be used inside a VPC.Multi-AZ Deployments A production DB instance should use Multi-AZ deployments.
Multi-AZ deployments provide increased availability, data durability, and fault tolerance for DB instances.
In general, if your DB instance is on the Connecting to Your DB Instance After creating a security group and associating it to a DB instance, you can connect to the DB instance using any standard SQL client application such as Microsoft SQL Server Management Studio.
If you have a scenario that requires a larger amount of storage, you can use sharding across multiple DB instances to get around the limit.
In order to deliver a managed service experience, Amazon RDS does not provide shell access to DB instances, and it restricts access to certain system procedures and tables that require advanced privileges.
Amazon RDS supports access to databases on a DB instance using any standard SQL client application such as Microsoft SQL Server Management Studio.
This approach requires data-dependent routing logic in applications that connect to the sharded system.