WonderCon fb gallery now up – it’s just the preview set, unprocessed and rough – http://on.fb.me/fGNquu #wondercon

• 

Facebook users are now able to opt out of receiving Group chat messages. That option does in fact exist, accessible via the “Edit Settings” button on the group’s page.

Although Facebook’s addition of a more sophisticated Groups has added some beneficial privacy features, there have been numerous complaints, particularly when it comes to email and chat notifications. While the ability to send chat messages to any online group member might be great in some circumstances, as Group Chat allows any member to send messages to everyone in the group who’s online, clearly there can be some problems.

• 

I did not realise that declared variables in SQL are effectively “static” when used in rowsets. That is, the following code:

create table roles(role nvarchar(50))
GO
insert roles
select ‘Administrator’ union
select ‘Editor’ union
select ‘User’
go

declare @roles nvarchar(1024)
select @roles = isnull(@roles + ‘, ‘, ”) + role from roles
select @roles
go

drop table roles
go

yeilds “Administrator, Editor, User“.

Now instead of returning rowset of roles for a user and then concatenating results in client-side code, I can just write a function similar to:

create function fnGetUserRoleVerbose(@userid int, @delim nvarchar(2) = ‘, ‘)
returns nvarchar(1024)
as
begin
declare @role nvarchar(1024)

select
@role = isnull(@role + @delim, ”) + roles.name
from
users
inner join users_roles
on users.id = userid
inner join roles
on roleid = roles.id
where
users.id = @userid

return @role
end

and then just do this:

string roles = (string) SqlHelper.ExecuteScalar(
myConnectionString,
CommandType.Text,
string.Format(“select dbo.fnGetUserRoleVerbose({0}, default)”, userId));

• 

select top 1 * from mytable order by newid()

It just works.

• 

Natural redheads are easy to spot but hard to emulate: they generally have blue, green or hazel eyes and a creamy, milky-white complexion that’s not often found in nature (at least not in an era of sunless spray tanning). Others have freckles that make them look eternally youthful, although finding a perfectly matched foundation can be difficult. These beauty tips will help you on your quest to find the best makeup colors for red hair, whether yours is natural or (most likely) not. Try on the best makeup for red hair in our virtual makeup studio.

“If you’re a natural red head (a fiery temptress if you will) you embody the true meaning of rare beauty. Less than 5% of the human population is born with red hair. The rest of us are totally faux.”

If you have freckles, don’t erase, embrace! Foundation is designed to even out your skin tone, not erase all character from your face, so opt for a sheer or medium-coverage foundation or tinted moisturizer for the most natural-looking result. Because redheads tend to have sensitive skin that is prone to redness, steer clear of pink-based foundations—yellow and gold tones are so much more flattering. You simply want to warm up your look and you can also do this with a dusting of light bronzer and apricot or peach blush (again, stay away from pink).

When selecting your eye makeup color palette, think warm, autumnal colors: olive green, chestnut, caramel, honey, and burnt raisin all look fierce on redheads, while pink and blue eye shadows don’t flatter an ultra pale complexion. Swap black mascara and black eye liner (they’re too harsh, at least for daytime) for a rusty brown, especially if you have hazel or green eyes.

• 

Muggle Quidditch is a co-ed sport based on Quidditch. It is popular with fans of the novels, fictional sports aficionados, and children. In Muggle Quidditch, as in Wizard Quidditch there are four positions on a team. Due to the fact that Wizarding Quidditch is based on fictional devices and concepts such as magic, Muggle Quidditch has been adapted for play on the ground, with game play confined to a playing field comparable in size to a football pitch.

•