Articles, tutorials, videos and tools to perform software testing for database development (Oracle, MySQL, SQLServer, PostgeSQL, NoSQL, etc.)

Open Source Database Testing Tools

February 14, 2023 6

Database testing is one of the areas that might have the smaller number of open source tools. The programming languages have many xUnit tools and mocking frameworks, but this is not the case for databases. This article provides a list of open source tools that can be used to perform unit, load and security testing on several relational (MySQL, Oracle, SQLServer, etc.) and NoSQL databases.

How to Test Cloud Database Software

August 15, 2022 0

Database testing is done to check the integrity of a database by finding and fixing its vulnerabilities. Without this process, the system might become unstable. Some or all of the stored information in the Cloud database may be rendered useless or worse, might become accessible by unauthorized personnel.

How to Write Good Test Cases for Database Testing: 4 Key Tips

June 13, 2022 0

When developing software, you will need to write test cases to help ensure that your code is working as expected. Writing good database testing scenarios can go a long way toward improving your application’s reliability and making it easier to maintain in the future.

Best Practices for SQL Server Configuration Tuning and Improving Performance

December 1, 2021 0

If a SQL server is the bedrock of your app or service, then its performance will be a big part in determining the responsiveness and fluidity of the end-user experience. As such, it is only by monitoring database performance from moment to moment and tracking usage trends over time that you can optimize it successfully.

Big Data: How to Test the Elephant?

May 27, 2014 0

Big Data is a big topic in software development today. When it comes to practice, software testers may not yet fully understand what is exactly Big Data. A tester knows that you need a plan for testing it. Since most Big Data lacks a traditional structure, how does Big Data quality look like? And what the are most appropriate software testing tools? This article tries to answer these questions.

Testing Database Migration: Black Box or White Box?

March 31, 2014 2

Creating an effective data migration testing strategy is critical to reducing risk and delivering a successful migration. This article offers thoughts and recommendations on how to create a more consistent data migration testing methodology using either a black box or a white box approach.

SQL Server Unit Testing

February 25, 2013 0

The SQL Server unit tests feature have been added in the December 2012 update of SQL Server Data Tools (SSDT). This article presents a detailed information on how to create an run unit tests in SQL Server.

1 2