Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Online T-SQL Scripts and Copyright


Online T-SQL Scripts and Copyright

Author
Message
bradmcgehee@hotmail.com
bradmcgehee@hotmail.com
SSC Veteran
SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)

Group: General Forum Members
Points: 268 Visits: 730
Comments posted to this topic are about the item Online T-SQL Scripts and Copyright

Brad M. McGehee
DBA
Glen Cooper
Glen Cooper
SSC-Enthusiastic
SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)

Group: General Forum Members
Points: 123 Visits: 287
This is an excellent article, and long overdue.

Is there a standard boiler-plate for this?

R Glen Cooper
James Stover
James Stover
SSC Veteran
SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)

Group: General Forum Members
Points: 293 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

Gift Peddie
Gift Peddie
Hall of Fame
Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)

Group: General Forum Members
Points: 3912 Visits: 14456
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
Rudyx - the Doctor
Rudyx - the Doctor
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3552 Visits: 2478
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."
Jack Corbett
  Jack Corbett
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12368 Visits: 14863
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
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

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
bradmcgehee@hotmail.com
bradmcgehee@hotmail.com
SSC Veteran
SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)

Group: General Forum Members
Points: 268 Visits: 730
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
bradmcgehee@hotmail.com
bradmcgehee@hotmail.com
SSC Veteran
SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)

Group: General Forum Members
Points: 268 Visits: 730
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
Dan Guzman-481633
Dan Guzman-481633
SSC-Enthusiastic
SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)

Group: General Forum Members
Points: 108 Visits: 390
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.
Adi Cohn
Adi Cohn
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2537 Visits: 6329
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/
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search