So this is not a technical one, forgive me in advance if it's not the right place...
I've recently began to write many SQL scripts, I have previous SQL skills, but was never in a position where this was my main agenda, and my scripts count grow every day.
I can't figure out the best way to organize all my scripts because some are tests / production / dev / procedures etc, which made me wonder if there are any tools or practices which can help and assist in this stage, because right now I'm in a bit of a mess.
Thanks in advance for any answers or comments.