Brady was the fiancé of Ava.
Brady is with Ava in bed when she has a vision of Sam Winchester's death. Brady asks her if everything is okay. Ava replies to him that it was just a nightmare.
Later, when Sam and Dean arrive at Ava's house, they find Brady dead in the bedroom. Traces of sulfur are found along the ledge of the window, proving that the demons had been here. On the foot of the bed, Sam finds Ava's engagement ring.
Five months later, Sam is forced to tell Ava of Brady's murder.
His death was later avenged when Dean killed Azazel.