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 123»»»

Online T-SQL Scripts and Copyright Expand / Collapse
Author
Message
Posted Saturday, April 18, 2009 12:39 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 16, 2014 10:06 AM
Points: 176, Visits: 728
Comments posted to this topic are about the item Online T-SQL Scripts and Copyright

Brad M. McGehee
DBA
Post #700079
Posted Saturday, April 18, 2009 3:38 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, December 5, 2014 4:04 PM
Points: 52, Visits: 266
This is an excellent article, and long overdue.

Is there a standard boiler-plate for this?


R Glen Cooper
Post #700106
Posted Saturday, April 18, 2009 5:17 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, September 8, 2013 5:39 PM
Points: 263, Visits: 862
What's a bit sad is that "borrowing" T-SQL or any other online resource is that it doesn't really help us learn better. Should job requirements say: "Must know how to Google T-SQL"? It's like the commercial imperative to do more with less and do it faster is breeding a generation of lazy (and unqualified, dare I say) IT pros.

But I digress off topic. In terms of copyright, my opinion is that regardless of what the law says if you nakedly put anything in the Cloud then you can expect someone to use it without your permission. It's like leaving your car running with windows down and doors unlocked in front of the 7-11. There's a good chance someone is going to steal your car. One can ponder the legalities of that as one walks home



James Stover, McDBA
Post #700118
Posted Saturday, April 18, 2009 5:42 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, November 13, 2014 2:52 PM
Points: 3,428, Visits: 14,451
I will only have problem if Microsoft is not providing code samples because if you know what you are doing you could modify their code for most needs. I have seen Microsoft code in developer articles in MSDN magazines without credits and in their custom component vendor sample code.

I used the US government copy of ANSI SQL online pre Google days to study so I have problem with most copy right issues because most SQL is implmentation of ANSI SQL and vendor add on. Yes there are admin scripts but you could also get the same with Embarcadero so there is alternative. I don't go to sites with many of these rules it complicates simple issues from modified Microsoft code. Code is about 30 percent of software so maybe my design skills is the reason I have not needed most over complicated code.


Kind regards,
Gift Peddie
Post #700124
Posted Saturday, April 18, 2009 8:38 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 3:44 PM
Points: 3,221, Visits: 2,375
Good article ... one for the lawyers and intellectual property folks for sure.

However, just think about how ludicrous it can be.

How many DBAs have freely copied and implemented the scripts from BOL ... lots of scripts from v6.0 to the present. Imagine the legal morass that already exists in that fact alone. Just think about it. Even on BOL now you even have a 'copy code' button just about everywhere !

Then there is the situation where mny have even been given scripts from MS PSS as workarounds !

Just think, in addition to MS/SQL Server, Sybase, Oracle and DB2 and probably countless other DBMSs have also put their respective client/user communities in the same risk situation. That is why I initially mentioned that it is a bit 'ludicrous'.

Maybe we should run this past the legal folks !!!




Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
Post #700145
Posted Saturday, April 18, 2009 8:44 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:26 AM
Points: 10,381, Visits: 13,436
I'd never considered copyright issues when googling code, getting scripts from sites like SSC or blogs, or posting code to SSC, on my blog, or to the SQL Server Code Repository set up on LIve Mesh by Jamie Thompson. I just assumed anyone could figure out the code I provided given the time.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

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
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #700146
Posted Saturday, April 18, 2009 8:56 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 16, 2014 10:06 AM
Points: 176, Visits: 728
Glen Cooper (4/18/2009)
This is an excellent article, and long overdue.

Is there a standard boiler-plate for this?


The http://www.fsf.org/ website has standard boiler-plate text for offering the code free to the public.


Brad M. McGehee
DBA
Post #700147
Posted Saturday, April 18, 2009 9:02 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 16, 2014 10:06 AM
Points: 176, Visits: 728
rudy komacsar (4/18/2009)
Good article ... one for the lawyers and intellectual property folks for sure.

However, just think about how ludicrous it can be.

How many DBAs have freely copied and implemented the scripts from BOL ... lots of scripts from v6.0 to the present. Imagine the legal morass that already exists in that fact alone. Just think about it. Even on BOL now you even have a 'copy code' button just about everywhere !

Then there is the situation where mny have even been given scripts from MS PSS as workarounds !

Just think, in addition to MS/SQL Server, Sybase, Oracle and DB2 and probably countless other DBMSs have also put their respective client/user communities in the same risk situation. That is why I initially mentioned that it is a bit 'ludicrous'.

Maybe we should run this past the legal folks !!!


Microsoft does give a LIMITED PUBLIC LICENSE for their sample code. See: http://msdn.microsoft.com/en-us/cc300389.aspx.


Brad M. McGehee
DBA
Post #700148
Posted Sunday, April 19, 2009 7:05 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, December 9, 2014 6:13 PM
Points: 59, Visits: 312
Good editorial, Brad. We often forget that T-SQL scripts are protected just like any other source code.

I want to add that Codeplex projects include a license that take the guesswork out of copyright protection. Project coordinators can choose from several existing open source licenses or create a custom one. This is one reason why Codeplex is such a great place to share and use free code.
Post #700195
Posted Sunday, April 19, 2009 7:52 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, December 1, 2014 7:30 AM
Points: 2,128, Visits: 5,565
I don’t think that writing SQL Code should be protected by copyright laws. There is a very big difference between writing a novel or creating a movie and writing T-SQL. It would be ridiculous if one day we’ll find out that we can’t use sys.dm_db_index_physical_stats to check fragmentation because someone wrote a script that used it and decided to copyright it. On the other hand writing my own story about Harry Potter is defiantly a violation of copyright laws. If I decide to write a story there are endless subjects to write about. If I decide on a subject there are endless ways to write about it, but when I write T-SQL script there are limited numbers of logical ways to do it.

Adi


--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #700203
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse