This article will explore the Azure alerts configuration to audit Azure SQL Database creation, modification, and deletion activities.
Read more »
Azure Automation: Automatic scaling Azure SQL databases based on CPU usage threshold
September 10, 2021This article will explore Azure automation for scaling up Azure SQL Databases based on the CPU usage threshold.
Read more »
Understanding Postgres check constraints
September 9, 2021This article covers the Postgres CHECK constraint and its usage. In this article, we are going to learn:
Read more »
SSIS Pivot transformation vs. Unpivot transformation
September 8, 2021This article explains the SSIS pivot transformation and how it differs from the unpivot transformation.
Read more »
Learn MySQL: MySQL Copy table
September 7, 2021This article explains the MySQL copy table process. In this article, you will learn how we can copy data from one table to another table. These tables could be in the same database or different databases. The MySQL copy table process can copy a specific dataset or all data from the source table to the destination table. We can use the MySQL copy table process to replicate the issues that occurred on production servers, which helps developers rectify the issues quickly.
Read more »
Auto Update SQL Server Statistics Asynchronous configuration for Azure SQL Database
September 7, 2021This article explores auto-update SQL Server Statistics asynchronous configuration for Azure SQL Database and On-premises SQL instance.
Read more »
Importing data from OData APIs using Azure Data Factory
September 6, 2021In this article, we will learn how to use Azure Data Factory to import data from OData APIs on Azure storage repositories.
Read more »
SQL Server Stored Procedure Recompilation Factors
September 6, 2021In this article, we will explore in detail the factors that cause SQL Server stored procedures to be recompiled.
Read more »
Grant, With Grant, Revoke and Deny statements in SQL Server and Azure SQL Database
September 6, 2021This article will walk you through Grant, With Grant, Revoke and Deny statements for both on-premises and Azure SQL Database.
Read more »
Implementing Slowly Changing Dimensions (SCDs) in Data Warehouses
September 3, 2021Introduction
Slowly Changing Dimensions in Data Warehouse is an important concept that is used to enable the historic aspect of data in an analytical system. As you know, the data warehouse is used to analyze historical data, it is essential to store the different states of data.
Read more »
Creating Replicas in Azure Database for PostgreSQL
September 2, 2021In this article, we will learn how to create and manage read replicas in Azure Database for PostgreSQL.
Read more »
Popular Power BI Interview Questions
September 2, 2021In this article, we are going to learn about the most popular Power BI Interview Questions being asked while applying for a Data Analyst role. Power BI is one of the most commonly used data visualization tools in the market. It is offered as a desktop tool using which you can author your reports and dashboards and then publish and share them with your users on the cloud. Power BI is also somewhat similar to Excel, so users who have prior experience with working in Excel can learn it quite easily.
Read more »
SQL Query recompilations and query performance effects
September 1, 2021This article will mention in which conditions the query optimizer decides to recompile to queries and how it affects the SQL query performance.
Read more »
6 Reasons why you can’t have DevOps without Test Automation
August 31, 2021This article explores the integration and requirements of DevOps with Test Automation.
Read more »
How to install SQL Server developer edition
August 31, 2021In this article, we are going to learn how we can install the SQL Server developer edition. We are installing the SQL Server 2017 developer edition on my workstation.
Read more »
How to install SQL Server on Linux hosted on Windows Server 2019
August 30, 2021This article explores Windows Subsystem for Linux (WSL) to run the Linux operating system on Windows OS and configure SQL Server on Linux.
Read more »
Data Flow Transformations in Azure Data Factory
August 30, 2021This article will help you get introduced to all the transformations offered in the Data Flow component of Azure Data Factory.
Read more »
Internals of Physical Join Operators (Nested Loops Join, Hash Match Join & Merge Join) in SQL Server
August 30, 2021Introduction
There are three types of physical join operators in SQL Server, namely Nested Loops Join, Hash Match Join, and Merge Join. In this article, we will be discussing how these physical join operators are working and what are the best practices for these different joins.
Read more »
Fundamentals of SQL Server Statistics
August 27, 2021In this article, we will take a glance at the fundamentals of SQL Server statistics and discover their interaction with the query processing steps with simple examples.
Read more »
Persist sampling rate for automatic SQL Server statistics updates
August 27, 2021This article explores Persist sampling rate feature for automatic SQL Server statistics update.
Read more »
Develop ETL templates for Data Warehousing using Azure Data Factory
August 26, 2021In this article, we will learn how to develop ETL templates for data warehousing using Azure Data Factory.
Read more »
Working with Python in Power BI
August 26, 2021In this article, we are going to learn about working with Python in Power BI. Power BI has been adding a lot of features to it recently and one of the most essential was adding Python functionality to it. Users are now able to run Python scripts directly from within Power BI. Python is a great programming language, especially when it comes to the field of data analysis. Most of the machine learning frameworks and data science libraries are written in Python and there is a huge community of open-source programmers that maintain and promote the use of Python along with these libraries.
Read more »
Managing the Windows Internal Database (WID)
August 25, 2021In this article, we are going to learn about the windows internal database. Microsoft windows server and their components use the Microsoft WID database to store their data. It is used to store the relational data of the following services:
Read more »
How to change an Azure SQL Database Collation
August 24, 2021This article explores the Azure SQL Database Collation configuration and how to change it while importing the database from a BACPAC file.
Read more »
Deep Dive into SQL Server Statistics
August 23, 2021In this article, we will go through some details about SQL Server statistics.
Read more »