After years of frustrating aquarium photos, I scoured the internet for advice, bought a rubber lens hood for my 24-70mm 2.8 lens, and set everything to manual. And frankly, I think I did pretty well for a first real go at photographing fishes.
Full set is here.