Snippet Repositories

  • 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?

  • 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

  • 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.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
  • 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).

  • 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