Testing Archives - {coding}Sight

How AI Will Change Software Development and Testing

Erik Fogg — Tue, 12 Jan 2021 16:24:40 +0000

Artificial intelligence is the fuel for what we know as the fifth industrial revolution. Its capacities to impact and disrupt numerous industries are virtually unparalleled. It is no less true regarding software development and testing. While self-writing code is not yet a broadly commercialized technology, automation is more prevalent in writing and testing software. This …

The post How AI Will Change Software Development and Testing appeared first on {coding}Sight.

Automate Database Test Restore in SQL Server

Haroon Ashraf — Mon, 30 Sep 2019 22:57:22 +0000

This article talks about automating the database restoration process which is often done manually by the DBA or the infrastructure team responsible for the management of database server(s) and database(s). This article also highlights the importance of automating database administration tasks such as database backup and restoration to ensure that consistency and reliability of production …

The post Automate Database Test Restore in SQL Server appeared first on {coding}Sight.

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

Haroon Ashraf — Fri, 02 Nov 2018 13:17:19 +0000

This article provides a walkthrough of database unit testing a stored procedure which contains a utility procedure within it. In this article, I am going to discuss a database unit testing scenario when a main stored procedure depends on a utility procedure and the main procedure needs to be unit tested in order to make …

The post Simplifying Unit Testing Main Stored Procedure Which Also Calls a Utility Procedure appeared first on {coding}Sight.

Art of Isolating Dependencies and Data in Database Unit Testing

Haroon Ashraf — Fri, 27 Apr 2018 12:29:38 +0000

All the database developers more or less write database unit tests that not only help in detecting bugs early but also save a lot of time and efforts when the unexpected behavior of database objects becomes a production issue. Nowadays, there are a number of database unit testing frameworks such as tSQLt along with third-party …

The post Art of Isolating Dependencies and Data in Database Unit Testing appeared first on {coding}Sight.

Rules for Implementing TDD in Old Project

Aleksandr Goida — Fri, 18 Aug 2017 11:28:34 +0000

The article “Sliding Responsibility of the Repository Pattern” raised several questions, which are very difficult to answer. Do we need a repository if the complete disregard of technical details is impossible? How complex must the repository be so that its addition can be regarded worth-while? The answer to these questions varies depending on the emphasis placed in …

The post Rules for Implementing TDD in Old Project appeared first on {coding}Sight.

Why Using Unit Tests is a Great Investment into High-Quality Architecture

Rustem Musairov — Tue, 13 Jun 2017 06:07:18 +0000

I have decided to write this article in order to show that unit tests are not only a tool to grapple with regression in the code but is also a great investment into a high-quality architecture. In addition, a topic in the English .NET community motivated me to do this. The author of the article …

The post Why Using Unit Tests is a Great Investment into High-Quality Architecture appeared first on {coding}Sight.