What can DNA tell you about a crime?

DNA is often held as the gold standard for evidence at a crime scene. But what can forensic genetics really tell us, and what is just crime drama fiction?