AWS

Configure Replication Between an On-premises SQL Server and AWS RDS

  • Article

In this article, we will review how to migrate the data from on-premises SQL Server to AWS RDS for SQL Server using transactional replication. There are several ways to migrate data from on-premises SQL Server to AWS RDS for SQL Server and transactional replication is one among them. Configuring transactional replication between the on-premises SQL Server […]

2020-10-01

7,162 reads

Introduction to AWS Elastic Beanstalk

  • Article

The AWS Elastic Beanstalk feature is a web application provisioning service that allows you to automatically scale as needed. In this article, Gerald Bauer explains how to set up and configure Elastic Beanstalks through the AWS dashboard and Visual Studio.

2019-01-14

1,264 reads

SQL Server on Amazon Web Services (AWS)

  • Article

Relational Database Service (RDS) and Amazon Elastic Compute Cloud (EC2) are two different approaches, with their own advantages and limitations, for making Microsoft SQL Server (MS SQL Server) available and maintaining MS SQL Server databases on Amazon Web Services (AWS).

2018-11-28

2,382 reads

Questions About Amazon Data Migration Service (AWS DMS) That You Were Too Shy to Ask

  • Article

Can you imagine it? You are in a group of smart database people, and they are debating the finer points about AWS DMS, and you don't even know what the letters stand for. You just feel too shy to ask those basic questions that seem ridiculous once you're up to speed. Laerte Junior answers all the questions you need answers for when facing the prospect of getting familiar with Amazon's useful Database Migration Service.

2017-12-29

5,408 reads

Automating the Synchronization of RDS SQL Server Agent Jobs in a Multi-AZ Environment

  • Article

Although Azure is the obvious Cloud service to host SQL Server, Amazon Relational Database Service (RDS) for SQL Server is a good choice when your organisation uses AWS. RDS deals with maintenance and monitoring, and supports the use of PowerShell to automate routine tasks. What if a script needs to be triggered by an unscheduled event? Even in this case, RDS can be configured to run scripts to react when something like a failover happens. Laerte Junior shows how easy it is to set up Lambda functions and some PowerShell scripts to automatically synchronise agent jobs after a failover.

2017-08-30

2,895 reads

Blogs

Daily Coping 24 Sept 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Using environment variable files for SQL Server in containers

By

There are a whole bunch of environment variables that can be used to configure...

How to Design Backups in SQL Server?

By

The Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are basic concepts related...

Read the latest Blogs

Forums

Need an urgent help with creating a relational database!!

By LoneLostWolf

Hi guys, I'm quite new to T-SQL and honestly started to take online classes...

Need to Convert SQL Code Written for Azure SQLDW to SQL Server 2016

By carlton 84646

Hello Community, The attached SQL Script (Procedure) is compiled / written for Azure SQL...

SQL join based on column value

By learner0

I am trying to join two tables based on the condition. Table1: ID   ...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers