There are multiple ways to deploy the databases in the AWS RDS SQL Server. Suppose you want to migrate your on-premises SQL Server database to AWS managed relational database service and you have a critical application and require minimal (almost zero) downtime. For this purpose, you can use the AWS Database Migration Service (AWS DMS) in a combination of SQL Server native backups.
Read more »Rajendra Gupta
- Migrating your on-premises SQL databases to AWS RDS SQL Server using AWS DMS - January 25, 2021
- Synchronize logins between Availability replicas in SQL Server Always On Availability Groups - January 21, 2021
- Export Amazon Aurora MySQL or Amazon RDS snapshots to AWS S3 buckets - January 19, 2021

Synchronize logins between Availability replicas in SQL Server Always On Availability Groups
January 21, 2021In this 40th article on SQL Server Always On Availability Group series, we will discuss logins synchronization between replicas.
Read more »
Export Amazon Aurora MySQL or Amazon RDS snapshots to AWS S3 buckets
January 19, 2021In this article, we will explore the following topics:
- Amazon Aurora or Amazon RDS database snapshot export to S3 bucket
- Use AWS Glue to crawl the Snapshot and generate a data catalog
- Use Amazon Athena to query the data catalog
- Export Amazon Athena query results into S3 bucket

SQL Server PolyBase external tables with Azure Blob Storage
January 15, 2021In this article, we will explore SQL Server PolyBase external tables with Azure Blob Storage.
Read more »
Database Cloning in Amazon Aurora
January 11, 2021Amazon Aurora provides a MySQL and PostgreSQL compatible relation database with performance and feature enhancements over the existing databases. In the previous articles, we discussed the following features. You can refer to ToC at the bottom.
- Backtrack
- Global Database
- Amazon Aurora Serverless
In this article, we will cover fast database cloning and its usage for aurora databases.
Read more »
Implement an Amazon Aurora Serverless cluster
January 4, 2021In this 4th article for the Amazon Aurora series, we will discuss and implement an Amazon Aurora Serverless cluster.
Read more »
Rewind or Forward the Amazon Aurora Cluster with MySQL compatibility using backtrack feature
December 24, 2020In this article, we will explore the useful backtrack feature for Amazon Aurora clusters.
Read more »
Explore Amazon Aurora global databases with MySQL compatibility
December 21, 2020In the article, Deploy your AWS RDS Aurora database clusters for MySQL, we explored the Amazon Aurora concept and deployment. In this article, we will understand about the global database feature and its implementations.
Read more »
Deploy your Amazon Aurora database clusters for MySQL
December 18, 2020Introduction
Amazon offers managed database service for various database products such as Microsoft SQL Server, MySQL, PostgreSQL, Oracle. In these relational database services (RDS), AWS manages the operating system, networking components, backups, monitoring solutions. In the previous articles, we explored many useful RDS features under the AWS RDS category on SQLShack.
Read more »
Web Scraping for SQL Machine learning using R scripts
December 14, 2020In this article, we will explore Web Scraping using R Scripts for SQL Machine Learning.
Read more »
Configure Integration Services Catalog Database SSISDB in SQL Server Always On Availability Groups
December 14, 2020In this 39th article for SQL Server Always On Availability Group series, we will learn to configure SSISDB in the highly available AG groups.
Read more »
Configure SQL Server Always On Availability Groups using Windows PowerShell scripts
December 10, 2020In this 38th article for SQL Server Always On Availability Groups, we will explore Windows PowerShell scripts to configure it.
Read more »
How to install SQL Server 2019 on RedHat Linux 18
December 9, 2020In this article, we will learn to install SQL Server 2019 on the RedHat Linux 18 on a virtual machine.
Read more »
Import data from PDF files using R Scripts SQL Server
December 8, 2020In this article, we will read and import data from a PDF file using the R scripts SQL Server.
Read more »
Import and Export data using R and SQL Server
December 3, 2020Data professionals get requests to import, export data into various formats. These formats can be such as Comma-separated data(.CSV), Excel, HTML, JSON, YAML, Tab-separated data(.TSV). Usually, we use SQL Server integration service ETL packages for data transformations, import or export data.
Read more »
Working with images in SQL Machine Learning using R scripts
November 27, 2020In the article, An overview of SQL Machine Learning with R scripts, we learned the R services integration with SQL Server 2019. We also explored a few useful external packages.
Read more »
An overview of SQL Machine Learning with R scripts
November 25, 2020In this article, we will focus on SQL Machine Learning using R scripts and the use of external packages.
Read more »
Split native databases backup and restore for AWS RDS SQL Server from AWS S3 buckets
November 24, 2020In this article, we will explore how to split native backup and restore for AWS RDS SQL Server from the AWS S3 bucket.
Read more »
Configure SQL Server Replication between AWS RDS SQL Server and On-premises SQL Server
November 20, 2020In this article, we will implement a SQL Server Replication between AWS RDS SQL Server and On-premises SQL Server instance.
Read more »
Dynamic management views for monitoring availability replicas and databases for SQL Server Always On Availability Groups
November 19, 2020In this 37th article for SQL Server Always On Availability Groups, we will explore useful dynamic management views for monitoring availability replicas and databases.
Read more »
Explore dynamic management views for monitoring SQL Server Always On Availability Groups
November 16, 2020In this 36th article for SQL Server Always On series, we will explore various dynamic management views (DMV’s) for monitoring the AG replicas.
Read more »
Explore the SQL query table hint READPAST
November 14, 2020SQL Server creates an optimized execution plan based on the available inputs such as statistics, indexes. By default, it chooses a cost-optimized execution plan and executes the query. Sometimes, we use SQL queries table hints to override the default mechanism. Developers popularly use WITH (NOLOCK) query hint in a Select statement to avoid blocking issues.
Read more »
Custom policies for AG dashboards of SQL Server Always On Availability Groups
November 10, 2020In this 35th article in SQL Server Always On Availability Groups, we will implement a custom policy for monitoring AG groups.
Read more »
The Hub and Spoke model of policy-based management for SQL Server Always On Availability Groups
November 9, 2020In this 34th article on SQL Server Always On Availability Groups, we will explore policy-based management features for the AG’s.
Read more »
An Overview of User-defined SQL Server Types
November 3, 2020In this article, we will explore User-defined SQL Server Types and their usage.
Read more »