AWS Database Blog

Tag: SQL Server

Multi-region SQL Server deployment using distributed availability groups

A multi-region architecture for SQL Server is often a topic of interest that comes up when working with our customers. The fundamental reasons why customers adopt a multi-region architecture approach for SQL Server deployments is: Business continuity and disaster recovery Geographically distributed customer base and improving latency for end-users This post explains the architecture patterns […]

Read More

Using Microsoft SQL Server Integration Services on Amazon RDS for SQL Server

You can now configure Microsoft SQL Server Integration Services (SSIS) on Amazon Relational Database Service (RDS) for SQL Server. SSIS works on Single-AZ and Multi-AZ DB instances for both Standard and Enterprise editions using either the 2016 or 2017 SQL Server major versions. Previously, you could use RDS for SQL Server as a target source […]

Read More

Configuring Microsoft SQL Server Reporting Services on Amazon RDS for SQL Server

You can now run Microsoft SQL Server Reporting Services (SSRS) directly on an Amazon Relational Database Service (RDS) for SQL Server DB instance. You can activate SSRS on Single-AZ or Multi-AZ instances on the Standard or Enterprise editions of SQL Server 2017. If you run SSRS on Amazon Elastic Compute Cloud (Amazon EC2), you can […]

Read More

Enabling distributed transaction support for domain-joined Amazon RDS for SQL Server instances

Amazon Relational Database Service (RDS) for SQL Server now supports distributed transactions using Microsoft Distributed Transaction Coordinator (MSDTC). With MSDTC, you can run distributed transactions involving RDS for SQL Server DB instances. This post goes over the most common ways to run distributed transactions when using Amazon RDS for SQL Server using AWS Directory Service […]

Read More

Configuring Microsoft SQL Server Analysis Services on Amazon RDS for SQL Server

You can now configure Microsoft SQL Server Analysis Services (SSAS) in the Tabular model on Amazon RDS for SQL Server. SSAS works in the Single-AZ configuration for both Standard and Enterprise editions using either the 2016 or 2017 SQL Server Major version. If you run SSAS on Amazon EC2, you can save on costs by […]

Read More

Using in-Region read replicas in Amazon RDS for SQL Server

Amazon RDS for SQL Server now supports in-Region read replicas, which give you the ability to offload your read workloads from your primary database instance to a replica. Read replicas use the built-in distributed availability groups feature and are available for Enterprise Edition. A distributed availability group is an availability group that spans two separate […]

Read More

Migrating your on-premises SQL Server Windows workloads to Amazon EC2 Linux

For decades, IT administrators could only run their SQL Server workloads on Windows. However, as of SQL Server 2017, SQL Server is now available to run in the Linux operating system. For IT administrators, this represents an opportunity to run SQL Server workloads on their preferred operating system, save on Windows Server licensing costs, and […]

Read More

Enabling SSL encrypted connections to Microsoft SQL Server using AWS Certificate Manager Private Certificate Authority

Organizations moving to secure their critical data worry about while it’s both at-rest and in transit. Relational databases are a common example of situations in which business-critical data must be secured. Microsoft SQL Server lets you secure the in-transit data using Secure Sockets Layer (SSL) encryption. This post reviews the process of enabling SSL encryption […]

Read More

Store SQL Server backups in Amazon S3 using AWS Storage Gateway

Customers like Alkami and Acadian Asset Management use AWS Storage Gateway to back up their Microsoft SQL Server databases directly to Amazon S3, reducing their on-premises storage footprint and leveraging S3 for durable, scalable, and cost-effective storage. Storage Gateway is a hybrid cloud storage service providing on-premises applications with access to virtually unlimited cloud storage. […]

Read More

Upgrade your end-of-support SQL Server instances in VMware Cloud on AWS with ease

If you still have Microsoft SQL Server 2008 and 2008 R2 instances deployed, now is the time to upgrade them. Microsoft end of support (EoS) date for each is almost upon us—July 9, 2019. This means that after that there are no further security updates, which has security and also compliance implications, so don’t wait! Today, I’m excited […]

Read More