Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

How do you manage your code snippets/documentation? Expand / Collapse
Author
Message
Posted Tuesday, July 9, 2013 3:17 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 6:58 PM
Points: 431, Visits: 1,747
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

Post #1471880
Posted Tuesday, July 9, 2013 3:31 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 2:34 PM
Points: 12,923, Visits: 12,342
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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1471884
Posted Tuesday, July 9, 2013 3:50 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 6:58 PM
Points: 431, Visits: 1,747
Hi Sean,

I'd be happy to. Send it along.

Thanks

Post #1471887
Posted Wednesday, July 10, 2013 8:42 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 2:34 PM
Points: 12,923, Visits: 12,342
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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1472186
Posted Wednesday, July 10, 2013 10:49 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 1:30 PM
Points: 12,895, Visits: 32,089
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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son


  Post Attachments 
editplus.png (124 views, 129.41 KB)
Post #1472250
Posted Wednesday, July 10, 2013 11:48 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 6:58 PM
Points: 431, Visits: 1,747
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.
Post #1472270
Posted Wednesday, July 10, 2013 11:57 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 2:34 PM
Points: 12,923, Visits: 12,342
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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)


  Post Attachments 
Untitled.png (106 views, 37.24 KB)
Post #1472278
Posted Wednesday, July 10, 2013 12:04 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 1:30 PM
Points: 12,895, Visits: 32,089
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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1472284
Posted Wednesday, July 10, 2013 12:29 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 6:58 PM
Points: 431, Visits: 1,747
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.

Post #1472296
Posted Wednesday, July 10, 2013 1:03 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:38 PM
Points: 31,018, Visits: 15,453
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.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1472303
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse