Finding Legal Data
Using data scraped from the web might be convenient, but is it legal. Perhaps more importantly, is it moral? Steve has a few thoughts.
2021-04-19
85 reads
Test Data
Representative Data Challenges
We need data that represents the problem we want to solve, or we might not achieve our aims.
2021-01-21
66 reads
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
291 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
293 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,249 reads
Blogs
Career: Talk To References
By Steve Jones
As we try to get through these strange times in the world, I am...
This Saturday: #DataWeekender, DataSaturday Southwest
By Will Assaf
Geeked to be speaking 2x on Saturday May 14, my second time speaking at...
Daily Coping 14 May 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Why doesn't the Secondary failover?
Hi, I hope someone can help. I will try to summarise as best as...
How to rewrite sql query after where condition with another query ?
I work on sql server I need to rewrite statement after where statement so...
Incorrect syntax near the keyword 'AS'
Hi Everyone. I'm hoping someone can take a look at my code here to...
Ask SSC