In 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 »An overview of Azure Cloud Shell
March 18, 2021This articles gives an overview of the Azure Cloud Shell.
Read more »Symptoms of Parameter Sniffing in SQL Server
March 17, 2021In this article, we will focus on how we can detect the parameter sniffing issues with different techniques.
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 »Getting started with Azure Purview for Data Catalog and Governance
March 16, 2021This article will show different features of Azure Purview as well as describe how to get started with this service on Azure.
Read more »Consuming an Azure Data Share of Azure SQL Database
March 16, 2021This article will help you understand the process to accept an incoming or received data share of Azure SQL Database and integrate it with the desired data repository to start consuming it.
Read more »Building SSAS OLAP cubes using Biml
March 16, 2021In this article, we will explain how to use the Business Intelligence Markup Language (Biml) to build SSAS OLAP cubes, noting that this article is the ninth article in the Learn Biml series.
Read more »Fuzzy joins in SQL Server Machine Learning using R scripts
March 16, 2021In this article, we will discuss the Fuzzy joins in the SQL Server Machine Learning using R scripts.
Read more »Create REST APIs in Python using Flask
March 12, 2021In this article, I am going to explain what a REST API is all about and how to get started with creating APIs in Python using Flask. In the recent software world, REST APIs play a major role as a communication channel between different services. It has become the de facto standard of passing information across multiple systems in the JSON format. This is because it has a uniform interface to share messages across two different systems. Let us learn more about REST APIs in this article.
Read more »Move local SSIS packages to Azure Data Factory
March 11, 2021In this article, we will learn how to deploy SSIS packages which are typically built on developer workstations, to Azure Data Factory using Visual Studio and Data Tools.
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 »Customizing Differential and Transaction Log backups
March 10, 2021Introduction
This article is dedicated to creating custom differential and Transaction log backups so that you will see sufficient data in the file size. In SQL Server there are mainly three backup types, Full Backup, Differential Backup, and Transactional Log backups. A Full backup will get the entire database into a backup.
Read more »Provisioning Azure SQL database using Azure PowerShell
March 10, 2021This article will show how to create an Azure SQL database using Azure PowerShell.
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 »Copy data into Azure Synapse Analytics using the COPY command
March 8, 2021In this article, we will learn how to copy data from an external data source using the COPY command into a dedicated SQL pool of Azure Synapse Analytics.
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 »Lease Timeouts and Health Checks in SQL Server Always On Availability Groups
March 8, 2021In the 42nd article for SQL Server Always On Availability Groups, we are going to explore lease timeouts and health checks.
Read more »Using Automatic Plan Correction for Query Tuning
March 4, 2021In this article, we will learn what is plan regression and how we can fix this issue with help of the Automatic Plan Correction feature.
Read more »Creating Azure Data Shares for Azure SQL Database
March 4, 2021This article will walk you through the process of creating Azure Data Shares for an Azure SQL Database.
Read more »Learn SQL: Dynamic SQL
March 3, 2021Dynamic SQL is a programming technique you can use to build SQL statements as textual strings and execute them later. This technique could prove to be useful in some cases and therefore it’s good to know we have it as an option. In today’s article, we’ll show how to create and execute dynamic SQL statements.
Read more »Restore dedicated SQL pools in Azure Synapse Analytics
March 2, 2021This article will walk you through the process of restoring dedicated SQL pools in Azure Synapse Analytics.
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 »SUBSTRING, PATINDEX and CHARINDEX string functions in SQL queries
March 1, 2021In this article, we will explore SUBSTRING, PATINDEX and CHARINDEX string functions for SQL queries.
Read more »