Author: Haroon Ashraf

Haroon's deep interest in logic and reasoning at an early age of his academic career paved his path to become a data professional. He began his professional life as a computer programmer more than 10 years ago working on his first data venture to migrate and rewrite a public sector database driven examination system from IBM AS400 (DB2) to SQL Server 2000 using VB 6.0 and Classic ASP along with developing reports and archiving many years of data. His work and interest revolves around Database-Centric Architectures and his expertise include database and reports design, development, testing, implementation and migration along with Database Life Cycle Management (DLM).

Create and Use Custom Date Hierarchies in Power BI

Microsoft Power BI

Why are custom hierarchies Date tables essential for analysis and reporting? Let’s explore this...
Read More

Creating the Date Table in Power BI Desktop Using DAX Function

Business intelligence, Power BI

The time intelligence functions for the data models or databases running behind a Power BI report are really helpful. To make the most use...
Read More

SQL Server Business Intelligence (BI) – Traditional Tools and Technologies

Business intelligence, Power BI, Tools & technologies

If Business Intelligence (BI) is in your focus, you need two things to be a success. They are the knowledge and tools. If you target the...
Read More

SQL Server Business Intelligence (BI) – Basic Understanding

Business intelligence, Power BI

In this article, we are going to clarify the fundamentals of Business Intelligence (BI) concepts...
Read More

How to Use Multicast in SSIS with Examples

Business intelligence, SSIS

This article explains how to configure the job of multicasting data with the help of SSIS (SQL Server Integration Services) Packages. Also,...
Read More

Multicast SSIS: How to Create, Setup and Test

Business intelligence, SSIS

The current article focuses on setting up and testing the necessary environment for multicasting data with SQL Server Integration Services...
Read More

SQL Reference Table: How to Create and Write Basic Queries

Database development, Statements, Tables

This article will focus on writing SQL queries against the database reference table with a fairly...
Read More

SQL Basic Commands: How to Write Simple Queries with Examples

Database development, Statements

This article explains writing simple SQL queries from the most basic ones and gradually improving the script to solve some mathematical and...
Read More

SQL Server DELETE – Removing One or More Rows from a Table with Slightly Advanced Scenarios

Database development, Statements, Tables, Work with data

The current article focuses on slightly advanced use of the DELETE statement to remove one or more records (rows) from a table. While it...
Read More

SQL Server Delete Statement: How to Remove One or Multiply Rows from the Table

Database development, Statements, Tables

The right application of the DELETE statement for data removal is crucial, and it involves lots of...
Read More
Close