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).

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...
Read More

SQL Server Business Intelligence Explained: Tools, Techniques and Trends

Business intelligence, Power BI

In this article, we are going to clarify the fundamentals of Business Intelligence (BI) concepts with their benefits from the data...
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...
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 simple structure to understand and...
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...
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 issues. Still, there are standard...
Read More

Basics of SQL Server Management Studio (SSMS). Part 2

SSMS, Tools & technologies

This article further explains the basics of SQL Server Management Studio (SSMS) – one of the most widely used database development and...
Read More

Basics of SQL Server Management Studio (SSMS) – Part 1

SSMS, Tools & technologies

This article aims to share the basics of SQL Server Management Studio, commonly known as SSMS, and...
Read More
Close