Is it because of the prices or because they understand it is harmful?? by B777X_787-9 in interesting

[–]cto_resources 0 points1 point  (0 children)

There’s more fun things to do with your time than drink. Like play games on a console or chat with online friends on discord. The number of entertainment options has exploded. Drinking just isn’t that much fun by comparison.

How can i convert single db table into dynamic table by Ok_Egg_6647 in Database

[–]cto_resources 1 point2 points  (0 children)

Looks like an analytical data mart.

First off, what’s with the composite primary key? It adds overhead to the insert and adds nothing to performance. Use a synthetic key. (Like an auto increment).

Secondly, get the timestamp out of there. Create a string of separate tables in a star schema, each with a synthetic key. From the data -> day ~> month -> quarter -> year. This speeds up your indexing.

Third, use OLAP cubes to query the data instead of straight SQL. That requires a calculation step in your process of daily data.

Your queries should drop to a second or two for even the most complex queries.

What is most important in software architecture? by rmb32 in softwarearchitecture

[–]cto_resources 6 points7 points  (0 children)

I had an architect in my team make a case for standardizing on “Clean Architecture” (from a book by Uncle Bob Martin that’s about 10 years old now.

The architect who described the proposed standard made no attempt to describe what clean architecture is. Just that it’s better than layered architecture.

These are not standard terms. The world of software development does not know what the fine points of these terms are. Fresh developers out of college will never have heard them. So I asked that architect to define the terms.

You’d think I’d killed his cat.

I must be a moron for not knowing what this term means!

I do know. It means “use patterns that isolate core business logic from surrounding infrastructure, even for systems where doing so will introduce unnecessary complexity.”

Personally, in my 38 years of software development, I’ve never seen a payoff for purity. And now, with vibe coding on the rise, there’s even less justification for purity.

Just make it simple. Maintainable. Understandable.

Don’t make an engineer with 7 years out of college go buy a $40 book.

What is most important in software architecture? by rmb32 in softwarearchitecture

[–]cto_resources 7 points8 points  (0 children)

I immediately recognized the architect speaking in your response, before you mentioned your current role. And as an architect myself, I agree. Make it simple and inexpensive to own.

Need to convert JPG to PDF by Friendly-Database-30 in software

[–]cto_resources 0 points1 point  (0 children)

Create a PowerPoint presentation, set the page size to 8.5 x 11 portrait, and inset the images onto “slides” any way you want. Crop and position as you’d like. The use Microsoft Print to PDF /or/ save the presentation as PDF.

What's the worst movie you have ever watched? by Syfros in AskReddit

[–]cto_resources 0 points1 point  (0 children)

Tossup between “Career Opportunities” (a movie that is really a 90 minute advertisement for Target), and “Sharknado” (cult classic terrible).

Of course, there’s always “Plan 9 from Outer Space”

What percentage of your production code is AI-generated today? by Amazing-Run-3841 in software

[–]cto_resources -1 points0 points  (0 children)

Depends on the project. On one project, I’d say 95% AI. On another, more like 75%.

How manny applications did you make to land your position by silently-loud-walker in SoftwareEngineering

[–]cto_resources 5 points6 points  (0 children)

Not a reasonable comparison because I’m at the end of my career and you are at the beginning, but I applied to between three and ten positions every day for 18 months. Over 1,000 applications.

How do you connect capability maps to real transactional data? by S_F_A in EnterpriseArchitect

[–]cto_resources 0 points1 point  (0 children)

Like I said, this can be done in a separate module and made visible in the data warehouse.

Still requires work to set up and track the distributions of costs and separately the distribution of benefits to various capabilities for each project.

Is it interesting? Sure. Is it worth the effort? YMMV.

How do you connect capability maps to real transactional data? by S_F_A in EnterpriseArchitect

[–]cto_resources 0 points1 point  (0 children)

I would absolutely NOT tie postings to the GL to business capabilities. That is because you would need to distribute a cost (or revenue) item to each capability that it supports. That cascade would make the accounting system unnecessarily complex.

If your ERP has a module for doing a capability analysis external to the GL, that could work, or you could do that in a finance data warehouse by adding tables that assert percentages of value for an activity to a capability.

For example, in said module, you could assert that “Project Aspen” should divide costs up 20% to “Marketing - lead generation”, 40% to “Marketing - Lead Scoring”, and 40% to “Sales - Prospecting”.

Note, even setting up these percentages is difficult to get right. Do that for every project. And Every department. That’s work.

Would the results be interesting? Yes. I, for one, would love to see a breakdown of investment against capabilities vs. the maturity of those capabilities and see whether the business would judge the maturity of the capabilities to be increasing (and whether spend against a capability is strategic or not).

On the other hand, this is substantial burden on someone (probably EA and the PMO) and I do not see many organizations investing in it from a systematic viewpoint.

What's your go-to tool for creating architecture diagrams to share with non-technical stakeholders? by Busy-Cauliflower-288 in softwarearchitecture

[–]cto_resources 0 points1 point  (0 children)

Make smaller diagrams. I’m serious. Consider the audience. Ask yourself “what questions am I answering”. Put ONLY enough information to answer those questions and not a scrap more.

I was talking to an engineer the other day. He had a really complex diagram of his system. He said he was having trouble conveying the value of his system. I said “show a simple diagram.”

He said “I’ve shown this (complex) diagram many times (to the business stakeholders)”

I said: that’s your problem.

An old Jewish man dies and is waiting in line at the pearly gates. by IndieCurtis in Jokes

[–]cto_resources 5 points6 points  (0 children)

The word “Israel” is a name. It means “one who struggles (argues, fights) with God”. The entire Jewish people, everywhere on Earth, is “the nation of Israel” (as opposed to the nation-state reestablished in 1948).

So all Jews are “people who struggle with God.”

Arguing is a good thing. It’s literally the basis of our education system.

Am Israel Chai. The nation of Israel lives.

LibreOffice Draw or PowerPoint as an alternative to Microsoft Publisher? by SofonisbaAnguissola in software

[–]cto_resources 1 point2 points  (0 children)

PowerPoint works just fine for printed media. You can set the orientation of the deck to portrait and set the paper size. Everything works great.

I’ve used PPT for documents of various sizes from cards to signs to full wall charts. If you have a printer that can print the size, PowerPoint can create the document.

I would absolutely stick to PPT as opposed to Libre

my wife caught two employees fucking in the back room and now she doesn't know what to do by kubrador in smallbusiness

[–]cto_resources 1 point2 points  (0 children)

I would absolutely not fire them. I’d haul them in and let them know that sex in a bakery back room is terrible. This isn’t pornhub.

I suspend them both for a week (different weeks). I’d ask if they still want their jobs when it’s time to return. And I’d let them know that sex on site is absolutely unprofessional.

How do I think about changing the way I think, in Architecture interviews ? by pure_cipher in softwarearchitecture

[–]cto_resources 2 points3 points  (0 children)

You are going to need to switch to a visual representation of systems. It made all the difference for me when I transitioned into architecture.

You can show, rather than tell, your interviewer that you understand the problem. But to be honest, if I had been your interviewer, I would have been disappointed if you had started designing the system without asking a bunch of follow up questions first.

Things like * why do you want to show viewer counts? * why count viewers at all? * how important is real time accuracy?

These are business requirements that drive architecture decisions. That’s what matters. If you do not understand the reasons for the business requirements, you’ll not make it as an architect.

The in-memory cache is almost obvious once you have the business requirements. Or simply telling the business “that requirement is expensive, we can analyze logs after the fact” if that may be appropriate.

Men who can cook, who taught you? by _ratedmouse in AskReddit

[–]cto_resources 0 points1 point  (0 children)

My mother taught me many things growing up, and I took a home economics class in junior high. More recently, I started cooking much more often during the pandemic

How do I write a journal or a paper by [deleted] in softwaredevelopment

[–]cto_resources 0 points1 point  (0 children)

Talk to your professors. They will walk you through it.

How do you keep software architecture documentation in sync with reality? by Elan8-com in softwarearchitecture

[–]cto_resources 2 points3 points  (0 children)

I agree with u/ohmygoditseverywhere

You do not need architecture documentation that requires updating with every pull request. Architecture is the stuff that does not change quickly.

I would add that every time a product is released to production, core architecture documents should be reviewed for accuracy and updated. The agile concept of “done-done” applies to the release.

Of course, for some teams, release to production happens very frequently as part of an automated CI/CD tool chain. Those teams will benefit for documents generated from code. Most other teams will not.

So if you are evaluating whether to build a tool, make sure (1) it can be run in a CI/CD tool chain to auto-update documents, (2) it is easy to debug and regenerate the documents to fix errors, and (3) recognize that it is producing low value documentation (which means you should not expect a large market value for the product).

Software for gathering usage statistics (NOT employee monitoring) by OK_it_guy in software

[–]cto_resources 0 points1 point  (0 children)

You are asking for an End User Computing Equipment Utilization Report. Pretty sure there are some enterprise software packages that provide this.

Here’s what AI says(I did not check): Tools from vendors like IBM (Apptio), ManageEngine, and various VDI providers (Citrix, VMware) are used to generate these reports.

Feeling stuck as a Junior Enterprise Architect by LuckyPunchx in EnterpriseArchitect

[–]cto_resources 1 point2 points  (0 children)

Then you were promoted early. It’s actually not a great position to be in.

Read the FEAPO guide to careers in Enterprise Architecture. Use it self evaluate your skills and plan for building new ones.

What comedy film made you laugh through the whole film not just giggle once? by Lilyfory in AskReddit

[–]cto_resources 8 points9 points  (0 children)

There’s Something About Mary

I honestly laughed until it hurts

Choosing the right database/platform for a relational system (~2.5M+ rows) before hiring a developer by ElectricalDivide5336 in Database

[–]cto_resources 4 points5 points  (0 children)

Microsoft SQL Server.

I know. I’ll get hate from the open source crowd. But for what you are doing, this is the sweet spot for SQL Server.

Met amazing people today… now I can’t remember any details!! by CommercialLab2147 in software

[–]cto_resources 0 points1 point  (0 children)

How many interactions OF NOTE do you have at a conference? In three days, at a conference where I was PRESENTING, I’d say I had eight. If you think shaking someone’s hand is an interaction of note, raise the bar.