<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQLServerCentral.com
»
Editorials
»
Online T-SQL Scripts and Copyright
20 posts, Page 1 of 2
1
2
»»
Online T-SQL Scripts and Copyright
Rate Topic
Display Mode
Topic Options
Author
Message
Brad M. McGehee
Brad M. McGehee
Posted Saturday, April 18, 2009 12:39 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Monday, March 15, 2010 12:54 PM
Points: 130,
Visits: 402
Comments posted to this topic are about the item
Online T-SQL Scripts and Copyright
Brad M. McGehee
Microsoft SQL Server MVP
Director of DBA Education, Red Gate Software
www.bradmcgehee.com
Post #700079
Glen Cooper
Glen Cooper
Posted Saturday, April 18, 2009 3:38 PM
Grasshopper
Group: General Forum Members
Last Login: 2 days ago @ 4:22 PM
Points: 18,
Visits: 95
This is an excellent article, and long overdue.
Is there a standard boiler-plate for this?
R Glen Cooper
glencooper.tel
Post #700106
James Stover
James Stover
Posted Saturday, April 18, 2009 5:17 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Thursday, March 18, 2010 4:50 PM
Points: 158,
Visits: 505
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
Gift Peddie
Gift Peddie
Posted Saturday, April 18, 2009 5:42 PM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 8:01 AM
Points: 3,082,
Visits: 12,546
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
rudy komacsar - Doctor "X"
rudy komacsar - Doctor "X"
Posted Saturday, April 18, 2009 8:38 PM
Hall of Fame
Group: General Forum Members
Last Login: Monday, March 15, 2010 2:27 PM
Points: 3,003,
Visits: 1,844
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
Jack Corbett
Jack Corbett
Posted Saturday, April 18, 2009 8:44 PM
SSCrazy Eights
Group: General Forum Members
Last Login: Today @ 6:35 AM
Points: 8,187,
Visits: 7,972
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
Brad M. McGehee
Brad M. McGehee
Posted Saturday, April 18, 2009 8:56 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Monday, March 15, 2010 12:54 PM
Points: 130,
Visits: 402
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
Microsoft SQL Server MVP
Director of DBA Education, Red Gate Software
www.bradmcgehee.com
Post #700147
Brad M. McGehee
Brad M. McGehee
Posted Saturday, April 18, 2009 9:02 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Monday, March 15, 2010 12:54 PM
Points: 130,
Visits: 402
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
Microsoft SQL Server MVP
Director of DBA Education, Red Gate Software
www.bradmcgehee.com
Post #700148
Dan Guzman-481633
Dan Guzman-481633
Posted Sunday, April 19, 2009 7:05 AM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, August 19, 2009 5:28 AM
Points: 1,
Visits: 47
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
Adi Cohn-120898
Adi Cohn-120898
Posted Sunday, April 19, 2009 7:52 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 5:38 AM
Points: 1,327,
Visits: 3,235
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 »
20 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2010 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
