This article talks about basic concepts of SQL unit testing from a Data Warehouse point of view using tSQLt, a highly productive and acclaimed SQL unit testing framework.
Read more »
Haroon Ashraf
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 holds BSc and MSc Degrees in Computer Science and also received the OPF merit award.
He began his professional life as a computer programmer more than a decade 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).
He has also received passing grade to earn DevOps for Databases verified certificate, an area in which he finds particular interest and potential.
View all posts by Haroon Ashraf
He holds BSc and MSc Degrees in Computer Science and also received the OPF merit award.
He began his professional life as a computer programmer more than a decade 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).
He has also received passing grade to earn DevOps for Databases verified certificate, an area in which he finds particular interest and potential.
View all posts by Haroon Ashraf
Latest posts by Haroon Ashraf (see all)
- SQL Unit Testing Data Warehouse Extracts with tSQLt - January 7, 2020
- Creating SQL Unit Testing Utility Procedures with tSQLt - September 10, 2019
- Three Standard SQL Unit Tests you can write against any Stored Procedure - June 14, 2019
Creating SQL Unit Testing Utility Procedures with tSQLt
September 10, 2019This article gives hands-on experience of writing basic utility procedures and creating their SQL unit tests using tSQLt an advanced SQL unit testing framework.
Read more »
Three Standard SQL Unit Tests you can write against any Stored Procedure
June 14, 2019This article talks about the three standard SQL unit tests which can be written against any stored procedure ultimately becoming SQL unit testing object to meet internal or external business specification.
Why you should cleverly name Database Objects for SQL Unit Testing
May 29, 2019This article is focussed on clever database object naming from both development and SQL unit testing point of view.
This article also highlights the importance of naming database objects going through different development transitions including the SQL unit testing phase due to the agile nature of requirements.
Read more »
10 Most Common SQL Unit Testing Mistakes
May 7, 2019This SQL unit testing article is based on the fact that we often learn from the mistakes so the idea is to highlight the mistakes to understand them clearly so that they can be avoided straight away.
Read more »
Fundamentals of Test-Driven Database Development (TDDD) with tSQLt unit testing
April 19, 2019This article talks about core concepts of test-driven database development followed by creating simple SQL unit tests with tSQLt based on this approach.
Read more »
Conventional SQL Unit Testing with tSQLt in Simple Words
March 28, 2019This article is about basics of conventional SQL unit testing concepts and its implementation through tSQLt, a highly acclaimed SQL unit testing framework because of being written in T-SQL and its built-in design support for SQL SQL unit testing needs ranging from simple to complex scenarios.
tSQLt – A Forgotten Treasure in Database Unit Testing
March 12, 2019This article is an overview of tSQLt, which is one of the best SQL unit testing frameworks, due to number of reasons, including the ease of writing unit tests in the same language (T-SQL) in which the database objects themselves are written.
Read more »