DNS Security

One very often overlooked component in the area of enterprise security is DNS Security. DNS is one of those everyday services that is usually taken for granted.  You provide the URL to the service and it comes back with the IP address.  How complex can that get and why is security needed for DNS?