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

Running SQL Database Maintenance Tasks Using SQLCMD

Database administration

This article is about developing an advanced understanding of the Sqlcmd utility which lets you run...
Read More

Basics of Running T-SQL Statements from Command Line using SQLCMD

T-SQL, Tools & technologies, Utilities & Extensions

This article is about developing a basic understanding of sqlcmd utility to run T-SQL commands directly from the command prompt without the...
Read More

Creating and Deploying Multiple Versions of Database through Schema Snapshots

Database administration, Database Optimization & Structure

Overview This article talks about using database schema snapshots to maintain different versions of a database to be deployed to different...
Read More

Multiple Ways to Delete Duplicates from SQL Tables

Database development, Tables

Overview This article discusses two different approaches available to remove duplicate rows from...
Read More

Using DATEADD, DATEDIFF and DATEPART T-SQL Functions in Simple Terms

Database development, Statements • 11 Comments

This article focuses on developing a basic understanding of how to use one of the most common Transact-SQL date functions: DATEADD,...
Read More

Tracking Database Changes Using Working Folder Source Control

Database development, Source control

This article talks about a new method to version control a database using a working folder so that historical changes made to the database...
Read More

Using Working Folder to Source Control Database

Database development, Source control

This article is a walkthrough of how to use the working folder option of source control for...
Read More

Simplifying Unit Testing Main Stored Procedure Which Also Calls a Utility Procedure

Database development, Stored Procedures, Testing

This article provides a walkthrough of database unit testing a stored procedure which contains a utility procedure within it. In this...
Read More

Jump to Start Test-Driven Database Development (TDDD)

Database development

As a rule, we start to develop database solutions by creating database objects, such as tables, views, stored procedures, etc., based on...
Read More

Art of Isolating Dependencies and Data in Database Unit Testing

Database administration, Database development, Testing, Work with data

All the database developers more or less write database unit tests that not only help in detecting...
Read More
Close