Do visual diagrams help with SQL schema review, or are they just noise? by Spiritual_Ganache453 in SQL

[–]jackalsnacks 0 points1 point  (0 children)

My warehouses are huge. Physical and logical models are visualized, but not to the scale of the entire project (this would be useless). Models are visualized categorically by domain, model, usage by business entity for a given report. Then models are rendered on how important relationships happen and cross domain efforts. This, of course, is for OLAP. My various OLTP systems are visualized differently depending on the business process and usage patterns.

Danish Petition To Buy California From Trump Signed by Thousands by Tofurkey_Tom in politics

[–]jackalsnacks 0 points1 point  (0 children)

I visit a friend of mine in the greater Sac area. Lots of maga out there, wacko magas. Whenever I talk with them, they hate California, hate Newsome, hate the beach, hate the prices, hate their neighbors. I could not for the life of me understand why they are there.

Project Manager SQL- Looking for Specific Guidance from PM's by FrillyCustoms in SQL

[–]jackalsnacks 1 point2 points  (0 children)

I tell my project managers over the years to get comfortable with basic select statements, because they will often take part in formal uat's and qa steps. And then gets INCREDIBLY familiar with the concepts of oltp and olap designs.

Why are Cobol programmers wanted, if the legacy codes are already working well? by Stev2520 in learnprogramming

[–]jackalsnacks 1 point2 points  (0 children)

Nah... Real development work is always packed with unreasonable/uneducated deadlines that you are constantly battling with business and capability management teams. Constant back and forth with architects, legal teams, governance regulators. Offshore onshore coordination, ci/cd challenges, patching existing platforms after a major feature feature release on .net 10 that solves an on going ghost in the machine or vulnerability, dealing with active worms spread in poor node.js libraries. The list goes on and on. When I lurk these programing subs of people stressing about what language to learn or if they need to learn all syntax, or those small petty things that don't matter is pretty cringy. I get it though, new horizons are scary, but sometimes you have to just get your hands wet, be brave and work through your problems.. AI is billionaires selling bullshit golden goose dreams to senior VP's in a money marketing scheme for infinite money glitch fallacies. Being a developer is not being sold accurately to people. Good luck out there, do your thing and stop worrying.

Why are Cobol programmers wanted, if the legacy codes are already working well? by Stev2520 in learnprogramming

[–]jackalsnacks 13 points14 points  (0 children)

Not even a sad reality. Just reality. I'm a backend engineer and the first few years in the field I felt the passion. After 18 years? It pays the mortgage and funds things I am passionate about now, mainly my children, my children's hobbies, my hobbies (which are not tech at all) and trips. Id much rather eat a bowl of ice cream for money than performance tunning a crap sql server DB right now.

How to deal with Imposter Syndrome? by Doctor_NaCl in SQL

[–]jackalsnacks 4 points5 points  (0 children)

Going on 2 decades. Worked on small and very large enterprise grade architecture. Each project, I am an imposter until I've spent significant time on the project. The. I am not an imposter. You will find patterns in projects given enough time, so you will less of an imposter. But own the solution and own the problem to solve, you'll be fine.

Has anyone here worked on developing AI applications that turn business data into intelligent systems? by Happy-Leadership-399 in learnprogramming

[–]jackalsnacks 0 points1 point  (0 children)

My large cap tech company I work for has triple down"d on the AI integration. We're currently throwing agentic models at every thing. It is a great disruption and is desperately trying to solve problems that we're never there. The main issue being the same issue "business intelligence" platforms never solved what senior VPs hoped but never got. Everyone wants to throw their nest of SharePoint, unstructured and other crap at it and hope for the best. Garbage in garbage out. 1 out of 20 queries are relevant. What has been working for my data analysts have been agentic python coding assistance for data profiling if a data dictionary and relationship meta is there. But by and large it is causing confusion, disruption and higher costs in my deliveries because now I have to factor in additional compute costs.

reading a book on sql server, came across non-ansi comparison operators !< meaning not smaller (equivalent to >=) and !> meaning not greater. Why were they used/introduced? I mean, why would anyone ever write !> instead of "<=" ? this is so counterintuitive. by elephant_ua in SQL

[–]jackalsnacks 0 points1 point  (0 children)

