Get Free Tips
MSSQLTips.com

Author: Haroon Ashraf

Home » Archives for 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

TitleCategoryDate
Visual Studio Code Polyglot Notebooks vs Azure Data Studio SQL NotebooksApplication Development2025-08-27
SQL Server Management Studio Standard ReportsSQL Server Management Studio2025-05-01
Import and Export Data with SQL Server Management StudioSQL Server Management Studio2025-05-01
SQL Server Management Studio Maintenance PlanSQL Server Management Studio2025-05-01
SQL Server Management Studio Object ExplorerSQL Server Management Studio2025-05-01
SQL Server Management Studio Shortcut KeysSQL Server Management Studio2025-05-01
Using Activity Monitor in SQL Server Management StudioSQL Server Management Studio2025-05-01
Use SQL Server Management Studio to Connect to DatabaseSQL Server Management Studio2025-05-01
Working with Error Logs in SQL Server Management StudioSQL Server Management Studio2025-05-01
Working with SQL Server Agent in SQL Server Management StudioSQL Server Management Studio2025-05-01
SQL Server Management Studio Overview (SSMS)SQL Server Management Studio2025-04-27
Who Uses SQL Server Management Studio and WhySQL Server Management Studio2025-04-27
Data Masking in Power BI Strategy for Testers and UsersPower BI2022-11-07
Factless Fact Tables in a SQL Server Data WarehouseData Warehousing2022-01-17
Publish SQL Database Project without using SQL Server Data ToolsDevOps2021-05-03
Data Wrangling in SQL by Imputing Missing Values using Derived ValuesData Cleansing for Validation2021-04-13
Learn basics of Data Wrangling in SQL Server to handle Invalid ValuesData Cleansing for Validation2021-04-01
Gitflow Workflow Hotfix Branching for SQL Database ProjectsDevOps2021-01-18
Gitflow Workflow Feature Branching for SQL Database ProjectsDatabase Design2020-12-30
Branching Gitflow Workflow SQL Database ProjectsDevOps2020-12-08
Basics of Gitflow Workflow for SQL Database ProjectsDatabase Design2020-11-17
Git Branch for New Features in SQL Database ProjectDatabase Design2020-10-30
SQL Server Data Tools in Visual Studio with GIT Source ControlDatabase Design2020-10-20
Git Branch with SQL Server Database ProjectDatabase Design2020-09-29
Troubleshooting and Debugging SSIS Error Output – Part 2Integration Services Development2020-07-07
Error Handling in SSIS Data Flow Task – Part 1Integration Services Development2020-06-19
Create Custom SSIS Execution Log – Part 1Integration Services Development2020-04-27
Create Custom SSIS Execution Log – Part 2Integration Services Development2020-04-27
Download, Install and Update SQL Server Management StudioSQL Server Management Studio2020-02-05
SQL Server Management Studio Backwards CompatibilitySQL Server Management Studio2020-02-05
Git Stash SQL Server Database Code Changes using Visual Studio 2019DevOps2019-12-18
SQL Database Project Code Branching in GitDevOps2019-10-31
Automate DACPAC Creation and Setup Scripts for Database DevelopmentBackup2019-08-13
Manage Multiple Database Backup Formats with SSDTBackup2019-07-30
Creating Multiple SQL Server Database Backup Formats in SSDT – Part 1Backup2019-06-13
Azure Data Catalog Register Tabular Data Model and Data AssetsAzure2019-04-17
Azure Data Catalog Register Data Source Through Application – Part 3Azure2019-03-25
Azure Data Catalog Register Data Source – Part 2Azure2019-03-06
Azure Data Catalog Tutorial and Overview – Part 1Azure2019-02-15
Microsoft Azure Analysis Services Web Development Tools – Part 2Azure2018-12-17
Setup Tabular Model from Database or Power Pivot on Analysis ServerPower BI2018-12-11
Additional Learning for DAX in SQL ServerPower BI2018-12-11
DAX in SQL Server AddColumns to Add New Columns to Query ResultsPower BI2018-12-11
DAX in SQL Server Filter Function to Filter DataPower BI2018-12-11
DAX in SQL Server Rollup Statement to Group and Total DataPower BI2018-12-11
DAX in SQL Server Evaluate Statement to Retrieve DataPower BI2018-12-11
Install DAX Studio for SQL ServerPower BI2018-12-11
DAX in SQL Server and How it Can Be UsedPower BI2018-12-11
DAX in SQL Server Tutorial, Formulas, Functions and ExamplesPower BI2018-12-11
Microsoft Azure Analysis Services Web Development ToolsAzure2018-12-11
DAX in SQL Server Summarize Statement to Group DataPower BI2018-12-11
Adding a Primary Key to a Prepopulated Table using a SSIS PackageIntegration Services Development2018-11-19
Add Primary Key to Prepopulated Table using SQL Server Object ExplorerDatabase Design2018-10-30
Creating Tabular Model Sample from a SQL Database Sample – Part 2Analysis Services Development2018-09-12
Create Tabular Model Sample from SQL Server Database – Part 1Analysis Services Development2018-08-10
SQL Server Reference Data Best Practices – Part 2DevOps2018-07-27
SQL Server Reference Data Best Practices – Part 1DevOps2018-05-23
Adding Reference Data in Database Continuous Integration (CI) PipelineDevOps2018-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 tSQLtTesting2018-01-12
Free Database Unit-Testing for SQL Server Data ToolsTesting2017-12-15
Free Database Unit-Testing Framework for SQL ServerTesting2017-11-14

Categories

Recent Articles

  • SQL Server Transaction Log

  • 10 New Features in SQL Server 2025

  • Elevate Your ETL: Seamlessly Integrate Melissa’s SSIS Data Quality Tools with Azure Data Factory

  • Database Modernization with AI-Powered Tools

  • Optimizing SQL Server Integration: Automated Data Movement for Analytics and Operations

mssqltips white logo

MSSQLTips.com delivers SQL Server resources to solve real world problems for DBAs, Architects, DevOps Engineers, Developers, Analysts, Cloud and Business Intelligence Pros – all for free. The content we serve is all human written and based on our authors’ real-world experience. Check out tips, articles, scripts, videos, tutorials, live events and more all related to SQL Server on-premises and in the cloud.

Resources

Community

Subscribe

Be a better SQL Server Professional – Join MSSQLTips.com

Copyright (c) 2006-2025 Edgewood Solutions, LLC All rights reserved
Facebook X-twitter Rss Envelope Linkedin
Copyright (c) 2006-2025 Edgewood Solutions, LLC All rights reserved
sql server 2025 guide