Haroon Ashraf

Haroon Ashraf's deep interest in logic and reasoning at an early age of his academic career paved his path to become a data professional. He holds BSc (Gold Medal) and MSc Degrees in Computer Science and also received the OPF merit award. His programming career began in 2006 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 Business Intelligence and Database Centric Architectures and his expertise include database and reports design, development, testing, implementation and migration. He has recently earned "Knowledge Management and Big Data in Business" certificate from The Polytechnic University of Hong Kong.
  • MSSQLTips Awards: Trendsetter (25+ tips) - 2020 | Author of the Year Contender - 2018-2020
Title Category Date
Visual Studio Code Polyglot Notebooks vs Azure Data Studio SQL Notebooks Application Development2026-03-06
SQL Server Management Studio Standard Reports SQL Server Management Studio2025-05-01
Import and Export Data with SQL Server Management Studio SQL Server Management Studio2025-05-01
SQL Server Management Studio Maintenance Plan SQL Server Management Studio2025-05-01
SQL Server Management Studio Object Explorer SQL Server Management Studio2025-05-01
SQL Server Management Studio Shortcut Keys SQL Server Management Studio2025-05-01
Using Activity Monitor in SQL Server Management Studio SQL Server Management Studio2025-05-01
Use SQL Server Management Studio to Connect to Database SQL Server Management Studio2025-05-01
Working with Error Logs in SQL Server Management Studio SQL Server Management Studio2025-05-01
Working with SQL Server Agent in SQL Server Management Studio SQL Server Management Studio2025-05-01
SQL Server Management Studio Overview (SSMS) SQL Server Management Studio2025-04-27
Who Uses SQL Server Management Studio and Why SQL Server Management Studio2025-04-27
Data Masking in Power BI Strategy for Testers and Users Power BI2022-11-07
Factless Fact Tables in a SQL Server Data Warehouse Data Warehousing2022-01-17
Publish SQL Database Project without using SQL Server Data Tools DevOps2021-05-03
Data Wrangling in SQL by Imputing Missing Values using Derived Values Data Cleansing for Validation2021-04-13
Learn basics of Data Wrangling in SQL Server to handle Invalid Values Data Cleansing for Validation2021-04-01
Gitflow Workflow Hotfix Branching for SQL Database Projects DevOps2021-01-18
Gitflow Workflow Feature Branching for SQL Database Projects Database Design2020-12-30
Branching Gitflow Workflow SQL Database Projects DevOps2020-12-08
Basics of Gitflow Workflow for SQL Database Projects Database Design2020-11-17
Git Branch for New Features in SQL Database Project Database Design2020-10-30
SQL Server Data Tools in Visual Studio with GIT Source Control Database Design2020-10-20
Git Branch with SQL Server Database Project Database Design2020-09-29
Troubleshooting and Debugging SSIS Error Output – Part 2 Integration Services Development2020-07-07
Error Handling in SSIS Data Flow Task – Part 1 Integration Services Development2020-06-19
Create Custom SSIS Execution Log – Part 1 Integration Services Development2020-04-27
Create Custom SSIS Execution Log – Part 2 Integration Services Development2020-04-27
Download, Install and Update SQL Server Management Studio SQL Server Management Studio2020-02-05
SQL Server Management Studio Backwards Compatibility SQL Server Management Studio2020-02-05
Git Stash SQL Server Database Code Changes using Visual Studio 2019 DevOps2019-12-18
SQL Database Project Code Branching in Git DevOps2019-10-31
Automate DACPAC Creation and Setup Scripts for Database Development Backup2019-08-13
Manage Multiple Database Backup Formats with SSDT Backup2019-07-30
Creating Multiple SQL Server Database Backup Formats in SSDT – Part 1 Backup2019-06-13
Azure Data Catalog Register Tabular Data Model and Data Assets Azure2019-04-17
Azure Data Catalog Register Data Source Through Application – Part 3 Azure2019-03-25
Azure Data Catalog Register Data Source – Part 2 Azure2019-03-06
Azure Data Catalog Tutorial and Overview – Part 1 Azure2019-02-15
Microsoft Azure Analysis Services Web Development Tools – Part 2 Azure2018-12-17
Setup Tabular Model from Database or Power Pivot on Analysis Server Power BI2018-12-11
Additional Learning for DAX in SQL Server Power BI2018-12-11
DAX in SQL Server AddColumns to Add New Columns to Query Results Power BI2018-12-11
DAX in SQL Server Filter Function to Filter Data Power BI2018-12-11
DAX in SQL Server Rollup Statement to Group and Total Data Power BI2018-12-11
DAX in SQL Server Evaluate Statement to Retrieve Data Power BI2018-12-11
Install DAX Studio for SQL Server Power BI2018-12-11
DAX in SQL Server and How it Can Be Used Power BI2018-12-11
DAX in SQL Server Tutorial, Formulas, Functions and Examples Power BI2018-12-11
Microsoft Azure Analysis Services Web Development Tools Azure2018-12-11
DAX in SQL Server Summarize Statement to Group Data Power BI2018-12-11
Adding a Primary Key to a Prepopulated Table using a SSIS Package Integration Services Development2018-11-19
Add Primary Key to Prepopulated Table using SQL Server Object Explorer Database Design2018-10-30
Creating Tabular Model Sample from a SQL Database Sample – Part 2 Analysis Services Development2018-09-12
Create Tabular Model Sample from SQL Server Database – Part 1 Analysis Services Development2018-08-10
SQL Server Reference Data Best Practices – Part 2 DevOps2018-07-27
SQL Server Reference Data Best Practices – Part 1 DevOps2018-05-23
Adding Reference Data in Database Continuous Integration (CI) Pipeline DevOps2018-04-03
Basic Database Continuous Integration and Delivery (CI/CD) using Visual Studio Team Services (VSTS) DevOps2018-02-22
Developing Similar Structured Multi-Customer Databases with SQL Server Data Tools (SSDT) Database Administration2018-02-08
Test Driven Development with Modern Database Tools using tSQLt Testing2018-01-12
Free Database Unit-Testing for SQL Server Data Tools Testing2017-12-15
Free Database Unit-Testing Framework for SQL Server Testing2017-11-14