Does anyone have any ideas or links to tutorials in creating moving sand. I know a few solutions but they involve purchasing third party plug-ins (Particle Bundle). Also, the grains of sand needs to be hi-res.
You can use usual Particles. There are many tutorials about this. For each particle you can assign shape and material, as you like. You can make animation for Particles, as you like. I think, with particles is possible to make an excellent sand.