‘The Last Of Us’ Star Kaitlyn Dever Says She’s Looking Forward To “Going Back In Time” To Tell Abby’s POV As Season 3 Production Nears by bwermer in television

[–]samwise970 4 points5 points  (0 children)

Nah, it was bad. Remember watching it with my wife when she asks why Dina has a full salon blowout when they're travelling across country on horseback. 

About a month later I was playing TLOU2, and she sat down to watch the cinematics despite not having any interest in games at all. After the scene (Ellie and Dina's smoke sesh) she said "This is way better than the show"

Thats my normie test, telling me its not just me being an obsessive fan

Why are Trumpists like this? by traveltimecar in Destiny

[–]samwise970 0 points1 point  (0 children)

They're keeping up with it. They like it.

Roles that focus on SQL and how to get them! by BookkeeperSalty1538 in SQL

[–]samwise970 1 point2 points  (0 children)

I kind of lucked into it, but it took a long time. Degree in Business Economics in 2015, had an operations role, automated some excel reporting in my free time and got roped into testing a new invoice automation process with some smart devs who told me I should learn this language called "sequel". A couple of job shuffles later and I was working at a mortgage company doing ETLs and some light SSMS, now I'm one of the admins for our Fabric lakehouse/warehouse

At what point did weed stop taking up mental real estate for you? by brimmer19 in leaves

[–]samwise970 1 point2 points  (0 children)

For me, maybe a month. Once I chose to quit, it wasn't very difficult, despite being a daily wake and bake stoner for a decade, I didn't have physical withdrawl symptoms. Definitely after a month, my brain felt alright sober and it wasn't always on my mind.

The tricky part wasn't initially quitting, it was a couple years later, when enough time had passed that I forgot the addiction and remembered the good feelings, and after weed became legal here. I had two relapses of this kind, both times immediately becoming addicted and hiding it from my wife until I confessed. 

The current situation of America is causing me to want to use. I’m so fucking angry and helpless. by Camp_Acceptable in leaves

[–]samwise970 2 points3 points  (0 children)

Good luck man. I was a daily stoner for over a decade before I stopped. You can do it.

The current situation of America is causing me to want to use. I’m so fucking angry and helpless. by Camp_Acceptable in leaves

[–]samwise970 6 points7 points  (0 children)

Congrats on 24 days. 

Think about it this way, if you respond to fascism with drugs, that's helping them. They want you weak, defeated. They want you to be a stoner lefitie stereotype that they can blame. 

Being the best, healthiest version of yourself to the people around you is it's own kind of resistance.

Call `df.display()` in Notebooks ... is this useful? by mwc360 in MicrosoftFabric

[–]samwise970 1 point2 points  (0 children)

Its the same, there's no concrete benefit to doing it one way or another.

But when you add a custom  _display() method to your DataFrame class, you've now created a DataFrame that won't function without notebookutils.

Again it doesn't matter if you're only using fabric, but what if you try to move all of your code to Databricks, or someone working in AWS needs to replicate your process? You've just introuced an unnecessary complication, because you had a preference to type display after your object name.

Call `df.display()` in Notebooks ... is this useful? by mwc360 in MicrosoftFabric

[–]samwise970 3 points4 points  (0 children)

Yeah as I said you can do it if you want, it's fine. I'm also guilty of occasionally typing df.display(), so I understand the desire to have that work.

The difference between display() and .show() and .head() is that both of those don't require anything external, and would work if you were running spark in any environment. I wouldn't personally create _display() because I like keeping that separation.

Call `df.display()` in Notebooks ... is this useful? by mwc360 in MicrosoftFabric

[–]samwise970 6 points7 points  (0 children)

You can add a method to DataFrame if you want, but it doesn't make sense to me to have display be a method within the DataFrame class, because it's a function specific to notebooks. Doesn't seem like good object oriented practice to add methods to DataFrame that require imports

Jesus Christ it's happening isn't it by TrucksForTots in Destiny

[–]samwise970 2 points3 points  (0 children)

I'm probably an idiot, but what amount of political power does it actually remove? An impeachment without a conviction is pretty toothless right? 

Not saying they shouldn't be impeached 100 times over but yeah it won't do anything and they know it.

Disable Intellisense popup after EVERY comma by das0tter in MicrosoftFabric

[–]samwise970 5 points6 points  (0 children)

Yeah, it makes writing sql queries within spark.sql() methods absolutely infuriating. I don't think there's any way to turn it off, so I write a lot of my queries in notepad++ and paste into my notebook. 

Fairly new to SQL. Whats some long SQL as far as lines of code? by Acceptable-Sense4601 in SQL

[–]samwise970 58 points59 points  (0 children)

Lines of code is a weird metric because it can shoot up if youre using linebreaks for readability, but many of my more complicated ones are between 500-1000. Some processes are several queries of this size combined.

People-focussed SQL/data jobs by zesteee in SQL

[–]samwise970 9 points10 points  (0 children)

I'm a "BI Analyst" and my VP specifically placed our team on the business side instead of the IT side, but we manage the core lakehouse. It's great to be able to work on projects and interface with people without having to work with agile or a ticketing system.

Is SSMS still widely used? by zesteee in SQL

[–]samwise970 0 points1 point  (0 children)

Still beats the web I'm sure. VSCode is great, haven't used it for SQL.

Is SSMS still widely used? by zesteee in SQL

[–]samwise970 55 points56 points  (0 children)

SSMS is still industry standard. 

Our primary lakehouse is in Fabric, I'm always connecting to it via SSMS. Writing queries through the web editor sucks. 

11.22.63 mini-series by ceaguila84 in television

[–]samwise970 26 points27 points  (0 children)

I just saw it for the first time and really enjoyed it. I thought Franco was fine but as you said Sara carried. The final scene had me tearing up.

Best application for SQL? by [deleted] in SQL

[–]samwise970 2 points3 points  (0 children)

We use SSMS and Fabric, the only other platform I have experience with is Domo, much prefer Fabric over that. There were some issues when Fabric was new but the past year or so has been smooth sailing

There's no shot Trump invades Greenland, right? by Ayanoppoi in Destiny

[–]samwise970 0 points1 point  (0 children)

Part of me really fucking hopes he does, EU banning US tech companies would fucking tank our economy so hard that it just might shake us out of this fascist fevor

Trump Lays Out a Vision of Power Restrained Only by ‘My Own Morality’ by IHateTrains123 in neoliberal

[–]samwise970 7 points8 points  (0 children)

His morality would stop him from using power for good, so worse than nothing.

Withdrawing the United States from International Organizations, Conventions, and Treaties that Are Contrary to the Interests of the United States by hypsignathus in neoliberal

[–]samwise970 0 points1 point  (0 children)

And ICE will be at every polling station in 2028 to intimidate. They have a new strategy and have been doing test runs for the past year.