Gauge theories, D-branes and holography