SQL Server: Query to Find Upcoming birthdays for Current Week

A common query, for Human Resource databases or different social sites is to find out employee/subscribers name who’s birthday is coming in near future i.e. (In current week, or in next given days).