The psychological profile that the FBI agent gives for the "serial killer", is a completely accurate, fairly insightful description of Detective McNulty.
Officer Bobby Brown (played by Bobby Brown) is wearing a T-shirt from the video he directed titled "Off The Chain."