They let the intern access the production db. The company is one of the biggest hosting and internet service companies in the country. The db was SQL but had no primary key.
I was the intern. I normalized it to 3NF as part of my internship project.
1) Be nice and; have fun
Doxxing, trolling, sealioning, racism, and toxicity are not welcomed in AskLemmy. Remember what your mother said: if you can't say something nice, don't say anything at all. In addition, the site-wide Lemmy.world terms of service also apply here. Please familiarize yourself with them
2) All posts must end with a '?'
This is sort of like Jeopardy. Please phrase all post titles in the form of a proper question ending with ?
3) No spam
Please do not flood the community with nonsense. Actual suspected spammers will be banned on site. No astroturfing.
4) NSFW is okay, within reason
Just remember to tag posts with either a content warning or a [NSFW] tag. Overtly sexual posts are not allowed, please direct them to either [email protected] or [email protected].
NSFW comments should be restricted to posts tagged [NSFW].
5) This is not a support community.
It is not a place for 'how do I?', type questions.
If you have any questions regarding the site itself or would like to report a community, please direct them to Lemmy.world Support or email [email protected]. For other questions check our partnered communities list, or use the search function.
6) No US Politics.
Please don't post about current US Politics. If you need to do this, try [email protected] or [email protected]
Reminder: The terms of service apply here too.
Logo design credit goes to: tubbadu
They let the intern access the production db. The company is one of the biggest hosting and internet service companies in the country. The db was SQL but had no primary key.
I was the intern. I normalized it to 3NF as part of my internship project.
I work in IT. Most systems have laughable security. Passwords are often saved in plain text in scripts or config files. I went to a site to help out a very large provincial governmental organization move some data out of one system and into another. They sat me down with a loaner laptop and the guy logged me into his user account on the server. When I asked for escalated privileges, he told me he'd go get someone who knew the service account passwords.
After a few minutes, I started poking around on my own... And had administrative access within an hour. I could read the database (raw data), access documents, start and stop the software, plus, figured out how to get into the upstream system that fed data to this server... I was working on figuring out the software's admin password when the guy came back. I'm sure that given some more time, I could have rooted the box because the OS hadn't been updated in years.
I worked for a pretty popular magazine back in the late 90's. One day near the beginning/middle of 2000, we were all called down to the bullpen for a last minute meeting by management and marketing. (That's never a good sign.)
We were told that we have a great product with amazing writing, but marketing doesn't know how to sell it so they're closing us down. Instead, we went online only. I was the web developer so I survived the firings.
So then we figured that we were set because our website produced more content and had more traffic than any of the company's other websites. However, in March of 2001, we had another emergency meeting. Again, we were told our content was great, but the company was going in another direction. Instead of producing our own content, the company was going to just repost other sites' content. I and everyone else in my team were let go.
Needless to say, the whole "we'll just repost what other people posted" plan didn't go so well. Last time I checked, the company wasn't doing very well at all.
Probably not, but sounds like Cracked.com?
Back when I managed a Blockbuster Video, most stores ran at a loss thanks to theft.
The real reason most stores failed wasn't because DVDs were going out. It was because we couldn't stem the flow of money out the door thanks to thieves.
Office Depot sells printers at very low (or even negative) margin, and then inflates the margins on cables, paper, ink, and warranty. If you want the best deal, get the printer from OD, and everything else you need somewhere else. That $20 USB cable they sell costs them $1 and you can get the same or better online for $2.68.
I used to work at Starbucks (almost a decade ago now), but at the time, the motto was "just say yes" to any customer requests. We also had free drink cards that you could give out to deesclate any issue. So I would say any time you're even the slightest bit unhappy, bring it up, and you should at least have your problem solved, if not compensated for a free drink next time.
We also had customer satisfaction surveys that would print on reciepts, where filling one out would get the customer a free drink. We always kept them for customers that were happier to try and rig the odds in our favour of a higher rating, but also if a customer asked for one, I would give it if I had it. You could always ask the cashier if they have any of those as well.
Again, not sure how much either of those things have changed in the past 10 years, and I'm not sure how regional it was (this was in Canada at a corporately run store), but maybe worth a try.
Also I love these types of threads -- great topic to post.
The amount of school districts and city govts. that use Google docs for everything is terrifying. I'm talking plain text student info and billing information.
An European Country stores citizens' critical data in vulnerable databases, whose password is in HaveIBeenPwned, on a VPN whose certificates are stored in random NASs. The IT guys don't know how encryption and certificates work and I wouldn't be surprised if everything was in some adversary countries' hands
Anybody knows that one waterfall attraction in the Southeast US? The one that advertises bloody everywhere? Waterfall is pumped during the dry seasons, otherwise there'd be nothing to see. Lots of the formations are fake, and the Cactus and Candle formation was either moved from a different spot in the cave, or is from a different cave in New Mexico. Management doesn't want people to know that, but fuck 'em.
Niagara falls?
Nawh mate, that's up in New York and Canada.
I'm simple man not from US. I hear waterfalls, I think Niagara ¯\_(ツ)_/¯
As a simple Canadian man having been to Niagra Falls several times, I defy humanity to engineer a way to pump that much water.
The buildings alarm code was 0711. Guess where I worked....
Our SSL implementation never checks the certificates, largely defeating the purpose of SSL.
I find it humorous that y’all think it’s only the company you worked at that had a fragile tech solution held together (sometimes literally) with duct tape and coat hangers, as part of a mission critical business process.
Pretty much every company big or tiny has at least one permanent “temporary” solution in place.
I worked for a very large insurance company until recently . IT is run like the Wild West. Contractors seem to do whatever they want.  after a merger several years ago, all the people who built the systems were driven out, leaving a bunch of low paid outsourced contractors to support everything. The entire IT infrastructure is a bad day from collapsing.
Shit, piss or vomit has graced just about every surface at your public pool and the staff are constantly fighting a losing battle against it. Nothing is washed just power sprayed till it looks clean.
Everything comes in frozen. Before mixing with the sauces it smells off. Half the staff mix without gloves. Dont get the tuna but have it your way...