CRISPR/Cas9-based transcriptional activation (CRISPRa) has recently emerged as a powerful and scalable technique for systematic overexpression genetic analysis in Drosophila melanogaster We present flySAM, a potent tool for in vivo CRISPRa, which offers major improvements over existing strategies in terms of effectiveness, scalability, and ease of use. flySAM outperforms existing in vivo CRISPRa strategies and approximates phenotypes obtained using traditional Gal4-UAS overexpression. Moreover, because flySAM typically requires only a single sgRNA, it dramatically improves scalability. We use flySAM to demonstrate multiplexed CRISPRa, which has not been previously shown in vivo. In addition, we have simplified the experimental use of flySAM by creating a single vector encoding both the UAS:Cas9-activator and the sgRNA, allowing for inducible CRISPRa in a single genetic cross. flySAM will replace previous CRISPRa strategies as the basis of our growing genome-wide transgenic overexpression resource, TRiP-OE.