Pixel Pooper

That is a strange piece. It's an article about macro, but it doesn't have any macro images in it, and was written by someone who doesn't shoot macro. No surprise as is basically an ad for Milvus ...

They do, Touit 50mm.

"I'm so lazy, I took lessons on a player piano." - Larry Burns

The best way to learn how to use a camera is by using that camera.

The link posted above shows a DSLR's phase detect auto focus system which is nothing like the contrast detect AF system in the RX100. An AF point is a single AF detector on the dedicated AF sensor ...

You seem to have missed the point entirely. Nobody is talking about comparing your FF shot to a smaller sensor, they are talking about comparing a crop of your FF sensor to a sensor the same size ...

Not exactly current anymore...

The short answer is yes, you need a flash. Great macro shots can be achieved with natural light, but for a beginner it will be an exercise in frustration.

Do you have a source for this claim?

So the difference between A mount, E mount, EF mount, and F mount is not how the lens mounts to the camera?

The article starts with the premise that camera companies love using the phrase "professional quality construction" in their marketing, but I can't find any examples of that. The first result that ...

The noise is similar between your two pictures because they were both made from the same amount of light (same shutter speed and f/stop) . If you used a longer exposure or wider aperture to ...

A TIFF is like a super jpeg of sorts.

I would like that camera, but if it wasn't a lot cheaper than an A7RII, I would get one of those instead. Even now you can buy an A7II for less than an A6500, so an even more expensive crop camera ...

Perceptual megapixels are not the same as megapixels.

No, the lens with the larger physical aperture will blur the background more. The 30mm f/1.4 has a maximum aperture of 21mm, and the 50mm f/1.8 has a maximum aperture of 27mm, so the 50mm will ...

Eventually, but the A6500 is as close as you are likely to get for a while.

Yes. If they are shot from the same position and the 28mm shot is cropped to the same FOV as the 50mm shot, they will have the same DOF, same perspective, and same diffraction.

I think you mean virtual aperture (entrance pupil), not relative aperture (f/stop). The COC is the largest circle (on the sensor) that is perceived as a point (in the image), so it is defined by ...

Pictures taken from the same position with the same entrance pupil diameter (not relative aperture) will have the same DOF at the same field of view. In your scenario, they would have the same DOF ...