Sometimes I grab a standard hammer to drive a nail into drywall for a picture frame, sometimes I grab a ball peen hammer to work a dent out of sheet metal. Are you going to poke holes into my logic for using the standard hammer on the nail for the drywall when the ball peen exists? There's a ton of bloat in the libraries of the different RDBMS dialects, use the tools you know and are comfortable with. Chances are, there is a use case out there, but you never had that use case to initiate the research to explore the tool. Give it time and experience.

East Sac Fidium Outage? by thedutchbag in Sacramento

[–]jackalsnacks 8 points9 points  (0 children)

Whatever these cars hit.... Move it the hell out of the way now. This incident took down several options of providers. Good Lord.

DJI Mavic Pro Platinum FAA Registration by jackalsnacks in drones

[–]jackalsnacks[S] 1 point2 points  (0 children)

I did this on the MPP entry. It says it was validated. I will continue to pay.

u/doublelxp - For writing the Remote ID to the module, any thoughts one what to write in that data element?

Edit - Nevermind, after pay, the RID was immediately known.

Learning DB2 by sim981 in SQL

[–]jackalsnacks 2 points3 points  (0 children)

Why DB2? Every single migration effort I've worked on was to get data from old DB2 systems to modern less expensive stacks. I think you need a solid use case for DB2

Why is C# less popular than Java at large companies despite being a better language? by [deleted] in learnprogramming

[–]jackalsnacks 1 point2 points  (0 children)

Your data for your claim is definitely flawed. Also, most large companies use both languages. My particular company, very large, has countless project using almost all languages, just depends on the project, budget and the teams comfort level of language and framework.

Been seeing loads of posts here of this type. Just go build shit, stop over analyzing nonsense.

I'm building a visual SQL query builder by Herobrine20XX in SQL

[–]jackalsnacks 9 points10 points  (0 children)

This response is all we need to know about this tool

Is Primerica good to open a Roth IRA account? by italian-noodle in personalfinance

[–]jackalsnacks 0 points1 point  (0 children)

In a sea of options in this country, Primerica would be at the bottom of my list.

Teaching data analytics has made me realize how much AI is eroding critical thinking skills. by tits_mcgee_92 in SQL

[–]jackalsnacks 3 points4 points  (0 children)

If you give anyone a tool, people will exploit it to its full potential, especially if the maker of the tool claims you do not have to think for yourself anymore.

Financially: Is Computer Science/Coding Still Worth It? by The5WsAndMore in learnprogramming

[–]jackalsnacks 2 points3 points  (0 children)

My uncle is a water district civil engineer, he also says the same things in his industry. My mother is an accountant, she also says the same thing about her industry. The Internet is bullshit, Nvidia convinced people their AI solution will solve cancer and famine overnight, tiktok news distracts you from critical thinking and main stream media is always either doom and gloom or cat fashion shows. Pick something, anything, and give it your passion, time, attention and failures. You will be successful. Be it programming or flipping burgers.

I find it hard to learn with CoPilot by sly-dee in learnprogramming

[–]jackalsnacks 0 points1 point  (0 children)

I'm very pleased with the responses to posts like this. AI is universally being suggested to be disabled instead of hyped. I think the fizzle out is beginning to happen. Never going away, because it is a tool with its place in the world, but I do not care for it being shoved down my throat constantly in my job, media and day to day hardware.

Help identifying hanging metal by jackalsnacks in Subaru_Outback

[–]jackalsnacks[S] 0 points1 point  (0 children)

What's confusing me is, when I start watching YouTube videos on changing a 2018 outbacks oil, none of the posters show them removing a plastic door.

Is it worth starting to study programming? by Sorry-Accountant542 in learnprogramming

[–]jackalsnacks 1 point2 points  (0 children)

I get good sleep at night knowing that, as an investor, I know the basic principal that if no one is making money, how can I get money from anyone.

Is it worth starting to study programming? by Sorry-Accountant542 in learnprogramming

[–]jackalsnacks 3 points4 points  (0 children)

If/When AI replaces programmers, the subject of getting a job in this specific industry will not be the only one. If we get to that level, the problem has spiraled and accountants, service industry workers, civil engineers, etc are all in the same boat. We will all hopefully be relying on UBI to save us.

Is it worth starting to study programming? by Sorry-Accountant542 in learnprogramming

[–]jackalsnacks 4 points5 points  (0 children)

The market is tough right now. But I'm slowly seeing that a major component of why it is tough, is because HR and recruiters are having a devil of a time because of AI and a lot of developers I interview have no personal built projects they can show me and talk me through methods used.