what if I want the opposite effect?

I hate blur, how do I remove all of it?

Shoot at f/64

There was a whole group of people who did this, apparently.

Shoot at a higher fstop with a sensor with a high native ISO, like 12,800.

The trade off is so much noise

Focus stacking.

pinhole camera and an insane amount of light.

Or, multiple exposures and HDR.

Not sure how multiple exposures helps?

Smaller sensor, tighter aperture. So yes, more light or a more sensitive sensor.

They must mean by creating a composite image with multiple in focus areas? Otherwise I agree, I can't see anyway that multiple exposures would help, at least from some light reading on Wikipedia - https://en.wikipedia.org/wiki/Multiple_exposure