Goto Schad's and buy the Channel master 4228 or email Chris (see above) for a quote. It isn't D*'s fault you can't get KTVU. They are denying waivers to all households in their DMA regardless of weather you can receive it or not. You can probably pull it in OTA with a high gain outdoor antennae.
I am unclear what the business strategy is to deny an alternative source of a signal to folks who cannot receive the signal by other means than satellite, but hey, it's not my business. US Air didn't learn from it's two bankrupcies, so let's not expect KTVU to either.
KCRA from Sacramento is similarly denying waivers to folks out in Livermore who can't get any HD NBC OTA due to the mountains. They are screwed since they are in overlapping markets and need two waivers (KNTV is very cool about it) It is perfectly legal under the new satellite bill for them to be spoilsports.
Lots more details about this on yahoo group shown above.
In the big Comcast vs. D* question, after trailing in service for a long time, Comcast now has more SF HD locals for the moment by 2 and yes HD-DVR but the pendulum will swing back in about 6 months when their new satellites are live and they are offering $200 credit a HD-Tivo you purchase and will soon probably offer it for rental as well. A small price to pay to avoid ever needing to deal with Comcast's very poor telephone service and installer crews (IMHO). D*'s service has been great and easy to use so far for me and I got everything installed on first trip. Meanwhile after 5 trips to Foster City, my mom's Comcast service is still barely functional. She still can't get KRON to watch the news at 5pm. This with SD cable.
The new trick is the super secret internet cable infrastructure upgrades that mean her neighborhood has no cable internet all day, then when I call, they say Oh yeah, we are doing scheduled service in your area: I asked if I could find out a schedule and they said, No we don't make it available to customers, just call if you have no service and see if the recorded message includes your area Well I did , and the recorder is broken. The lady apologized, said she worked out of Denver and couldn't help me any further. This went on for weeks before Xmas (no online shopping or travel arrangements for her) and still is on now. I asked for a service credit for the month, they gave her 3 days, $4.10. Apparently I should have complained daily to prove I had no service to earn 1 month of credit.
Okay, so now do you remember why you dumped Comcast service?