In this article, we will learn how to ingest data into Azure Synapse Analytics with a focus on using PolyBase to load the data.
Read more »Technologies
An introduction to AWS Athena
March 19, 2021In this article, I am going to introduce AWS Athena, a service offered by Amazon which allows users to query data from S3 using standard SQL syntax. AWS is considered to be a leader in the cloud computing world. Almost more than a hundred services are being offered by Amazon which offers competitive performance and cost-effective solutions to run workloads as compared to on-premise architectures. The services offered by Amazon range widely from compute, storage, databases, analytics, IoT, security, and a lot more. One of the popular areas of these services in the Analytics domain. This allows the customer to build architectures that answer key questions to their business decisions.
Read more »MySQL Recursive Queries
March 18, 2021Introduction
As we lever MySQL to build database solutions, we might need to build a MySQL recursive query. In an earlier Database Journal article, I showed how to solve an integer parsing problem with SQL Server recursion. This article will show how to solve that same problem with MySQL recursion, highlighting the strong and weak points of this MySQL feature.
Read more »Learn MySQL: MySQL String Functions
March 17, 2021In this article, we are going to learn about different MySQL String functions. The MySQL String functions can be categorized into the following:
Read more »Learn MySQL: Run multiple instances of MySQL Server on Windows 10
March 11, 2021This article explains how we can run multiple instances of the MySQL Server on a single machine. In How to install MySQL database server 8.0.19 on Windows 10 article, I have explained the installation process of MySQL on windows 10. For the demonstration, I have installed MySQL 8.0.19 on my workstation. We can view the status of the MySQL Server using MySQL workbench. To view the server status, open MySQL workbench connect to the MySQL instance Click on Server Select Server Status.
Read more »Migrating SQL Server graph databases to Neo4j
March 9, 2021This article provides a step-by-step guide for migrating SQL Server graph databases to Neo4j using C#.
Read more »Overview of EC2 Instance Types in AWS
March 8, 2021In this article, I am going to talk about the various EC2 instance types available in AWS. EC2, abbreviated as Elastic Compute Cloud is an IaaS offering from AWS using which customers can provision virtual machines on the cloud using different combinations of CPU, RAM, disk and networking. There are many predefined instance types already available in the AWS console, which makes it extremely easy to spin up a new EC2 instance very easily.
Read more »Learn MySQL: An overview of the mysqlbinlog utility
March 2, 2021The mysqlbinlog utility is used to process the binary logs of the MySQL server. Using mysqlbinlog utility, we can perform the following tasks:
Read more »Preparing for the AWS Certified Cloud Practitioner (CCP) exam
March 1, 2021In this article, I am going to discuss the AWS Certified Cloud Practitioner exam. Cloud Computing is one of the most fast-moving technologies in today’s world. With the rising demand for cloud computing platforms, more and more companies have already started using the cloud or are in the process of moving their infrastructure to the cloud. When the question of cloud vendors comes in, AWS is mostly preferred by major companies, also Azure is on the second list after AWS. With this demand, companies also continuously look for talented individuals who can help them lift and shift their infrastructure all already advise them with their existing cloud infrastructure.
Read more »Move SQL database files in SQL Server 2019 on Linux
February 26, 2021In this article, I am going to explain how we can move the SQL database files to another location in Ubuntu 18.04. For the demonstration, I have installed Ubuntu 18.04, SQL Server 2019 on Linux on my workstation. You can read SQL Server 2019 on Linux with Ubuntu to understand the step-by-step installation process of the SQL Server 2019 on Linux. We will move database files of AdventureWorks2019 and Wideworldimportors database. To move the databases, we can use any of the following methods:
Read more »Analyzing data hosted in Azure Cosmos DB with Notebooks
February 10, 2021In this article, we will learn how to analyze data hosted in Azure Cosmos DB using Notebooks.
Read more »Learn MySQL: An overview of MySQL Binary Logs
February 9, 2021In this article, we are going to learn about the concept of MySQL Binary Logs and their architecture. I am covering the following details in this article:
- An overview of MySQL binary logs and their architecture
- How to enable and disable binary logging
- View and change the location of the binary logs
Getting started with Azure Cosmos DB Serverless
February 8, 2021In this article, we will learn how to create a serverless instance of Azure Cosmos DB as well as understand its applicability in use-cases.
Read more »Getting started with the Neo4j graph database
February 5, 2021In this article, we will talk briefly about graph databases and what Neo4j is. Then we will give a step-by-step guide on how to install and get started with Neo4j on Windows operating system.
Read more »Understanding AWS Billing services and concepts
February 3, 2021In this article, I am going to explain AWS Billing services and the underlying concepts that one should be aware of while working with AWS. As you know, more and more companies are taking the essential step to migrate their existing applications to the cloud, it has become important for engineers to keep up the pace and learn the technologies of the cloud. In today’s market, AWS and Azure are two of the major cloud providers which are being used mostly. Also, Google Cloud Platform (GCP) is becoming popular, however, the demand for AWS is the highest.
Read more »Learn MySQL: The Basics of MySQL Views
February 3, 2021In this article, we are going to learn about the fundamentals of MySQL Views. In this article, I am going to cover the following topics:
Read more »Performing minor and major version upgrades for AWS RDS SQL Server
January 29, 2021Usually, database administrators upgrade the SQL Server versions for on-premise infrastructure. The AWS cloud infrastructure for SQL Server supports two flavors for database deployments.
- SQL Server deployed on the AWS EC2 instance
- An AWS managed instance relational database service
Deploying AWS RDS PostgreSQL instances
January 27, 2021In this article, we will look at the configuration of the AWS RDS PostgreSQL instances.
Read more »An overview of AWS Well-Architected Principles
January 27, 2021In this article, I am going to explain about the AWS Well-Architected Framework that helps AWS customers to design solutions following best practices while designing the architectures of their solutions. It enables the users to design secure, reliable and high performant cloud applications and workloads. This is more of a theoretical concept that is often advised to be followed while thinking of the architecture of any system. There are five pillars of the AWS Well-Architected Framework that enables customers to evaluate their existing architectures and implement scalable solutions. In this article, we will learn more about those five pillars and the best practices around them. The discussion below is a summarized form of the official whitepaper: AWS Well-Architected Framework.
Read more »Migrating your on-premises SQL databases to AWS RDS SQL Server using AWS DMS
January 25, 2021There 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 »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 »An overview of AWS IAM
January 13, 2021In this article, I am going to introduce the concept of AWS IAM, also known as Identity and Access Management in AWS. In any cloud service, controlling who has access to the services and how each of the services accesses the other services is an important task. If we do not control the access or restrict then there might be cases of a security breach within the services and we might not be able to track those as well. So as a best practice to restrict or control access within the AWS, there is a special service called IAM that can be used to manage and control almost everything in AWS. It is the permission control system that controls access to the various AWS resources and services.
Read more »Power BI: Importing data from SQL Server and MySQL
January 12, 2021Microsoft Power BI is a data analytics and visualization tool that can be used to visualize data in the form of different types of reports, without writing a single line of code.
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 »