Any proper projective birational morphism $f:X\to Y$ between varieties is the blowup of some sheaf of ideals $I$ on $Y$, so you can see that anything can happen.