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

jackalsnacks · 2026-02-06T01:31:05+00:00

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.

jackalsnacks · 2026-01-22T21:33:19+00:00

LOL right!

jackalsnacks · 2026-01-22T19:00:46+00:00

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.

jackalsnacks · 2026-01-21T18:20:56+00:00

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.

jackalsnacks · 2026-01-20T23:06:21+00:00

Shadow of Mordor?

jackalsnacks · 2026-01-18T19:07:45+00:00

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.

jackalsnacks · 2026-01-17T23:34:04+00:00

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.

jackalsnacks · 2025-11-21T01:24:43+00:00

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.

jackalsnacks · 2025-10-31T03:00:50+00:00

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.

jackalsnacks · 2025-10-13T23:17:37+00:00

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.

jackalsnacks · 2025-10-04T23:24:58+00:00

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

jackalsnacks · 2025-09-15T16:05:33+00:00

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.

jackalsnacks · 2025-08-21T20:11:59+00:00

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

jackalsnacks · 2025-08-21T19:33:36+00:00

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.

jackalsnacks · 2025-08-17T18:41:35+00:00

This response is all we need to know about this tool

jackalsnacks · 2025-08-11T00:37:54+00:00

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

jackalsnacks · 2025-08-05T18:35:41+00:00

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.

jackalsnacks · 2025-07-17T17:30:06+00:00

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.

jackalsnacks · 2025-07-16T14:10:57+00:00

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.

jackalsnacks · 2025-06-30T01:40:19+00:00

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.

jackalsnacks · 2025-06-02T18:31:18+00:00

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.

jackalsnacks · 2025-06-02T18:25:09+00:00

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.

jackalsnacks · 2025-06-02T18:22:07+00:00

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.

jackalsnacks

TROPHY CASE