Movie Review Wednesday

So I’ve Been Thinking…

Data isn’t literally everything.  I mean it is, technically, but it’s not all super happy fun times, so we need to take a break once in a while and do something less neuron-intensive.  Thus, my new segment: movie reviews!  Because, despite what you may have read, all work and no play make Nate a dull boy.  And yes, I promised you this blog would be professional.  Mostly.  I remember specifically using that word.  So don’t wag your naggy finger at me.  If you don’t like it, you can simply avoid the tags like #offtopic and #movies.

You, dear reader, may have guessed this already, but just in case you haven’t:  We watch a lot of movies.  Like, a lot.  That new red MoviePass card came out just around the same time that our local cineplex remodeled itself into a “luxury theater” with the reserved reclining seats, dining service, and all that jazz.  But besides that, when the day’s work is done and it’s time to chill, Netflix/Prime/Kodi are our M.O.’s.

Side-note, I’m running Kodi on LibreElec on a Dell micro-PC that I procured for $99 a few Black Friday’s ago.  It’s puny by PC standards, but beefy by media-stick/RPi standards, so it works pretty well.  We’re finding that our WiFi isn’t always quite up to the task of steadily streaming 1080p, but… meh.  It’s generally usable.  It serves up movies from my 3TB spinning-rusts on the circa-2014 gaming PC via Plex, which is a phenomenal app for the modern moviephile — if you haven’t checked it out, do it.

Let’s Get To It!

Back on topic.  Off topic, I mean.  We recently saw The Spy Who Dumped Me.  I was excited for this movie as soon as I saw the poster: Mila Kunis and Kate McKinnon.  Need I say more?  Not really, but I will, because that’s presumably why you’re reading.  I mean, I could watch these two actresses do just about anything for 2 hours.  Let alone a buddy-action-comedy about international intelligence intrigue gone awry.

I first loved McKinnon in the Ghostbusters reboot, where she, no disrespect to the rest of the phenomenal cast, stole the show.  That was a super fun movie too.  (I’m not an SNL guy, though her Hillary impersonation was superb.)  And Kunis, I’ve loved since she took over the voice of Meg in Family Guy.  It didn’t hurt when the wife said she had a girl crush on her too.

This is somewhat of a directorial debut from Susanna Fogel (she has some credits, but nothing blockbuster-worthy, as far as I can tell), and it hits a lot of good notes.  The acting is solid — especially, obviously, the two leads — the action believable, the punchlines not overly cheesy, the character development realistic, and the twists compelling, if a bit predictable.

The one notable gripe I have is the completely random and unnecessary bit of male nudity.  And it’s not that I’m a prude; nudity can have its place in movies, if it serves a purpose.  Look at Forgetting Sarah Marshall — very similar to this instance, technically, but its purpose was clearly to emphasize the point of the character’s vulnerability and shamelessness.  Contrasted to here, where it’s just some dude that Kate’s character hooked up with who turns out to be the first of dozens of agents to try to kill the duo in pursuit of the elusive “flash drive of doom” (which, surprisingly, is not yet a TvTropes trope, but I feel like it should be).  There was literally no point.

Anyway.

On the whole, the movie was excellent — a fun ride through Europe on the tails of two hapless yet confident, inexperienced yet tough, and sometimes supremely lucky ladies who go toe-to-toe with agents of CIA, MI6, and the big scary Russian Mafia.  We see these amazingly close best friends overcome frightening odds and tense situations by sticking together and encouraging each other, which is pretty awesome if you think about it.  There’s a lot of negativity thrown around these days, whether it’s in the name of politics, social movements, or otherwise.  Even your standard male buddy-cop movie usually hinges on the guys’ “banter” of tearing each other down (even in jest), and rarely does it truly bring out the best elements of their character.

Speaking of characters, the chemistry of these two women is top-notch.  They’re different, to be sure, but it works in their favor.  McKinnon is obviously more extroverted; “a little much” as someone tells her derogatorily, but that’s why we love her.  Kunis is of course more subtle; coy, yet never a damsel in distress.  One of the best bits of dialog in the movie, I think, comes from McKinnon’s positively bursting joy at seeing the head of MI6 is in fact a woman, who “hasn’t sacrificed one ounce of femininity!” (Gillian Anderson, of course, being very familiar with the role of an intelligence officer).

Now, I will normally try to avoid spoilers.  Today I will simply tease that yes, while Kunis ends up falling for a guy, he’s proven worthy, and there’s no reason to fault her for it.  If anything, it keeps us grounded in reality.  Of course that reality quickly turns fantasy again in the “post ending”, but that’s for you to enjoy.

The Verdict

Highly recommended, two thumbs up.

Happy Hump Day!  Now go watch some movies.  Preferably this one.  But hey, I ain’t the boss of you.  Do your thing.  And stay tuned for more!

Advertisements

Movie Reviews and the Killer Database Collation

