SkillsTSQL, MS SQL and Microsoft Transactional Structured Query Language
LocationIn the fucking database
Joined devRant on 5/26/2018
Do all the things like ++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatarSign Up
Just out of curiosity, how comes there isn't any direct messages/chat room/discord server/general message board for devRant?
I genuinely have no issues with it, in fact, I don't think there's any loss from there not being any; it's never been something I felt it needed.
It's just that I like devRant so I'm extremely interested in the design choices tbh.6
Heh, a review of HHKB Pro 2, think someone missed the point haha.
Anyone got this keyboard and recommends? I mean, if no one responds I'm buying anyway just nice to hear from devs on it4
This is the fucking data warehouse............
10 FUCKING INDEXES IN THE ENTIRE THING!
Btw...that includes Primary Keys5
Swear work is where you I go to fix other peoples poor design decisions and clean up the bullshit that comes out of said decisions.
How you have so many years experience and still design in way that ensures that maintenance /improvements/touching in the future is a huuugggeee clusterfuck.
Hey, I got an idea, lets make this whole data warehouse without a single index or primary key cos you know, that's the Kimball Method.2
Come in, check task list, everything is basically "awaiting confirmation" or "acronyms you've never seen before talking about things that only like 2 people know about" or "check the powerpoint that you've never seen or even knew existed"
Sooooooo home time? Besides, it's POETS day ;).
For those that don't know (Piss Off Early, Tomorrow's Saturday)3
Red Dead Redemption 2 Day - Awesome
No managers in today - fucking win
Work from home day - Can we get anymore wins?
Remote into computer that works for everyone - TODAY IT DONT FUCKING WORK -_-
Guess its a normal ass work day today and it's raining, fuck you Earth. No one is allowed to play RDR2 until I get home2
NO! Use the description instead of the primary key because the key might change ................................................................................................................... vs the description .............................................................................................................. the key more likely .............................................. meh2
Sooooo....worked at a place (which i think was my first rant on here lol) a little while back where, to keep a long story short, was treated like shit and still managed to pull out some magic for them before i left my contract (cos work pride).
Come to new company, it is a consultancy company. The project I worked on at the previous company, they had came (while i was there, i went to the meeting) and done some requirements analysis for them (that weren't even relevant, mostly because the CIO was a tard).
Come to find out today, through the grapevine, that these lot have been claiming that they done more than requirements and actually implemented the full solution and even wrote a case study about the shit they weren't involved in. "Oh look at this GDPR project we completed for this £400M turnover company and all the problems we solved".
More hurtful cos this project I done with no help from anyone, got moaned at every day, got my references threatened, wouldn't let me work from home but anyone else could. Serious, a lesser man would have punched the CIO....repeatedly.
What would you do? I'm getting sick of fighting in every job but also getting sick of never getting any credit for the shit I've done.
Fuck reuse, we should all take our repeatable code and manually repeat it everywhere it's needed so when we have to make a change we have to make sure we remember to change it in all the places and take hours to do a one line change.
...Also...fuck source control...
And they say I don't have fucks to give.1
WHY THE FUCK EVERY DAY YOU SEND A NOTE TO THE CLIENT TO TELL THEM A SQL SERVER JOB RAN.....!?!?!?!?!?!?
Seriously....no automatic messaging....FROM THE FUCKING IN BUILT SERVICE...the fuck is this manual life that people love to promote.
WOOOOH I HAVE BEEN GIVEN WORK.
Think I offended people cos I already finished it and when I got given it i said "Is this it?".
.....AND THIS MOTHERFUCKER TOLD ME TO DO A LOOP IN SQL TO UPDATE A TABLE. I'LL CUT OFF ALL PARTS OF HIM
I work in office block, he works in company next to me, was wondering where he been for the last couple hours. Started thinking he weren't in today hahaha.
Can't lie, might jump into the booth next to him 😂😂😂😂
FUCCCCCCCCCCCKKKKKKKKKK.....I'm soooooooooooooo bored.
I'm a contractor, been here 2 months, yet to write any code. All I do is WhatsApp and devRant.
Siigggghhhhh, someone shoot me.13
Writes rant, accidentally refreshes page...
Writes lazy rant instead.
(Was a good one aswell but im less stressed about it now :p)3
Sooooo anyway to hide my profile name from the home screen?
Feel that eventually someone from work is going to put 2 + 2 together and check my rants out xD3
Went to a Hackathon, the platform looked like bs and the documentation was mehhh. So spent the time sleeping, waking only to eat Pizza :3.
(Know it was bs when no one cared >.>)2
Best explanation about the bullshit of dev work I've seen xD2
Ahhhhhh anyone here use yED? I don't know how i even worked out diagrams before this. For the past couple years this has been my choice diagramming tool <3
Top image is before, bottom is after a single click. I just join boxes and let it work it out at the end. Then obviously do some adjustments to read how I like but seriously makes it easier to trial various layouts. I even make stuff in yED before recreating in something like Visio, if need be.
If anyone got another diagramming tool they like to use, post below (trying to add new stuff to my toolbox lol)
EDIT: Ahh, tried but you can't see the lines after the image gets compressed after upload (and DarkReader on chrome isn't exactly helping :p).11
sigh spent whole of yesterday dealing with shitty remote desktop connection, come in today, still shitty...wait what...ahhhhh no way.
*Connect HDMI to monitor and move RDC to monitor* Connection issues gone...ahhh fuck you.
Teaching new recruit some SQL (even though hes supposed to fucking know SQL and have multiple years experience but I was a contractor and idgaf, not messing up my money. Just fucking annoying to have an idiot around you all the time).
Me: Okay, so sys tables, so this one is for jobs yeah?
Me: Okay, so in this table, its obviously not one row per job per step cos you have multiple rows for the same job and step. Also, there is a datetime field, so what is it showing?
Him: Hmmmmm..... (after some time, back and forth we get to the answer).... history table
Me: Cooooooool, okay, so, lets say, I have a job with 5 steps. If i run it once, how many rows will be in this table?
Him: 5 rows.
Me: Correct, so if I were to have run this same job, 10 times, how many rows get inserted into the table?
Him: (Now...you have to understand, how long this thought process was, im trying to fill the gap with words but really, he was like, having a flashback or something...I kept quiet but silently wanting him to say anything....then he looks me dead in the eyes).... 10!
Me: Motherfucker what!?!? 10 What? If 1 time == 5, what does 10 times ==?
Him: Hmmmmmmmmm.... (yes...we are doing this whole flashback montage all over again)....... Ohhhhh, 1!
Me: .....Stop, think, its a history table. It holds history, for when every step is run for a job, why would it be only one row?
Him: OMG, I know what a history table is!!!!
Me: (Pissed off cos I don't take disrespect calmly). Fine, genius, answer, go!
Him: (LONGER WAIT THAN LAST TIME!!!!)....is it not 10?
Me: I swear, I'm gonna kill you one of these days.
TOOK 20-30 MINUTES FOR HIM TO SAY 50!!!!!!
And even then, I swear he didn't understand why. Serious, he was a special breed, had a manager that was a super tard and when I worked here, the spirit of that manager possessed this idiot, the CIO and his little right hand bitch zzzzzzzzzzzzzzzzz.
If there was ever a time I was willing to catch a case at work, it was there.
Bonus: Serious, it got to the point I had to come in and tell this idiot that he can only ask me questions today if he calls me by my name...and my name has changed today...and no, you can't ask me for it cos you need my name to ask me questions.....FUCK OFF kkthxbai.5
FUCK MICROSOFT!!! WHAT THE ACTUAL FUCK!?!?!?!? WHY IS THIS EVEN A THING!?!?!?!?
WHYYYYYY HAVE WE GOT A FUCKING DARK THEME IF WHEN I ADD ANNOTATIONS IN SSIS IT'S HARDCODED COLOURS.
No...seriously...not only am i doing this bullshit waste of time redundant annotations for some bullshit client that thinks they know shit but when I use the dark theme like a normal person, if you go back to a normal theme, all annotations in white.
Just finished like 30 packages on this slow ass remote connection and now all these backward ass people that use light themes (like everyone but me) can't see anything written.
Fuck you Microsoft!!!!! Soooooo many fucks for you right now....don't even know how to express the fucks.4
Why every day I have to fight for a charger cos the manager needs his phone on a constant charge from a power socket.
Fuck you and no I don't care that your shits gonna die now and yes, every fucking day we're doing this, don't fuck with me. My laptop > your phone and your ingress game2
Me, working hard on a SQL project with a deadline that is half what it should be with no support from the other people on the project and was mostly made with with data I imagined would be in there cos no one could get me any fucking shit done (i.e. effectively designed, built, tested, fixed, upgraded, documented on my own for an entire weekly/monthly/ad-hoc analysis process that would output various reports for internal/external/management)
Manager - man who is a known waste of space but for some reason is in charge of the smallest part of the project, shouldn't have been fucking involved fucking management guzzling stain magnet...
Manager: Hey, do I need to refresh the database?
Me: ............I dunno, do you think we should refresh the database that this entire project is reliant? I mean...why do we need up to date transactions to analyse? Wait....you telling me it's not been being refreshed this ENTIRE time?
Manager: No....you never said I should. So should I?
Me: ..................I never said you should!?!? Are you not in the meetings talking about dependencies?????? Do you think i should have up to date trans or just run this with old stuff????? Why would you not update it!??!!?!?!? Its transactions...... (Desperately trying not to punch through my screen, through his, into his throat)
Manager: I think i'll refresh it and add it to the job?
Me: ....................(goes back to work cursing with music in so I think its quiet but who knows).
Tard, don't know how he even gets to work without someone holding his fucking hand.
Happy ending, I don't work there anymore :p
Sad ending, his spirit of tard follows me to my new jobs and possesses someone (or three sometimes)
Best: Becoming an IT contractor
Worst: Not telling more people to "fuck off and go fuck yourself if you're not going to be helpful" while I was perm
"No, the Client doesn't like stored procedures so we have done all our TL parts of the ETL using a bunch of views on top of views on top of views."
Wish I could have been here at the start so I could have pushed back, sigh.
Siiiggghhhh, yet the client is anal about performance and even consistency in SSIS packages.....siiiggghhhhhh but we dont have SHOWPLAN permissions or even sp_who2 access...siiiigggghhhhhh.
If i expanded one of the final views, would be like 1k lines. For the amount of data, we move, there shouldn't be any noticeable processing time but it can take anywhere from 10mins to an hour.2
Sigh, what is it with these cowboy SQL Devs? Why the fuck is this a pattern for anything?
New contract, new idiots, sigh.
EDIT: Had to change picture because Prod is different to Dev (but no dev has been done since release....smh)4
This is probably the worst place to start my Rant saga but this is recent (this is one of the last few episodes of a 3 series cluster fuck of a job so you're missing out on all the straws that go into breaking the camels back and making him unaccommodating)
TL;DR I do good work, management dont like me and go out their way to try and fuck up my days
So, lets start, I'm a contractor, got funeral Tuesday, book leave, book WFH for day after.
I leave in 3 weeks, woman who is the CIO's right hand bitch takes me into a room the next day or so in the morning to discuss my WFH day. Leave on tuesday is cool but this WFH day...there's only so long until I'm gone so they want me to stay in for more face-to-face time blah blah blah (considering this woman isn't even part of the project I'm working on anymore because she decided to deflect it onto a underqualified junior with no PM experience)
So I sit there, thinking of all the blood and sweat that I have shed, the mountains I've moved just to be told to move the mountain somewhere else and whether coming in would kill me (in other words im fucking burnt out!!! I have built their GDPR database and app backend single-handedly with no requirements, project managers who can't plan and being chastised for asking for documentation/plan/anything written down and having the CIO who is also the fucking DPO ignore any emails/slack I send him relating to the project and having to keep up with a team of devs....).
So because there was a momentary silence, she decided to fill the gap
"Oh, you've done some good work so far and I wouldn't want you to ruin it all in these last 3 weeks. So just come in on the Wednesday so that we can have you here."
Hmm....yeah...i didn't notice what she had ACTUALLY said there, still thinking about can i be fucked? So she decides to add
"...there's only 3 weeks left, wouldn't want you to burn any bridges. Remember, we still have to give you a reference"
....Okay....shots fired. So i respond
"You saying, if I take a WFH day, you'll give me a bad reference?"
"Noooo no no no, not saying that, just that you've done good work and we wouldn't want you to ruin it"
"With one wfh day?"
"We just want you to come in because the developers might be coming here that week"
"Oh... I hear that...what day?"
"I dunno, it's not been booked yet"
".............................I'll think about it"
"There's nothing to consider"
*Start leaving room* "I'll think about it...."
So cool, obviously, had a think, decide to shoot over an email (or more accurately, a collection of bullets). Which basically said, in devRant translation, "Fuck y'all, I'm WFH on that day, I wish a motherfucker would fuck up my reference, we can go that way if you want it. *snaps fingers* I. WISH. YOU. WOULD! "
Woman says "I wasn't threatening you, was just saying...dont ruin your last 3 weeks, wouldn't want you to burn any bridges and that we still have to give you a reference"
What kind of Godfather comment is that?
Come in today, the CIO, who is a prick who don't like me for whatever reason, sends me long email trying to disrespect me and in the midst says "I’m sorry that you have chosen to react like this, I’m sure that [my bitch] was conveying a position that your last three weeks of contract are crucial for a smooth handover. I have made the decision to not require you to work from home on Wednesday. I understand you are on leave on Tuesday and therefore this is now extended to include Wednesday. I look forward to seeing you back in the office on Thursday. I hope this will make the situation better for all parties."
.................................thought you lot needed me in the office to ensure a smooth handover................logic..........people.............where the fuck do you get yours from!?!?!?!? All this just so they can say "We made the decision at the end :cool:"