March 6, 2014 at 2:32 am
Hello
Now and again, I would spot someone saying they pulled a code response they gave a poster from their "toolbox".
Can I ask what people are generally using to store these snippets? Maybe an online code repository,
homegrown or even a windows application?
This is especially so if you have a solution that works with you able to keep your snippets up to date at work, home or anywhere else?
March 6, 2014 at 2:36 am
I have a few common SQL scripts at my laptop (creating a date dimension for example). If it is really useful, I tend to blog about it, so that I have an online copy
But most of the time I google it, find a query that I like and adapt it to my needs.
Some people are more organized though, and use Github.
First release of my own personal T-SQL Code Library on github
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 6, 2014 at 5:15 am
I have a folder on my diskdrive where I store all my (larger) scripts. When I'm working in a team I put these scripts on a network share so all my colleagues can use them.
The number of scripts is getting more and more over the years and at some point it gets difficult to remember what each script can be used for. Of course there are some scripts you use regularly, but especially the scripts you use only once or twice a year will slip your mind. I'm trying to keep the name of the file as descriptive as possible. Besides I use "Elyse" file manager http://silkwoodsoftware.com/index.html to tag my scripts.
March 6, 2014 at 5:19 am
I am old school. I have a folder that I keep code in. If I need to find something and cannot remember which sub folder, I do a search (Agent Ransack).
March 10, 2014 at 5:24 am
Thanks for all the responses.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy