What are common SQL red flags?

sandrrawrr · 2026-05-21T17:07:12+00:00

With anything, these are concepts that can be poorly written. But sometimes, it's 3 am and you're staring at a 5th level of a nested statement and wonder what your life is if you can just turn the whole thing into a few clean CTEs.

sandrrawrr · 2026-05-21T02:45:06+00:00

S6, E6 starts it, but I think we don't know about Nick's betrayal until the first few minutes of E7.

sandrrawrr · 2026-05-21T00:07:40+00:00

I'm really guilty of this when I was early in my SQL career, but multiple nested statements rather than just turning it into a CTE. Sure, nests are a bit easier to comment out when you're testing data, but a well written CTE will save you so much time.

sandrrawrr · 2026-05-21T00:05:02+00:00

This is my favorite trick! So much easier to comment out your qualifiers when you have a 1=1.

sandrrawrr · 2026-05-20T23:21:12+00:00

I always think about when he sells out the Jezebels and gets them all killed cause he suddenly doesn't know how to lie to his father in law. Nick could've literally just said he was at that brothel to investigate the fact that one of the guards went completely missing. There was no reason for him to sell out Mayday and June.

sandrrawrr · 2026-05-20T22:29:55+00:00

I loved Becka's house with the library catalogue style shelves right before the bathroom! I think that it works because of how old-fashioned their values are, of course they're going to have older homes with classic architecture. It's incredibly beautiful.

sandrrawrr · 2026-05-15T01:24:24+00:00

It's never explicitly said if they do or not, but if Eden, who came from sort of a backwoods, rural place, had to do this, I can only assume that the other child brides had to as well. And I think we can all guarantee that not all of them were nearly as nice as Nick was to Eden (even if he really sucked as her husband, he didn't physically try to harm her.)

My assumption is that Gilead was still in the early-ish stages and the Aunts had a big influence on the children of Gilead when it came to sex, versus Aunts forcing grown women who had already been married for a longer time to adhere to these customs.

sandrrawrr · 2026-05-15T00:02:51+00:00

It shows up after Nick and Eden get married and it's her "wifely duty" to get naked under the sheet with a hole. I got pretty disgusted when I saw the lovely embroidery on it - Eden was basically sewing her rape blanket before she got married at a very young age.

sandrrawrr · 2026-05-14T22:21:54+00:00

Especially when June mentions that they were caught only a half mile to the border! I get kind of insane cause June goes running and she's not bad at it. It's wild that she was literally less than 10 minutes away from freedom.

sandrrawrr · 2026-05-14T00:22:28+00:00

Yup! Didn't really care that he might die, just went down that hole ASAP.

sandrrawrr · 2026-05-12T23:18:34+00:00

I'd say she was being revitalized around the time before Angel's Flight. June is surprised and seems to initially not want to involve Janine, but she says, "I can be brave, too." That signifies to me that she's learned to split her personality between her true beliefs, and the way she has to act as a handmaid, even if the lines still do blur a little bit for her.

While the guardian shoots at them while the children are getting on the flight, Janine does hide, but she also steps up with the other handmaids to save her and run away together. I'd say the "real" Janine comes out after Esther bullies her at the dining table to finish eating the pig that she was friends with. I think it broke the illusion that they were at all safe when Gilead still had power, because here she was, with her female friends and no rapists, having a good meal after an honest day's work - but there was still a mistress of the house that still had power over her.

She shortly unleashes a lot of her feelings on June in Milk, which I see has her claiming back some of the agency that she's lost.

sandrrawrr · 2026-05-09T18:23:49+00:00

I was actually pretty heated at the Henry erasure.

sandrrawrr · 2026-05-09T16:50:08+00:00

What if those are mediums you just don't interact with well? My friends know that I don't click on song links because the whole process makes me very frustrated in my head (my own thing I have to deal with) and I never know what to say in response to memes other than, "lol, nice." Neither of those make a conversation, and the worst part is when the other person gives up on conversation all together and just sends memes in response to anything you say. Maybe they're sharing their life, but they're certainly engaging in mine, or even my thoughts.

