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 Professional SSRS Report based on Stored Procedure

Business intelligence, SSRS

This article talks about creating a professional SSRS report based on a stored procedure to meet...
Read More

How to Write Stored Procedures for Professional SSRS Reports

Business intelligence, Database development, SSRS, Stored Procedures

In this article, we’ll talk about professional SQL Server Reporting Services reports, how to create stored procedures for these reports...
Read More

Creating Customer-Focused SSRS Reports with Parameters

Business intelligence, SSRS

This article talks about how to create a basic customer-focused report using SQL Server Reporting Services (SSRS). The article also...
Read More

SSRS Reports Development in Simple Terms

Business intelligence, SSRS

The article is dedicated to the fundamentals of SQL Server Reporting Services (SSRS) development...
Read More

Learn Basic Data Analysis with SQL Window Functions

Database administration, Work with data

This article is about T-SQL (Transact-SQL) Window functions and their basic use in day-to-day data analysis tasks. There are many...
Read More

How to Properly Use the T-SQL IsNumeric Function

Languages & Coding, T-SQL

This article is focused on the T-SQL (Transact-SQL) IsNumeric function and its proper use in day-to-day SQL scripting tasks. We will also...
Read More

Basic and Complex Uses of Not Equal Comparison Operator in T-SQL

Languages & Coding, T-SQL

This article is focused on the T-SQL Not Equal comparison operator (<>) and its uses in basic...
Read More

How to Automate SQL Database Maintenance Tasks using SQLCMD

Automation, Database administration

This article is about automating SQL database maintenance tasks through SQLCMD utility which lets you run T-SQL commands directly from the...
Read More

Replacing SQL Cursors with Alternatives to Avoid Performance Issues

Database administration, Performance Tuning, Troubleshooting Issues

In this article, we’ll look at some alternatives to using SQL cursors which can help avoid performance issues caused by using...
Read More

How to use SQL Cursors for Special Purposes

Database administration, Languages & Coding, T-SQL

This article describes SQL cursors and how to use them for some special purposes. It highlights the...
Read More
Close