SQL Server Always On is a high-availability and disaster recovery solution. We can use multiple secondary replicas for configuring database backups, redirect read requests to offload primary instance load.
Read more »
AWS RDS
Getting started with AWS RDS SQL Server
June 19, 2020This article describes the concepts and steps to setup AWS RDS SQL Server(Relational Database Service) — a web service which gives the ability to set up and scale relational database within AWS.
Read more »
Deploying an AWS RDS SQL Server using the AWS CLI
June 19, 2020This article deploys a new AWS RDS SQL Server using the AWS CLI command: create-db-instance.
Read more »
Getting started with Amazon QuickSight
June 18, 2020In this article, I am going to introduce Amazon QuickSight and how to visualize data using it. Amazon QuickSight is a data visualization tool offered by Amazon hosted on AWS and is available across multiple locations. As per the statement provided on the official website it says: “Amazon QuickSight is a fast, cloud-powered business intelligence service that makes it easy to deliver insights to everyone in your organization.” Using QuickSight, users can create different analyses and then integrate those in a dashboard and share them with people within the organization.
Read more »
Automatically Start/Stop an AWS RDS SQL Server using AWS Lambda functions
June 12, 2020This article gives you an overview of the AWS Lambda function to automatically start and stop AWS RDS SQL Server.
Read more »
How to stop an AWS RDS SQL Server using a web console and AWS CLI
June 11, 2020This article explores the process to stop an AWS RDS SQL Server using web console and AWS CLI.
Read more »
Calling an AWS Lambda function from another Lambda function
June 9, 2020In this article, I am going to explain how to create an AWS Lambda function and then call this function from another Lambda function within the same region. This is a useful scenario in which we may need to execute a second lambda function based on the outcome of some previous logic. Another scenario may be to execute a second lambda function several times by using different parameters.
Read more »
Getting started with AWS Toolkit for Visual Studio Code
June 8, 2020In this article, I am going to explain how to start using the AWS Toolkit for Visual Studio Code to develop serverless functions locally. Serverless applications or functions gives us the ability to develop, test and execute code in the cloud without having to worry about the underlying infrastructure. These applications are scalable which means we can easily increase or decrease the resources consumed by them. AWS Toolkit for Visual Studio Code is an extension available for Visual Studio Code using which we can directly communicate with the resources on Amazon within the code editor.
Read more »
Working with SSIS packages on AWS RDS SQL Server
June 3, 2020In the first part of the article, Explore SQL Server Integration Services (SSIS) on AWS RDS SQL Server, we understood that AWS RDS SQL Server supports SSIS functionality starting from May 19th, 2020.
Read more »
Explore SQL Server Integration Services (SSIS) on AWS RDS SQL Server
June 2, 2020In the previous article, Deploy tabular databases in SSAS on AWS RDS SQL Server, we explored that AWS RDS SQL Server now supports SQL Server Analysis Service (SSAS). It enables you to implement tabular project models for RDS instance as well. In this article, we will explore the support of SQL Server integration service in the RDS environment.
Read more »
Deploy tabular databases in SSAS on AWS RDS SQL Server
June 1, 2020In this article, we are going to explore Analysis Service for AWS RDS SQL Server in detail.
Read more »
Learn AWS CLI – Explore IAM users, roles, policies using AWS CLI
May 28, 2020AWS provides a command-line interface (AWS CLI) tool to work with its various cloud services. It is a single tool with many useful commands and allows you to automate a particular task using scripts. You might need to do specific tasks regularly. You can use the AWS Web Console for it. However, it requires you to go through all configuration options all over again.
Read more »
How to configure an Amazon RDS environment for MySQL
May 26, 2020In this article, I am going to explain how to configure the RDS MySQL Environment in AWS. RDS is the Relational Database Service Available from the Amazon which enables us to spin up any relational database instance without having to worry about the infrastructure behind it. Users can connect to this instance very easily and start building database applications with ease. This article will focus more on how to configure the RDS MySQL Environment and not much on the MySQL details.
Read more »
Advanced Windows Authentication configurations in AWS RDS SQL Server
May 13, 2020This article will cover advanced configurations for Windows Authentication in AWS RDS SQL Server.
Read more »
Initial Windows Authentication configurations in AWS RDS SQL Server
May 12, 2020In this article, we will be exploring the process of enabling Windows authentication in AWS RDS SQL Server.
Read more »
Integrating AWS S3 buckets with AWS RDS SQL Server
May 8, 2020This article gives you an overview of integrating AWS S3 buckets with AWS RDS SQL Server.
Read more »
Learn AWS CLI – Interact with AWS S3 Buckets using AWS CLI
April 30, 2020It is the second article in the Learn AWS CLI series. It gives you an overview of working with the AWS S3 bucket using CLI commands. We also look at a brief overview of the S3 bucket and its key components.
Read more »
Learn AWS CLI: An Overview of AWS CLI (AWS Command Line Interface)
April 22, 2020This article is the first article in the series of Learn AWS CLI. Here we will talk about the overview, installation, and configuration of CLI tools in Windows.
Read more »
Configuring RDS environment in AWS for SQL Server
April 16, 2020In this article, I’m going to explain how to configure an RDS Environment in Amazon Web Services (AWS) for SQL Server. Amazon RDS, also known as the Amazon Relational Database Service, is a Database-as-a-Service offered by Amazon. This enables us to create an instance of a relational database in RDS including many databases like SQL Server, MySQL, PostgreSQL etc. The entire hosting is managed by AWS, so there is no worry to maintain any on-premises data center or infrastructure from the customer’s end.
Read more »
Estimating AWS RDS SQL Server costs
January 23, 2020This article explores estimating the AWS RDS SQL Server cost so that you can plan resources accordingly.
Read more »
Auditing in AWS RDS SQL Server
January 20, 2020This article explores the server and database audit in AWS RDS SQL Server.
Read more »
An overview of native differential backups in AWS RDS SQL Server
December 9, 2019This article explores the differential backups in AWS RDS SQL Server using recovery scenarios.
Read more »
Query Amazon Athena external tables using SQL Server
November 15, 2019This article covers the following topics:
- Overview of the Amazon Athena
- Query CSV file stored in Amazon S3 bucket using SQL query
- Create SQL Server linked server for accessing external tables
Data Import from Amazon S3 SSIS bucket using an integration service (SSIS) package
October 28, 2019This article explores data import in SQL Server from a CSV file stored in the Amazon S3 SSIS bucket.
Read more »
Multi-AZ Configuration for AWS RDS SQL Server
October 10, 2019Amazon provides AWS RDS SQL Server as a managed relational database service. You can deploy databases instantly without worrying about underlying hardware platform, license cost, managing data centers. AWS RDS database instances are highly available. It provides a failover mechanism using the Mult-AZ deployments.
Read more »