Sorry dude…writing simple queries is what I said was easy…and for the record they are. That example is probably not a great example. Simply from my experience, I never started my career in IT, I was in healthcare and far from it all.

Anyway, I’ve had some idiots approach me about their shitty ideas before too…most notably was one person asking to create an app that “uses AI” to help a person search for the right individual when they send a text message. Couldn’t explain how it would know that it found the right person? There was another one that wanted to track the origin of “content” and how it changes over time on social media… again “using AI”.

For my team I have a mirror that I set up and have a bunch of ELT jobs that load the deltas every night. Queries don’t ever run in PROD, if someone needs a specific view or more data, they go through me and my team. I also set timeouts, precisely to avoid the ahole from using Select * from. Also have a bunch of reports I created to see who is running what queries and timings. We review them quarterly or when someone complains or when a project that needs our data asks us for access.

We also have an autogenerated data dictionary for folks to use as well. Generally I don’t entertain any “it’s slow” complaints unless they go through the documentation, provide their exact query and write what it is they’re trying to get.

My assumption was that OPs shop does the bare minimum in terms of making sure they don’t shoot themselves in the foot.

Ooof my guy if you got folks running queries on your PROD db you got bigger problems even if they were the best SQL writers in the world.

You can’t fuck up step 1 and complain the rest of the steps aren’t working. I write and maintain a set of ELT jobs and a bunch of front end dashboards. By default, we never run analytics queries in PROD db. I create views and such for the simple queries to run.

I picked up SQL a few years ago for a school project. It took me a week. The DBA stuff just came by itself as I went along. Query optimizations took a while but you don’t need to write every query super optimally. If the DB tables are set up correctly your users will not have to worry about it at all.

My previous comment assumes you guys already have a db set up for analytics where folks can run queries. If you don’t then IDK how the director of IT got their job…That’s very basic shit.

SQL isn’t hard to learn unless they’re asking you guys to do T-SQL and PLSQL.

For simple queries it’s pretty easy.

How many years of experience did you need to get that job?

That’s good what’s your title?

I’m a level 2 Engineer and I make close to what you’re making TC. Hopefully maybe more come next year. And I don’t work for the big 5. I work for a hospital group. Seniors make well close to double that in TC. Principals make slightly more.

Also there are more jobs for higher levels than in non tech hubs. Career wise you’ll probably be making more complex systems too.

You have it good for sure, but you’re the outlier my guy.

What’s your title?

Hmmm you’re not going to be making 150k a year in a shit fly over state.

I moved from the Bay Area to the East side of Washington near Seattle, folks here don’t make as much as I do for sure, at least not on average. We both have good salaries so we can afford a lot of things. We essentially got to keep most of our bay area salaries.

But even then if we need a big repair we still have to sit down and plan out the money.

I can’t even imagine what it’s like for folks around here.

At a coarse level, children from families with more money are better off so I disagree

And that seems like a correction that needs to happen.

I think of this daycare idea like public school, you ever notice the high income rich areas have a good public school system whereas the low income don’t?

If you’re on the whole okay with a certain percent of kids failing then on the coarse level it does seem like a good idea.

As opposed to now? That’s literally what happens here, no one wants any of these old fucks’ laws. They were born when the first plane was taking off and haven’t kept to date with anything in the modern world. We have no choice because the only people who seem to have any time to do anything in this country are the old people. Therefore we get shit on for simply trying to exist.

Hmmm I’d like to stay at home and I’m the man. We both earn about the same, she earns more. I don’t trust daycare workers. You optimize for what you value, if you value economics you’re simply not going to optimize for what’s best for the child. Because at all the cross roads where the biological needs or psychological needs conflict the economical value you’ll not be making those choices.

Yeah if you can just take your opinion and shove it up your arse. That’d be great.

So they can’t sue you after the crash cuz no one survives it.

They’ll probably have kamikaze mode for when it detects a crash about to happen it speeds up.

This sounds like an interesting project, what programming language did you use? Was the endpoint relative to the person making the query, how was the data stored?

Seems all the problems in this country can be traced back to that fuck.

Kavanaugh was probably getting boofed by DuPont, hopefully with some pfas.

States rights people really confused prolly.

Haha thanks for the good chuckle

This brings back some nightmares. Once I get them working I never upgrade or even look at them.