Great editorial. When I applied to the position where I am working now, they had a HUGE list of "requirements". It turns out, they weren't looking for someone with all of them, it was ANY of them. Had it been a query, the bullet points would have said OR instead of AND.

In order to specialize, you need some foundation of general knowledge to specialize on. If we're talking SQL Server, how many SSIS gurus can't write basic stored procedures? If you're looking for an equivalent position, yes it is rare that your unique combination of experience and specialization is what a particular company is looking for. I've noticed that as well. If you're willing to take something less specialized, then there are usually positions available albeit at lower pay. It's always worthwhile to be flexible.