Representative Data Challenges
We need data that represents the problem we want to solve, or we might not achieve our aims.
2021-01-21
16 reads
Test Data
Creating Test Data
Test data is hard to come by, and I agree with Brent Ozar: " I get so frustrated when I hear trainers/presenters/bloggers/idealists talk about how developers should be using purpose-built-from-scratch data sets with no real customer data in ’em. The real world just rarely works that way." I agree, and I know this is a […]
2020-01-09
287 reads
Test data provisioning for development – free whitepaper
Compare the most common approaches to provisioning test data to database development teams and see how they stack up.
Learn why traditional approaches like restore from backup are no longer suitable, and how successful organizations are implementing a combined data masking and data virtualization approach.
2019-12-17
Take the 2019 State of Test Data Management survey – you could win a $250 Amazon voucher
We want to hear from you on the approaches you take and the challenges you face when delivering test data to development and testing environments. Take part now for an advance copy of the research and a chance to win a $250 Amazon voucher.
2019-09-27
Demo Data for Everyone
Steve thinks having a known set of data for your system is one way to improve your software development process and make salespeople happy.
2019-08-14
271 reads
Bloor scores SQL Provision 4.5 out of 5 for test data provisioning
In this independent review of SQL Provision, the Bloor analyst finds that SQL Provision’s combination of database cloning and data masking stands out with “clear advantages over competing approaches, such as data subsetting or synthetic data generation.”
2019-06-06 (first published: 2019-05-23)
Bloor 2019 Market Update on Test Data Management
Discover the latest market trends and assess your approach to test data management. For example, the Bloor analyst recognizes “…an increased emphasis on test data provisioning, as opposed to merely test data management.” The report also covers key capabilities offered by vendors in the market, including Redgate.
2019-05-30 (first published: 2019-05-16)
Managing Test Data as a Database CI Component - Part 1
Constructing a test environment for your databases can be a difficult task at the best of times. Once you’ve actually acquired the hardware needed and architected the environment, you still have to arrange and securely transport the data. And with the rising demand for fast feedback and continuously integrated processes, having all of this automated and operating at speed is a challenge all of its own.
2015-02-16
7,538 reads
Generating Test Data: Part 2 - Generating Sequential and Random Dates
Part two of this fantastic series from Jeff Moden looks at generating date data, something which can be handy for any number of testing purposes.
2012-04-25
6,072 reads
Generating SQL Server Test Data with Visual Studio 2010
As a database developer or tester sometimes you need to have production like data in your environment for your development or testing, but you cannot have the production data because of security and privacy issues. So how you can generate test data or replicate similar data as in production for your development or test environment?
2010-12-31
5,955 reads
Blogs
It’s 2021, so why are you reading this?
If you’re reading this, there’s a good chance you’re straight, white, male, and English-speaking....
Daily Coping 20 Jan 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
[Coping] Hidden Wounds
By Brian Kelley
Through high school and college, I carried deep wounds due to what was going...
Forums
Find unmatched between 2 tables using field as selection criteria
I have the following tables as a example. Table 1 EmpID, LastName, FirstName 1,Smith,John...
update using self-join - confirm it looks at old values
I'm doing an update using a self-join, and just want to confirm something. If...
Representative Data Challenges
Comments posted to this topic are about the item Representative Data Challenges
Ask SSC