Which famous detective is connected with it in stories and movies?

Sherlock Holmes is the famous detective connected with Scotland Yard in stories and movies.