Search


	Podcast:		voiceofthedba's podcast
	Episode:		A Good Reason to use a VCS
	Category:		Technology
	Duration:		00:03:00
	Publish Date:		2019-09-18 18:00:00
	Description:		Imagine that you have some important year end procedures in your SQL Server database. Or maybe you have some important, but rarely run code. No matter what the circumstance, if this is a large amount of code, it might be difficult to remember how it's structured or even how it works on different sets of data. Now, imagine that you have a malicious individual that thinks like Andy Mallon talks about in this post. They run an ALTER PROCEDURE and replace the entire procedure body with "RETURN 0". Now imagine that you don't find out about this until months later when the important code is run. That would be a bad day, and certainly one that might have you struggling to recover the code from backups. Do you have months of old backups? I used to, where we kept an end of month backup for a year. Read the rest of A Good Reason to use a VCS
	Total Play:		0