Pythonista; Celerista; Pyramista; Plonista; Magentoasta; Javascriptista; CSSista; HTMLista; Webista; Shellista; you get the gista.
Stack Overflow
Q&A for professional and enthusiast programmers
English Language & Usage
Q&A for linguists, etymologists, and serious English language enthusiasts
Programmers
Q&A for professional programmers interested in conceptual questions about software development
Unix & Linux
Q&A for users of Linux, FreeBSD and other Un*x-like operating systems.
Musical Practice & Performance
Q&A for musicians, students, and enthusiasts
Programming Puzzles & Code Golf
Q&A for programming puzzle enthusiasts and code golfers
Motor Vehicle Maintenance & Repair
Q&A for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles
Meta Stack Overflow
Q&A for meta-discussion of the Stack Exchange family of Q&A websites
Area 51
Stack Exchange Network staging zone, where users come together to build new Q&A sites
English Language Learners
Q&A for speakers of other languages learning English
Server Fault
Q&A for professional system and network administrators
Parenting
Q&A for parents, grandparents, nannies and others with a parenting role
Mathematics
Q&A for people studying math at any level and professionals in related fields
Science Fiction & Fantasy
Q&A for science fiction and fantasy enthusiasts
Ask Different
Q&A for power users of Apple hardware and software
Physics
Q&A for active researchers, academics and students of physics
Electrical Engineering
Q&A for electronics and electrical engineering professionals, students, and enthusiasts
Game Development
Q&A for professional and independent game developers
User Experience
Q&A for user experience researchers and experts
Academia
Q&A for academics and those enrolled in higher education
Chinese Language & Usage
Q&A for students, teachers, and linguists wanting to discuss the finer points of the Chinese language
Answers OnStartups
Q&A for entrepreneurs looking to start or run a new business
Christianity
Q&A for committed Christians, experts in Christianity and those interested in learning more
The Workplace
Q&A for members of the workforce navigating the professional setting