SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


It's Not Yours


It's Not Yours

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (602K reputation)SSC Guru (602K reputation)SSC Guru (602K reputation)SSC Guru (602K reputation)SSC Guru (602K reputation)SSC Guru (602K reputation)SSC Guru (602K reputation)SSC Guru (602K reputation)

Group: Administrators
Points: 602238 Visits: 21099
Comments posted to this topic are about the item It's Not Yours

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Sean Redmond
Sean Redmond
SSCarpal Tunnel
SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)

Group: General Forum Members
Points: 4487 Visits: 1035
I divide the scripts that I write into 2 categories.
• Anything that has business data in it, stays strictly within the company.
• Template-scripts that are often used for the first category *and* that have no business-specific data or fields from user-databases within.

An example of the second category is a series of scripts used to create transactional replication across 2+ servers. Any business-specific data is to be defined at the beginning in variables, which are left empty in the template. They are the sort of scripts that I should really upload to this site.
Another is the script I use every morning to check backups, failed jobs etc.

I have no problem taking these scripts home with me or bringing from one employer to another.
It is true that they were written on company time. On the other hand, the time I spending learning for my various MCP exams, which helped me write these scripts was done on my own time and I see it as a win-win for both me and the company.
call.copse
call.copse
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14116 Visits: 2410
Sean Redmond - Wednesday, January 17, 2018 2:25 AM
I divide the scripts that I write into 2 categories.
• Anything that has business data in it, stays strictly within the company.
• Template-scripts that are often used for the first category *and* that have no business-specific data or fields from user-databases within.

An example of the second category is a series of scripts used to create transactional replication across 2+ servers. Any business-specific data is to be defined at the beginning in variables, which are left empty in the template. They are the sort of scripts that I should really upload to this site.
Another is the script I use every morning to check backups, failed jobs etc.

I have no problem taking these scripts home with me or bringing from one employer to another.
It is true that they were written on company time. On the other hand, the time I spending learning for my various MCP exams, which helped me write these scripts was done on my own time and I see it as a win-win for both me and the company.

Scripts and code are a different issue from data IMO. Normally the former is - well, not exactly fair game, but who's to say you haven't replicated it? In my experience it's not directly useful from one company to the next, but you normally like to remember particularly well crafted examples of this and that. Data on the other hand - I would never even consider taking that sort of thing.

jay-h
jay-h
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: General Forum Members
Points: 15644 Visits: 2783
I would think backing up classified information onto someone else's laptop would also be a no-no.

...

-- FORTRAN manual for Xerox Computers --
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (870K reputation)SSC Guru (870K reputation)SSC Guru (870K reputation)SSC Guru (870K reputation)SSC Guru (870K reputation)SSC Guru (870K reputation)SSC Guru (870K reputation)SSC Guru (870K reputation)

Group: General Forum Members
Points: 870141 Visits: 47415
The title of this article is "Its not yours". While I definitely agree with that, I'm the DBA for the company I work for. That means that I'm charged with both the safety of the data and making it available to the right people and only the right people. The data is actually mine because I have to guard it and only distribute it to the right people as if my job depends on it... and it does.

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
MarkieMark
MarkieMark
Grasshopper
Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)

Group: General Forum Members
Points: 18 Visits: 22
We provide analytics for our clients and they provide us with a full copy of their data. I have a login to the client’s CRM. There is a URL field in the export that they provide and when they first created the schema there were no constraints on that field and about 6 of those records has multiple URLs separated by a comma. Since the only export method they offered was a CSV the comma in the URL was causing the import to fail. Later they added constraints to make sure the URL was valid and only contained one record. I decided to “correct” the data figure out which was the best URL and change it in their system. The third URL that I hit infected my machine with malware (even though I have virus protection and current windows updates). That is what I get for over stepping my boundaries!
Steve Jones
Steve Jones
SSC Guru
SSC Guru (602K reputation)SSC Guru (602K reputation)SSC Guru (602K reputation)SSC Guru (602K reputation)SSC Guru (602K reputation)SSC Guru (602K reputation)SSC Guru (602K reputation)SSC Guru (602K reputation)

Group: Administrators
Points: 602238 Visits: 21099
Sean Redmond - Wednesday, January 17, 2018 2:25 AM
I have no problem taking these scripts home with me or bringing from one employer to another.
It is true that they were written on company time. On the other hand, the time I spending learning for my various MCP exams, which helped me write these scripts was done on my own time and I see it as a win-win for both me and the company.

Usually no one does, and certainly they want you to bring those when you come to the employer. However, I'd get permission or at least let the boss know. Never had an issue with this.


Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Steve Jones
Steve Jones
SSC Guru
SSC Guru (602K reputation)SSC Guru (602K reputation)SSC Guru (602K reputation)SSC Guru (602K reputation)SSC Guru (602K reputation)SSC Guru (602K reputation)SSC Guru (602K reputation)SSC Guru (602K reputation)

Group: Administrators
Points: 602238 Visits: 21099
Jeff Moden - Wednesday, January 17, 2018 6:56 AM
The title of this article is "Its not yours". While I definitely agree with that, I'm the DBA for the company I work for. That means that I'm charged with both the safety of the data and making it available to the right people and only the right people. The data is actually mine because I have to guard it and only distribute it to the right people as if my job depends on it... and it does.
Still not sure the data is yours. It's your responsibility and you have accountability for doing your job, but you implement someone else's rules for managing the data and authorizing users.


Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Eric M Russell
Eric M Russell
SSC Guru
SSC Guru (108K reputation)SSC Guru (108K reputation)SSC Guru (108K reputation)SSC Guru (108K reputation)SSC Guru (108K reputation)SSC Guru (108K reputation)SSC Guru (108K reputation)SSC Guru (108K reputation)

Group: General Forum Members
Points: 108443 Visits: 14551
... A contractor just pleaded guilty to stealing classified information from the US National Security Agency, about 50GB worth of data. This isn't a case of spying or malicious intent. Instead, the report is that the employee was a hoarder, just keeping copies of data for some unknown reason. Hopefully that's true ...


If you follow the link the news stories cite 50 (TB) not 50GB.

With a dataset that large, it makes one wonder which NSA database he downloaded. Maybe this guy was wanting to spin up his own implementation of a domestic surveillance program in his basement using a make shift Hadoop cluster.

Whether this is considered theft should be based on how many security controls he had to bypass in order to download that much data. Did he login using a privileged account? Did he siphon off a little at a time in an effort to avoid detection? Does the NSA have so much spare network bandwidth that a 50 TB dump wasn't noticed while in process?


"The universe is complicated and for the most part beyond your control, but your life is only as complicated as you choose it to be."
patrickmcginnis59 10839
patrickmcginnis59 10839
SSCoach
SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)

Group: General Forum Members
Points: 19334 Visits: 7987
Jeff Moden - Wednesday, January 17, 2018 6:56 AM
The title of this article is "Its not yours". While I definitely agree with that, I'm the DBA for the company I work for. That means that I'm charged with both the safety of the data and making it available to the right people and only the right people. The data is actually mine because I have to guard it and only distribute it to the right people as if my job depends on it... and it does.


I don't understand how this grants you possession of this data. Can you take it home and subsequently erase it from the company's computers?

to properly post on a forum:http://www.sqlservercentral.com/articles/61537/
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