I am not monetizing my SQL-writing abilities properly
@Shauna GM Holy crap, that's what you call "extraction"!
@shauna Suddenly /way/ more interested in the “become a consultant/freelancer” job option, if one gets to charge those kinds of numbers! 🤯 (this is /mostly/ tongue in cheek)
@bitprophet @shauna I believe that it is possible to change that much. I also believe you would need a client as ... free with cash as SBF to pull it off.
@zrail @shauna Yea, I can't imagine that is exactly the average, still funny though
@zrail @bitprophet @shauna There's some solid freelance business advice in this.

@zrail @bitprophet @shauna I charged over $400/hour, about 15 years ago, so $720/hour is entirely plausible.

A lot of that time was going over old emails from my standards group and filtering / classifying them for relevance to the case, some hours consulting with (educating, basically) lawyers about the technology in question, and as it turned out, when trial time came they didn't have enough time to put me on the stand.

@shauna I am not monetizing anything properly (this is true with or without the above context, but also not sure I’d rather write SQL queries all day)
@gordoooo_z I'd write SQL queries all day if you paid me $720 an hour
@shauna @gordoooo_z i will write them in a box, i will write them with a fox / i will write them to your specs (cold hard cash, no pers'nal checks)
@nickzoic @shauna @gordoooo_z there is nothing more relaxing than writing SQL queries. Very relaxing for $750 per hour
@blueorangeblue
But you will always have the sword of Damocles called performance above you. 😉
@nickzoic @shauna @gordoooo_z
@Mr_GHARice @nickzoic @shauna @gordoooo_z consultants don't need to worry about that ;)
@Mr_GHARice @blueorangeblue @nickzoic @shauna Exactly. This is why I use NoSQL databases for all my business applications, namely massive Excel spreadsheets with horrifying formulae, unparseable by any sane human with a self-preservation instinct.

This is what we in the business call Job Security 😉
@shauna I'd probably write them for like... some number of hours a week at that rate, and then spend the rest of the time living life. Or maybe I'd do a week of full time SQL queries a month. Get it all out at once, y'know?

@shauna I'd even write *good* SQL queries for $720/hour.

Wait, I already do write good SQL queries for a lot less than that...

@shauna
"Can you craft SQL Queries?"
"Yes."
"What is your connection to this case?"
"Provider=postgresql;server=123.124.135.391;port=5432..."

@glenatron

Glad I wasn’t drinking tea at the moment I read this!

😙 👌

@shauna

@shauna

Gee, If I could create SQL queries to extract blockchain from AWS, that should be worth more I think. Maybe working at Chainalysis.

@kwerb

@shauna @lisamelton damn, where do I sign up for this? I’ll gladly make $720 an hour to write SQL queries.
@shauna These rates only apply to the SELECT few.
@shauna The jobs, are out there but you need to know WHERE.
@shauna The rest of us would probably make more by joining a UNION.
@shauna ... alright, I'm done.
@glenatron @shauna Good, because I was going to READPAST the rest.
@glenatron @shauna
Did you mean by JOINing a UNION?
@glenatron @shauna This is usually the CASE, unless you're in a DISTINCT INNER GROUP.

@shauna I don't "craft" SQL queries, I inspire, develop and nurture SQL queries. I take the essence of the query and ruminate on the deeper truth of the concept of the query the joins, the nested sub-selects and to garnish I will union the lot... I should point out I am being silly here but will probably get copied onto linked in...

So was 70 hours him writing the sql or the DB providing it or both ?

@shauna What does 70 hours worth of SQL even look like?
@shauna
SELECT me
FROM candidate.pool
WHERE rate>=720
@shauna daaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaang

@shauna

Fuck! That guy’s rate is outrageous.

@mirabilos @shauna Sometimes, it actually is possible to get rich with honest work <3
@shauna Surely, that's a typo, right? It has to be $72 instead of $720, right? Otherwise, that means he gets around $100k a month writing SQL, that's insane
@Varpie I'm sure it's true (he's under oath!) but as a contractor he's not working 40 hours a week, 52 weeks a year. I don't know what his breakdown of billable hours is, I'm sure he's making an absurd amount of money from this, but it's probably not 720*40*4.25
@shauna True, but he also says he worked 70 hours on it, which isn't a small task either. That's already around $50k, which is 2/3 of the median American yearly salary...

@Varpie @shauna wait until you find out what the lawyers are getting paid/hour.

(If $720/hour is his regular consulting rate, not his expert witness rate, that *is* rather high.)

@shauna Wow. Just wow. I never got more than $300/hr for expert witness work.
@fuzzychef How does one even become an expert witness? It does seem stressful and like it would be worth a premium over just knowing how to use SQL

@shauna Connections, mostly? I got my gigs because I used to work on legal services software.

There's overhead, though. Like: I had to sign an agreement twice that any leaking of case data, either intentionally or unintentionally, was a felony. In perpetuity.

So, like, I have 2 dead laptops I can't throw away, because I can't be sure the data is erased.

@shauna ... and the hearings themselves will really make you extremely cynical about our whole system.

Like, I'll never forget the case where I testified, with empircal evidence, that the plaintiff falsified their data. They were even fined for perjury. They won the case anyway.

@shauna I'll also say that the high hourly rate usually encompasses a LOT of calls and email comms you can't bill for. This dude seems to have deeper-pocketed clients than most.

And the trial appearances, of course, are boring as all-get-out. Of course, I can tolerate a lot of boredom for $10/minute.

@fuzzychef @shauna Wouldn't it be possible to use the same secure destruction services the DoD uses (that presumably fulfills due care)?

At this point keeping them in perpetuity adds a burglary risk.

@lispi314 @shauna $$$$$

If I ever do one of those again, I'll make sure that paying for the secure destruction is in my contract.

@shauna I just use pg_dump and grab it all. Second monification starts from the question "so, what's in this".
@shauna I concur. I'd like that.