This study advances alkali-activated cementitious materials (AACMs) by developing a ground-granulated blast furnace slag/high-calcium fly ash (GGBS/HCFA) composite that incorporates Tuokexun desert sand and by establishing a clear linkage between activator chemistry, mix proportions, curing regimen, and microstructural mechanisms. The innovation lies in valorizing industrial by-products and desert sand while systematically optimizing the aqueous glass modulus, alkali equivalent, HCFA dosage, and curing temperature/time, and coupling mechanical testing with XRD/FTIR/SEM to reveal performance-structure relationships under thermal and chemical attacks. The optimized binder (aqueous glass modulus 1.2, alkali equivalent 6%, and HCFA 20%) achieved 28-day compressive and flexural strengths of 52.8 MPa and 9.5 MPa, respectively; increasing HCFA beyond 20% reduced compressive strength, while flexural strength peaked at 20%. The preferred curing condition was 70 degrees C for 12 h. Characterization showed C-(A)-S-H as the dominant gel; elevated temperature led to its decomposition, acid exposure produced abundant CaSO4, and NaOH exposure formed N-A-S-H, each correlating with strength loss. Quantitatively, acid resistance was weaker than alkali resistance and both deteriorated with concentration: in H2SO4, 28-day mass loss rose from 1.22% to 4.16%, with compressive/flexural strength retention dropping to 75.2%, 71.2%, 63.4%, and 57.4% and 65.3%, 61.6%, 58.9%, and 49.5%, respectively; in NaOH (0.2/0.5/0.8/1.0 mol/L), 28-day mass change was +0.74%, +0.88%, -1.85%, and -2.06%, compressive strength declined in all cases (smallest drop 7.77% at 0.2 mol/L), and flexural strength increased at lower alkalinity, consistent with a pore-filling micro-densification effect before gel dissolution/cracking dominates. Practically, the recommended mix and curing window deliver structural-grade performance while improving high-temperature and acid/alkali resistance relative to non-optimized formulations, offering a scalable, lower-carbon route to utilize regional desert sand and industrial wastes in durable cementitious applications.