This article provides a step by step explanation of how to restore selective datasets from AWS Redshift snapshots to a working Redshift cluster, instead of restoring the entire backup.
Read more »Technologies
Deploy serverless applications using the AWS SAM CLI
August 18, 2020In this article, we are going to learn to deploy serverless applications to the AWS Cloud using the AWS SAM CLI. This article is a part of the three-article series “Develop and Deploy Serverless Applications with AWS SAM CLI”. If you have some idea about how to develop and test your serverless applications locally using the AWS SAM CLI, then you might proceed with this article. However, if you want to learn more about developing and running your code locally, I would strongly recommend reading the previous articles of this series, Getting started with the AWS SAM CLI and Set up a local serverless environment using the AWS SAM CLI, which explains in detail the various configurations required to start and run the serverless functions on your local.
Read more »Set up a local serverless environment using the AWS SAM CLI
August 18, 2020In this article, we are going to work on setting up your local development environment for creating serverless applications using the AWS SAM CLI. This article is a part of the three-article series “Develop and Deploy Serverless Applications with AWS SAM CLI”. If you already know about the working principle of the AWS SAM CLI, you may proceed with this; otherwise, I would highly recommend reading my previous article on the series, Getting started with the AWS SAM CLI, where I talk about the introduction to the AWS Serverless Application Model and its workflow.
Read more »Learn MySQL: Create and drop temp tables
August 18, 2020In this article, we are going to learn how to create a temp table and further drop these tables. The temporary tables are session-specific tables that are created within the session. When the session closes, the table is dropped by itself. A temporary table exists within a session only; therefore, a table created by one session is not visible to another session. For example, Session ID 501 has created a temporary table then session ID 502 cannot access it or manipulate it. Two different sessions can have a temporary table with the same name.
Read more »Getting started with the AWS SAM CLI
August 17, 2020In this article, we will learn the concept of the AWS SAM CLI. This is a part of the three-article series “Develop and Deploy Serverless Applications with AWS SAM CLI”. SAM, abbreviated for Serverless Application Model is a framework provided by Amazon Web Services, which can be leveraged to build applications on the local machine and deploy those to the AWS Lambdas directly.
Read more »Export data from AWS Redshift to AWS S3
August 14, 2020This article provides a step by step explanation of how to export data from the AWS Redshift database to AWS S3 using different export-related options.
Read more »Visual Studio Code for MySQL and MariaDB development
August 13, 2020In this article, I’ll walk you through setting up Visual Studio Code for MySQL and MariaDB development using a third-party VS Code extension and give an overview of the basic features.
Read more »Export data from MySQL tables to Azure SQL database
August 12, 2020In this article, I am going to explain how we can export the data of the on-premise MySQL database to Azure SQL database. This task can be performed in two phases.
Read more »Learn MySQL: Add data in tables using the INSERT statement
August 7, 2020In my previous article, Learn MySQL: Sorting and Filtering data in a table, we had learned about the sorting and filtering of the data using WHERE and ORDER BY clause.
Read more »Configure ODBC drivers for MySQL
August 5, 2020In this article, I am going to explain ODBC drivers. We will go through the process to set up the ODBC driver for MySQL and use it to create an SSRS report. First, let me talk about ODBC drivers.
Read more »Link an Azure Cosmos DB into a SQL Server Stored Procedure
August 3, 2020Introduction
Microsoft Azure offers hundreds of cloud products, with more on the way. In the database space, Microsoft offers Azure Cosmos DB, a NoSQL database product. We can build Java, .Net, etc. applications around Cosmos DB resources. To extend this capability, this article will show how to query Cosmos DB directly from SQL Server.
Read more »Share AWS Redshift data across accounts
August 3, 2020This article provides a step by step explanation of how to share AWS Redshift database snapshots with other AWS accounts to enable porting of data from one AWS account to another.
Read more »Managing snapshots in AWS Redshift clusters
July 31, 2020This article gives an overview of configuring AWS Redshift snapshots for scheduled data backup, data archival, as well as disaster recovery.
Read more »Getting started with Amazon S3 and Python
July 31, 2020In this article, I am going to explain what Amazon S3 is and how to connect to it using python. This article will be focused on beginners who are trying to get their hands on python and working around the AWS ecosystem. AWS, as you might know, is one of the largest cloud providers along with Microsoft Azure and Google Cloud Platform. There are a lot of services offered by Amazon including AWS S3. Amazon S3, also abbreviated as Amazon Simple Storage Service is a storage service offered by the cloud provider that enables the users to store any kind of files in this service. It is designed to make web-scale computing easier for developers.
Read more »Load data into AWS Redshift from AWS S3
July 29, 2020This article gives an overview of configuring the redshift cluster to access AWS S3 as well as loading data into AWS Redshift.
Read more »Learn MySQL: Sorting and Filtering data in a table
July 28, 2020In this article, we will learn how we can sort and filter data using the WHERE clause and sort the data using the ORDER BY clause. In my previous article, Learn MySQL: Querying data from MySQL server using the SELECT statement, we learned how to generate the ER diagram using reverse-engineering the database using MySQL workbench and basics of SELECT statement and usage. Ins this article, we will learn how we can sort and filter data using the WHERE clause and sort the data using the ORDER BY clause.
Read more »Load data from AWS S3 to AWS RDS SQL Server databases using AWS Glue
July 28, 2020This article explains how to develop ETL (Extract Transform Load) jobs using AWS Glue to load data from AWS S3 into AWS RDS SQL Server database objects.
Read more »Learn MySQL: What is pagination
July 27, 2020In this article, I am going to explain that in MySQL, what is pagination and how we can implement it. When we are populating a large dataset from the MySQL database, it is not easy to read all the records on the same page. Using pagination, we can divide the result-set into multiple pages, and that increases the readability of the result set. In this article, I am going to explain:
Read more »Learn MySQL: Querying data from MySQL server using the SELECT statement
July 27, 2020In this series of articles, we are going to learn about the basics of the MySQL database server. In this article, I am going to explain how we can query the data from the MySQFL server using the SELECT statement.
Read more »Backing up AWS RDS SQL Server databases with AWS Backup
July 21, 2020This article gives you an overview of creating backups of AWS RDS SQL Server database instances using AWS Backup service.
Read more »How to catalog AWS RDS SQL Server databases
July 21, 2020This article gives you an overview of cataloging AWS RDS SQL Server database objects like tables and views, using AWS Glue service.
Read more »How to connect AWS RDS SQL Server with AWS Glue
July 17, 2020This article gives you an overview of configuring AWS RDS SQL Server with AWS Glue service that is used in AWS for cataloging and ETL operations.
Read more »Access AWS Redshift from a locally installed IDE
July 17, 2020This article gives you an overview of configuring the AWS Redshift cluster to use it from a locally installed IDE or tools.
Read more »Getting started with AWS Redshift
July 16, 2020This article gives you an overview of AWS Redshift and describes the method of creating a Redshift Cluster step-by-step.
Read more »Launch a static website using AWS S3 buckets
July 15, 2020This article explores the AWS S3 bucket to configure a static website.
Read more »