Search


	Podcast:		voiceofthedba's podcast
	Episode:		Virtual Data
	Category:		Technology
	Duration:		00:03:07
	Publish Date:		2018-02-19 20:00:00
	Description:		Yesterday I republished an editorial from 2014 for the holiday. The topic was production subsets of data, which has been something that many data professionals have struggled with for years. Many of us have built scripts to delete, change, obfuscate, or alter production restores as a way of providing useful, but manageable development database sets. Or maybe it's just some of us. I'm sure more than a few of us have given up on this task and just restored production databases in entirety to test and development systems. I changed over my career to become a fan of additively building a known dataset rather than deleting extra data. I advocate adding rows from production (properly masked/obfuscated) and maintaining this set over time as requirements change. However, this isn't without it's own administrative headaches. I think it's easier, but this does require commitment from everyone to keep going over time. It's certainly better than each developer adding their own 10 rows of data to a table for testing. Read the rest of Virtual Data
	Total Play:		0