How do you manage your code snippets/documentation?

Question

How do you manage your code snippets/documentation?

sqldriver

SSChampion

Points: 10440
More actions
July 9, 2013 at 3:17 pm

#74756

The .sql file that I started using to store interesting bits of code, things I wanted to play with, general interest, etc., is growing rather large and unwieldy. I'm trying to find a solution to break out and manage/document things. My company has a Wiki, but companies aren't forever. I would like it to be sort of private, preferably free, and, you know, internetted.
I guess GitHub is the obvious choice for a lot of people, but I've never used it.
Thanks

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Sean Lange SSC Guru Points: 286573 More actions · Answer 1

erikd (7/9/2013)
The .sql file that I started using to store interesting bits of code, things I wanted to play with, general interest, etc., is growing rather large and unwieldy. I'm trying to find a solution to break out and manage/document things. My company has a Wiki, but companies aren't forever. I would like it to be sort of private, preferably free, and, you know, internetted.
I guess GitHub is the obvious choice for a lot of people, but I've never used it.
Thanks

Interesting you should ask...I have used a program called CodeBox for several years. However, I have only the demo version and have outgrown the demo size. Interestingly when I clicked on the website link in the program a few months ago I was taken to a site that is...well...not exactly HR friendly. Needless to say, the company has obviously gone the way of the dodo bird. Just a couple weeks ago I was thinking I need to get back to my own implementation and I am very nearly complete with an asp.net version. This is still the first draft but I have everything finished but the Delete function. I would be happy to send it your way if you would be willing to offer some feedback.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

sqldriver SSChampion Points: 10440 More actions · Answer 2

sqldriver

SSChampion

Points: 10440

July 9, 2013 at 3:50 pm

#1631014

Hi Sean,

I'd be happy to. Send it along.

Thanks

Sean Lange SSC Guru Points: 286573 More actions · Answer 3

Give me a couple days to get it all cleaned up and I will send it along.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Lowell SSC Guru Points: 323504 More actions · Answer 4

i'll throw my two cents in;

I use a combination of saved scripts in a specific folder(lazily using C:\Users\<username>\Documents\SQL Server Management Studio\Projects, and that folder has subfolders and hundreds, probably thousands of files.

for shorter snippets, i use the cliptext feature of editplus, which is a syntax highlighting text editor. it has a boatload of nice features,a nd helps me edit all types of text files, and really powerful macro features.

it has a nice feature where i can give something a short description, and double clicking that description pastes the codeblock associated into the current text document.

it supports multiple groups of snippets, so i have them grouped for every version of SQL(ie sql2005/08/2012.

I grab any interesting snippet form the forums here, and save them constantly; i shudder to think how many snippets i have actually saved over the years. I've never tripped over a size limit for the collection, but have found it sometimes replaced the carat symbol^ that exists in my snippets from version2 to version3 during an upgrade

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

sqldriver SSChampion Points: 10440 More actions · Answer 5

Thanks, Lowell. Is your library at all portable? I find myself working from several computers, and several more term servers, so it's helpful for me to be able to access my bits and pieces from multiple places. Right now it's a shortcut to a file on DB. Which is part of why things are turning unwieldy.

Sean Lange SSC Guru Points: 286573 More actions · Answer 6

Here is a screen shot of what I have been working on.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Lowell SSC Guru Points: 323504 More actions · Answer 7

erikd (7/10/2013)
Thanks, Lowell. Is your library at all portable? I find myself working from several computers, and several more term servers, so it's helpful for me to be able to access my bits and pieces from multiple places. Right now it's a shortcut to a file on DB. Which is part of why things are turning unwieldy.

EditPlus2 is portable, and just comes up with a nag screen on startup about registering(you are on Day 439 of 30 day trial period). That's what i keep on my PortableApps drive.

EditPlus3 quits after a defined testing period, and so it's not portable...but the files (ie SQL2012.ctl) are the exact same format, so a quick robocopy when i need to capture new snippits works fine.

I can throw you my PortableApps folder for it if you think it's worthwhile.

Also, for portable apps, Linqpad is my goTo for a SSMS replacement when it's not installed and I'm doing consulting, or otherwise don't have access to SSMS:

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

sqldriver SSChampion Points: 10440 More actions · Answer 8

Sean, that looks awesome.

Lowell, if you mean the folder full of all your wisely written code that a scrub could learn from, then yes. Otherwise, I can probably set something similar up when I get a chance to mess with it.

Steve Jones - SSC Editor SSC Guru Points: 734418 More actions · Answer 9

Didn't know EditPlus did that, though I use that for lots of stuff.

I have started using GitHub for keeping code sync'd between machines. Like that for now.

Tee Time Hall of Fame Points: 3745 More actions · Answer 10

Thanks Lowell, I'm going to give LINQPad a try. 🙂

Ed Wagner SSC Guru Points: 287024 More actions · Answer 11

Sean - If you're willing to share and would d like another beta tester, please add my name to the list. I'd love you see what you've come up with.

I also keep my scripts on my hard drive and also write SQL templates for use in SSMS for some things when I have the time. I know keeping things on a local hard drive is not good disaster planning, but I back it up...occasionally...okay, very occasionally. 😀 I've been thinking of writing a client to manage all this, but simply haven't gotten to it yet.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions