Aveek Das
A dataflow diagram in Power BI

An introduction to Power BI Dataflows

May 7, 2021 by

In this article, we are going to understand what the Power BI Dataflows is all about and how we can get started by building dataflows in Power BI Service. A dataflow can simply be considered as an extract transform and load pipeline that can be used to connect to source data, transform the data by applying business rules, and then finally preparing the data to be available to visualize. In a general data architecture, a dedicated ETL tool is used to prepare and transform the data, which is then loaded into a data warehouse. Power BI was used to connect to this data warehouse and visualize the data from here on.

Read more »
Aveek Das
Docker Desktop for Mac Download

How to set up and run SQL Server Docker image

April 28, 2021 by

In this article, I am going to discuss in-depth setting up docker and running a SQL Server Docker image. SQL Server, as you might already be aware that it is one of the most popular relational database technologies in today’s world. SQL Server is widely used in various applications that support transactional and analytical workloads. Docker, on the other hand, is a containerization technology using which you can bundle your applications within a container and distribute them. Docker helps users to build applications independent of the underlying operating system. We will learn more about Docker and using the SQL Server Docker image in this article.

Read more »
Aveek Das
Using the PGAdmin Management Tool

Setting up a PostgreSQL Database on Mac

April 23, 2021 by

In this article, I am going to discuss different ways in which you can install and setup Postgres Database on a Mac. Postgres is an open-source relational database system that can be used to develop a wide variety of data-based applications. Postgres has been popular for analytical workloads as well since it has support for column-store index and in-memory storage as well. Postgres is also available on all the major public cloud services like AWS, Azure, and GCP. In order to use those services, it is recommended that you should also have them installed on your local machine before deploying your databases to the cloud directly.

Read more »
Daniel Calbimonte

SQL Definition

April 21, 2021 by

Introduction

In this article, we will provide a SQL definition and we will explain what it is, and we will also talk about the SQL extensions. We will also provide some examples of SQL Syntax.

Read more »
Nisarg Upadhyay
Task execution history

Automate consistency checks of SQL database using Windows Task Scheduler

April 20, 2021 by

The SQL database integrity check is one of the most crucial and important tasks of the database administrator. The database integrity task checks the structural integrity and allocation of all database objects and indexes. The integrity checks can be performed by using the DBCC CheckDB command. The CheckDB command is used to identify the corruption in the database. The command performs the following operations on the database.

Read more »