This article deploys a new AWS RDS SQL Server using the AWS CLI command: create-db-instance.
Read more »Technologies
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 »MySQL Create Table statement with examples
May 13, 2020In this article, I am going to explain the MySQL CREATE TABLE statement with examples. The following syntax contains basic statements to create a table in MySQL.
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 »How to backup and restore MySQL databases using the mysqldump command
May 12, 2020In this article, I am going to explain different ways to generate the backup in the MySQL database server. As we know, data is a valuable asset to the organization. As database administrators, it is our primary and crucial job to keep the data available and safe. If the system or data center fails, database corruption, and data loss, we must be able to recover it within the defined SLA.
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 »Deploy MySQL InnoDB Clusters for high availability
May 8, 2020In this article, I am going to explain how we can deploy the MySQL InnoDB cluster. InnoDB Cluster is a high availability solution provided by MySQL that has single and multi-master capabilities and failover detection.
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 »How to connect to a remote MySQL server using SSL on Ubuntu
April 28, 2020In this article, the steps to connect to remote MySQL databases using Secure Sockets Layer (SSL) will be shown. MySQL is one of the most popular relational database management systems and by default, is configured to accept only connections from the machine where MySQL is installed. To connect to the MySQL database which sits on another machine, the additional configuration must be set to accept the remote connection with secure SSL encryption.
Read more »Deploying Azure Databases for MySQL server using Azure Portal
April 24, 2020In this article, I am going to explain the step by step process to create an Azure Database for MySQL Server. Azure Database for MySQL is a fully-managed database as a service that uses MySQL community edition. It can manage the mission-critical workload with dynamic scalability. We can use it to develop various applications that leverage open-source tools and cross-platform applications. Let me explain these steps of a deployment process of MySQL Server on Azure.
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 »Enterprise Data Masking in MySQL
April 15, 2020In this article, I am going to explain Data Masking feature in MySQL. The data masking is the MySQL enterprise edition feature. You can download the trial version of MySQL enterprise edition from here. Data Masking is a process of hiding confidential data like credit card information, SSNs, addresses etc. to safeguard sensitive data.
Read more »Start your journey with Azure Cosmos DB
April 6, 2020In this article, we will discuss why we need to use Azure Cosmos DB and how to configure it to store and query our data.
Read more »How to install MySQL database server 8.0.19 on Windows 10
March 19, 2020In this article, I am going to explain the step by step installation process of MySQL database server 8.0.19. MySQL is open-source, cross-platform relational database management server developed by Swedish company “MySQL AB” and later acquired by Oracle corporation. MySQL is offered as an open-source MySQL community server edition and enterprise server edition. In this article, I am going to install the MySQL Community server edition.
Read more »