I also live in the East Bay Area region and have being listening to scanners for many decades. As mmckenna stated, much has changed over the years. I'm not familiar with the SDS100 but from what I've read about it, you should be able to import and set up the EBRCS radio system for Alameda County. I use a Radio Shack 688 and did just that. If you can connect your scanner to a computer with the appropriate software, it may be a little easier to do via computer. The EBRCS system is large and quite busy. Once set up, you should hear a fair amount of traffic depending upon the talkgroups. Below is the link to the RR database for the EBRCS system. If you're between Oakland and Fremont, the ALCO Southwest will probably serve you best. If your in Dublin/Pleasanton, the ALCO East will probably be better. Again, I'm not sure how the SD100 presents the EBRCS system so you may need to experiment. I wish I could help you more with programming. If you head over to the EBRCS forum, you may be able to get help with programming your radio by a fellow SDS100 owner.
EBRCS Forum:
The EBRCS Updates thread keeps getting off-topic chatter and I don't want to delete your posts. So please use this thread to ask questions or post observations not specific to new or changes for the system. How to program your scanner for the system is not a question about the system, it's a...
forums.radioreference.com
EBRCS frequency database:
East Bay Regional Communications System (EBRCS) Trunking System Profile
www.radioreference.com
With regard to antennas, once you get the correct system for your area, you'll more than likely be able to pick up traffic especially outside. I mention outside because my house has foil backed insulation and sometimes interferes with monitoring depending upon my location in the house. On the same topic, the EBRCS system is a simulcast system. That is, the same signal is being transmitted from multiple repeater sites simultaneously and some scanners have trouble distinguishing which if those signals it should listen to. This can be a case where more isn't better and having an outside antenna creates more problems than it solves. I'm not sure how the SDS100 handles it so again, experimentation is in order. Since the EBRCS system is in the high 700Mhz range, a simple antenna need be only 3" tall or so. Try the stripped back coax as mentioned by mmckenna.