Search


	Podcast:		voiceofthedba's podcast
	Episode:		Having Good Data Modeling Standards
	Category:		Technology
	Duration:		00:03:43
	Publish Date:		2023-11-22 00:00:00
	Description:		While working with a customer recently, they mentioned that they have certain standards for their objects. They require a PK, and it's the name of the table with _PK added. They also have some standards, like CustomerName vs. CustomerNames for various data items. In fact, they have enough that they built a tool to scan their database code to ensure that changes to the QA and UAT environments adhere to these modeling standards. I wonder how many organizations have formal standards. While I've often tried to set some naming guidelines, I often haven't seen anything (or created anything) formal enough to build a tool around. I would like to, and I think it's a good idea, but it's often something that isn't handled in advance. Read the rest of Having Data Modeling Standards
	Total Play:		0