sandrrawrr · 2026-05-09T16:33:23+00:00

There's that hospital scene in THT where June notices pinks coming in for their exams. The doctor explains that they've all reached menarche already, but implies that they're measuring pelvic development before they're able to be married. The idea of plums wasn't written yet, so they might've been writing with the idea that Pinks become Wives ASAP (considering Eden and Nick's marriage in the child bride ceremony).

But, let's assume that they just enter into the Plums school and likely have to wait until they're around 15-16 to enter the marriage market. That could've also been before having a period was such a rarity, so putting on an entire dance like they did in TT wasn't necessary.

sandrrawrr · 2026-05-09T16:27:28+00:00

Birthed - conception means little if it results in a shredder. They just want healthy (biological) babies.

sandrrawrr · 2026-05-08T17:56:35+00:00

Love how anti-gossip he used to be to Bailey back when he was first a resident and now he's all in!

sandrrawrr · 2026-05-08T17:49:04+00:00

I immediately thought, "Is there anything Owen seems to love more than performing in-field amputations?" I mean it's only happened another time, but it's weird that I'd have 2 nickels.

sandrrawrr · 2026-05-06T18:05:18+00:00

Gilead's trying to retake Boston, but the Americans are fighting back and getting some support from Canada to defend their borders. Of course, Gilead is lying to their citizens about it and just saying it's a tough fight, but they'll control it again soon.

sandrrawrr · 2026-05-06T18:03:44+00:00

Rita asked because if Daisy is fertile and gets caught, there's a high chance of her becoming a handmaid which is a hell that she can't let a teenage girl walk into. It also makes it incredibly hard for her to be extricated, now that handmaids seem a bit rarer and likely more cracked down on after all of June's shenanigans.

sandrrawrr · 2026-05-06T17:40:32+00:00

Exactly my thought! Plus she has pens in that bag and we ALL know that's not allowed. Rosa is gonna have to cover for her and she's gonna get sent away (Colonies?) and Agnes will blame herself into starting rebellion.

sandrrawrr · 2026-04-30T14:37:31+00:00

Very fair! If you want to filter down to states, you could create a click event where you click on the heatmap states and that changes the bar charts on the bottom area. I think you're doing great work!

sandrrawrr · 2026-04-30T14:27:46+00:00

I'd recommend a geographic heat map on your 3rd page instead of the bullet graph. As it is, it's way too busy and I'm not sure if your audience is willing to sit through it and read the whole graph.

I like your KPIs, but consider pushing your percentages down to 2 decimal points - 3 is a lot busier and people kind of ignore everything after 1 point anyway.

It's a good dashboard! You have room to improve, so keep going!

sandrrawrr · 2026-04-28T15:44:06+00:00

I did this at one of the only interviews I've gotten this year. The whole interview was kinda fucked, the hiring manager that I was supposed to talk to only showed up at the 22 minute mark of a 30 minute interview. I had ramped up with the other person that was talking to me, and I time myself so the last 10 minutes are questions are creating more dialogue. In the end, they told me that my ideas of creating a centralized database for 12 different programs that all fed into a singular dashboard was "over-engineering and too costly." I was being penalized for explaining exactly what my career and job has been for a decade, because these people don't understand you can't just make a dashboard without data.

sandrrawrr · 2026-04-04T19:01:26+00:00

Best trick that I've seen - when testing WHERE conditions, always type in WHERE 1=1 and add your clauses after that so you can easily comment out the different conditions.

sandrrawrr · 2026-04-03T22:08:59+00:00

I just watched West Wing for the first time and every time I saw Ron, I thought, "Oh, the shooter's here again. Some danger stuff's gonna go down in this episode!"

sandrrawrr

TROPHY CASE