3D Software
How to Make a Seamless Texture in Photoshop
Make a photo tile without seams in Photoshop: crop, Offset with Wrap Around, paint out the seams and test it. Plus fixes when Offset won't wrap.
Tutorial hub
Textures tutorials
Free seamless textures, PBR maps and material workflows for renders.