data generation

How to Speed Up Populating Tables with a Large Amount of Random Data for SQL Server Performance Testing

Very often, developers and QAs need to load a large amount of test data to assess the speed of populating the database with generated data and analyze how the performance changes with the database growth.

(more…)

How to Generate Test Data with the Help of SQL Data Generator

Evgeniy Gribkov

Evgeniy is an MS SQL Server database analyst, developer, and administrator. He is involved in the development and testing of the SQL Server database management tools. Evgeniy also writes SQL Server-related articles.
Evgeniy Gribkov

In this article, we will examine the process of populating the employee database with dummy data, whose schema we designed in the previous part. Filling a SQL database with dummy data can be very useful when we want to run some tests. The most convenient way is the population of SQL tables with random data with the help of visual data generation tools.

(more…)