If you have a core database using a different collation than the rest of the DBs around it, BAD THINGS HAPPEN.

And we’re back!  Hi folks, thanks for being patient with my December hiatus.  The holiday season is always a little hectic but this year it felt especially sudden.  And hey, you all have better things to do than read a blog in between the home cooked meals and the family gatherings.. like sleep, shop, and go see all the new movies!

Thanks to both Pitch Perfect 3 and the latest New Year’s Rockin’ Eve, Britney’s “Toxic” is now stuck in my head, so that’s fun.

britney-stewardess-toxic
I think I’m ready now… for 2018.

Some of you may not know this, but I’m a big movie nerd.  Not like the weird “knows a bunch of obscure factoids about all the Tarantino movies” or whatever.  But I do quite enjoy the behind-the-scenes / making-of stuff — what used to be called “bonus features” on DVDs (remember those things??) — whenever the wife will tolerate sitting thru them with me.

Our genre of choice is generally horror.  Now, I’m gonna get nerdy on you for a bit; because there are several sub-types or horror, and I enjoy almost almost all of them.  Campy, creepy, fun, found-footage, gory, spooky, slasher, supernatural, tense, psychological, revenge, deconstruction, possession.  For the uninitiated, “deconstruction” is like 2012’s Cabin in the Woods — it pokes fun at the tropes while building on them in unique ways.  Those are one of my favorite kind; that one in particular is definitely in my top 10 all-time.

So to kick off this year, before diving back into the technical stuff, I’d like to give you a coupe lightning reviews of some horror movies that we’ve watched that are perhaps underrated or you may have missed.

  • The Babysitter (2017) – comedy/deconstruction. A young preteen boy, whose parents are gone a lot, has a great friendship with his older teen babysitter, but one night decides to spy on what she and her friends do after he goes to bed. And well, crap hits the fan.  Lots of fun, eye candy, and slapstick violence. 👍👍
  • Patchwork (2015) – campy/revenge. 3 girls are Frankenstein’d together and have to overcome their mental differences and physical struggles to piece together the perpetrator and hopefully exact some revenge. Superbly acted by the lead lady, plenty of violence and just enough funny bits to keep it going. 👍
  • Happy Death Day (2017) – slasher/deconstruction. Think Groundhog Day but with a college chick being killed by a masked marauder repeatedly.  She must try to find out who it is before it’s too late!  Somewhat predictable but still entertaining and engaging. 👍
  • Incarnate (2016) – possession/supernatural. A somewhat unique twist on the genre, a brain doc frees people from possession by mind-sharing & getting the person back in control of their own consciousness.  Think Inception meets Exorcist.  Very well-acted, convincingly scary demon, and nicely twisted ending. 👍👍
  • Demonic (2015) – creepy/found-footage. Bit of a misnomer, as it has nothing to do with demons; it’s about a ghost-summoning gone horribly wrong resulting in the deaths of all but 1 (ish?) member of the group that originally attempted said ritual.  Frank Grillo is always on-point.  Very engaging. 👍
  • Last Shift (2014) – gory/creepy/demon-y. Rookie cop gets stuck with the last watch in a soon-to-be-shut-down police station, chaos ensues.  Literally, this is some crazy crap; scary and bloody.  Original & vastly under-hyped, has an indie vibe but looks & feels professional-grade. 👍👍

Most of these should be stream-able.  So check ’em out!

Now on to the SQL stuff.

A not equal a
borrowed from the man himself, Pinal Dave =)

Collations are Hard

If you ever have to integrate a vendor database into your existing environment, and the vendor ‘mandates’ their DB use a certain collation (which differs from the rest of your SQL instances / databases), run away screamingSrsly.

Or convince your managers that you know better, and force it into the same collation as everything else you have to integrate with.  Good luck & godspeed.

Let me give you an example.  The ERP system is being upgraded, which of course means a new (upgraded) DB as well.  Part of this upgrade seems to involve supporting case-sensitive searching/matching against name fields.  To this end, the vendor insists that the DB should use a case-sensitive collation, namely ​Latin1_General_100_CS_AS.  Problem is, the rest of your DB environment, in which a lot of stuff touches the ERP database (via joins, linked-server queries, etc.), uses the SQL default collation of SQL_Latin1_General_CP1_CI_AS.

If you follow the vendor’s mandate recommendation, guess what’s going to happen to your queries/views/stored-procedures that touch this & other DBs?  Horrible things.  Terrible performance degradation.  Wailing a gnashing of teeth from the developers, business users, and customers.

Okay, I exaggerate.  Slightly.

But it really does hurt performance, and I don’t feel like it’s talked about enough in the data professional community.  In the next post, I’ll take this problem apart a little more and try to impart some of what I’ve learned from going through the pain of dealing with the aforementioned example.

Happy 2018!

PS: Apparently this is my 50th post!!  Go me!  :o)

50-cent-face-on-50-dollar-bill
fiddy. fiddy posts.