The Four Horsemen Of SQL Joins

Content Python Posted by upeterlravn 12h 19483 54 82 84 I maDe a sCriPT thAT raNdOMIY cApiTAlIZes lEtTErs iN a SEntENcE Beginner Showcase I waS tIrED OF mAnUaLIY tYPinG UpPEr And lOwERcaSes, whEn i WANteD tO mOCk A coMMeNT. sO i MAde a ScRIpt FOr It iNsTeaD. iT TaKEs anY stRIng And rANdOMly apPLieS aN UPpeR or LowERcaSe to IT. iT aLso maKes sUre tHeRe Are no MoRe ThAN twO oF ThE SAme upPEr or lOwERcAseS iN A roW, BeCauSe haVinG tHreE oF thE SaME iN A Row LooKs rEAllY WEiRD. I ALso coNSidEReD MAkiNg SuRe thAT I WOULD aLWaYS bE in LOwErcASe And 'L' WoUlD alWAyS Be in uPpErCAsE, BUt THaT MAdE it lOoK kiNDa wEIrd. ANyWAys, heRE'S THe COdE: https:github.competerlravnMy-projectsblobmasterA20ScrIpt 20020MaKE20fUN20of20A20sENteNcE.ipynb i'M kiNdA neW tO pyThOn, so thErE'S prOBabLy THinGs In thE coDe thAT's noT VerY... pyTHoNIc... 1.7k I 146 Share Award BEST COMMENTS iMoe 11h re 8 Awards pYtHoN dEvElOpEr Reply 1.3k J

Content There's a repo on Github containing some scripts used by a tech employee that his coworkers discovered after he left the company. Here's a summary of his shenanigans: xxx: OK, so, our build engineer has left for another company. The dude was literally living inside the terminal. You know, that type of a guy who loves Vim, creates diagrams in Dot and writes wiki-posts in Markdown... If something - anything - requires more than 90 seconds of his time, he writes a script to automate that. xXx: So we're sitting here, looking through his, uhm, "legacy" xxx: You're gonna love this xxx: smack-my-bitch-up.sh - sends a text message "late at work" to his wife (apparently). Automatically picks reasons from an array of strings, randomly. Runs inside a cron-job. The job fires if there are active SSH-sessions on the server after 9pm with his login. xxx: kumar-asshole.sh - scans the inbox for emails from "Kumar" (a DBA at our clients). Looks for keywords like "help", "trouble", "sorry" etc. If keywords are found - the script SSHes into the clients server and rolls back the staging database to the latest backup. Then sends a reply "no worries mate, be careful next time xxx: hangover.sh - another cron-job that is set to specific dates. Sends automated emails like "not feeling well gonna work from home" etc. Adds a random "reason" from another predefined array of strings. Fires if there are no interactive sessions on the server at 8:45am. xxx: (and the oscar goes to) fucking-coffee.sh - this one waits exactly 17 seconds (!), then opens a telnet session to our coffee-machine (we had no frikin idea the coffee machine is on the network, runs linux and has a TCP socket up and running) and sends something like sys brew. Turns out this thing starts brewing a mid-sized half-caf latte and waits another 24 (!) seconds before pouring it into a cup. The timing is exactly how long it takes to walk to the machine from the dudes desk. xxx: holy sht I'm keeping those Reply 4 10.3k J

Content Hacker Scripts Based on a true story: xxx: OK, so, our build engineer has left for another company. The dude was literally living inside the terminal. You know, that type of a guy who loves Vim, creates diagrams in Dot and writes wiki-posts in Markdown... If something - anything requires more than 90 seconds of his time, he writes a script to automate that. xxx: So we're sitting here, looking through his, uhm, "legacy" xxx: You're gonna love this xxx: smack-my-bitch-up.sh - sends a text message "late at work" to his wife (apparently). Automatically picks reasons from an array of strings, randomly. Runs inside a cron-job. The job fires if there are active SSH-sessions on the server after 9pm with his login. xxX: kumar-asshole.sh - scans the inbox for emails from "Kumar" (a DBA at our clients). Looks for keywords like "help", "trouble", "sorry etc. If keywords are found - the script SSHes into the clients server and rolls back the staging database to the latest backup. Then sends a reply "no worries mate, be careful next time". xxX: hangover.sh - another cron-job that is set to specific dates. Sends automated emails like "not feeling wellgonna work from home" etc. Adds a random "reason" from another predefined array of strings. Fires if there are no interactive sessions on the server at 8:45am. xxX: (and the oscar goes to) fucking-coffee.sh - this one waits exactly 17 seconds (!), then opens a telnet session to our coffee-machine (we had no frikin idea the coffee machine is on the network, runs linux and has a TCP socket up and running) and sends something like sys brew. Turns out this thing starts brewing a mid-sized half-caf latte and waits another 24 (!) seconds before pouring it into a cup. The timing is exactly how long it takes to walk to the machine from the dudes desk. xxx: holy sht I'm keeping those

Content Looking to hire a Jr Data Scientist: - 15 years Python - 30 years SQL - 20 years AWS - 15 years Spark - 15 years Terraform - Core contributor to assembly code base - Team player - Should have some sort of martial arts experience, whether Ninja, Jujitsu, or Karate. All 3 is preferred. - Knows SQL, NoSQL, NewSQL and all future flavors of SQL - Project Management experience - Strong experience with Keras, TensorFlow, Sklearn, XGBoost and preferably has written their own ML library from scratch. - Should have published at least 2 top level academic papers preferably focused around a Convolutional Recurrent Back-propagating Neural Network - Open source contributor at least 5 projects. - Experience leading teams of 10,000 people or more - Managed CICD pipeline for an application with at least 2 billion daily users - Should have at least 1 PhD, 5 is preferred. Yes, we have ping pong tables and an open floor plan and lots of salty snacks in the breakroom. Organic Kombucha on tap. The interviews will consist of a 5 day process of whiteboarding algorithms from scratch followed by writing your own compiler and a coding exam will be taken at random from the 20 most popular programming languages.

Content 1:09 0 8 SOL Injection Fools Speed Traps And Clea.... hackaday.com SQL INJECTION FOOLS SPEED TRAPS AND CLEARS YOUR RECORD by: James Hobson 110 Comments April 4, 2014 ZU 0666, 0, 0: DROP DATABASE TABI Typical speed camera traps have built-in OCR software that is used to recognize license plates. A clever hacker decided to see if he could defeat the system by usina SQL Iniection. Hackaday 190.923 Page likes

Content programing professors Um. whatcha got there? global variables me A smoothie