Understanding the circumgalactic medium–the gaseous halo surrounding a galaxy, is an integral part to understanding galaxy evolution. The z ~ 2-3 universe is interesting as this is when the star formation rate and AGN activity peak. My work concludes the decade-long Quasars Probing Quasars survey designed for studying massive galaxy formation and quasar feedback. I use background quasar sightlines that pass close to foreground quasars to study the circumgalactic medium of quasar-host galaxies in absorption. My sample of 149 quasar pairs involve spectra taken with 17 different optical and near IR instruments. I present results on the statistical and physical properties of the quasar circumgalactic medium. My results pose challenges for cosmological hydrodynamic simulations to produce a substantial cool gas reservoir surrounding quasars, that is also enriched and exhibits extreme kinematics.

I will discuss other science goals that can be facilitated using the spectral databases and absorption-line analysis tools built. If there is interest, I will show preliminary results on a peculiar tidal disruption event and evidence for deep internal mixing in red giants.