Online T-SQL Scripts and Copyright

Question

Online T-SQL Scripts and Copyright

Viewing 6 posts - 46 through 50 (of 50 total)

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

Robert Sterbal SSChampion Points: 11048 More actions · Answer 1

Eric M Russell (11/30/2016)
...I would consider published source code to be similar in concept to a cooking recipe. Someone, possibly a skilled professional, put effort into developing the perfect pumpkin pie, but if they publish step-by-step instructions on the web, they should expect folks will use it as is or in a modified form. It's just that when receiving compliments, I should give credit to the author and not pretend as if it were my own creation.

Here is a good discussion of recipes and copyright law:

http://opensourcecook.com/recipes-copyright-law

(I'm republishing the book: https://cookbooks.leannebrown.com/good-and-cheap.pdf as a set of wiki pages: https://sterbalfamilyrecipes.miraheze.org/wiki/Category:Good_and_Cheap_Recipes)

I needed permission to post the images, not the ingredients list and directions.

412-977-3526 call/text

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 2

robert.sterbal 56890 (11/30/2016)
Here is a good discussion of recipes and copyright law:
http://opensourcecook.com/recipes-copyright-law
(I'm republishing the book: https://cookbooks.leannebrown.com/good-and-cheap.pdf as a set of wiki pages: https://sterbalfamilyrecipes.miraheze.org/wiki/Category:Good_and_Cheap_Recipes)
I needed permission to post the images, not the ingredients list and directions.

sorry..I am a bit confused with your recent posts on this site...what issue are you asking for clarification on?

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

Gary Varga SSC Guru Points: 82166 More actions · Answer 3

Some people copyright their articles/blog posts but explicitly specify that the code is free to use. This is a reasonable case where the author is trying to educate but attempting to stop the shameless people who copy such an article and post it as their own.

I think that the law in a lot of countries require a reasonable level of creativity and/or uniqueness before copyright can apply i.e. Eric's GetDate script is not a valid copyright case (sorry Eric). Otherwise I would be able to build upon Eric's work and produce my own (albeit with some use of Eric's):

SELECT GETDATE();

That semicolon makes all the difference!!! 😉

Amongst other reasons to copyright your own work is to stop another party copyrighting it and them stopping you from using it. A despicable act but one that has occurred more than once.

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!

Jack Corbett SSC Guru Points: 184393 More actions · Answer 4

Gary Varga (12/5/2016)
Some people copyright their articles/blog posts but explicitly specify that the code is free to use. This is a reasonable case where the author is trying to educate but attempting to stop the shameless people who copy such an article and post it as their own.
I think that the law in a lot of countries require a reasonable level of creativity and/or uniqueness before copyright can apply i.e. Eric's GetDate script is not a valid copyright case (sorry Eric). Otherwise I would be able to build upon Eric's work and produce my own (albeit with some use of Eric's):
-- (c)2016 Shonkey Gaz - All Rights Reserved
-- Portions (c)2016 Eric Russell.
SELECT GETDATE();
That semicolon makes all the difference!!! 😉
Amongst other reasons to copyright your own work is to stop another party copyrighting it and them stopping you from using it. A despicable act but one that has occurred more than once.

And here I thought Eric was tyring to copywrite the Byte Me! and the GETDATE() was just getting the date of the copyright!:w00t:

Byte me!
-- (c)2016 Eric Russell - All Rights Reserved
SELECT GETDATE()

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Gary Varga SSC Guru Points: 82166 More actions · Answer 5

Maybe he was. :laugh:

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!

Robert Sterbal SSChampion Points: 11048 More actions · Answer 6

The vast majority of the scripts published here do not contain a copyright notice. That means any time I want to use a script I need to reach out to the page author for permission.

Does anyone else do this more than 5 times a year? (just to give it a specific metric)

412-977-3526 call/text