How to: Remove users from the ASP.Net membership database
Sunday, January 13, 2008 8:37:44 PM (GMT Standard Time, UTC+00:00)
I'm sure I've blogged about this in the past -or perhaps it's just in my "to blog about list" but I thought I would share this little ditty on the Sunday night.
If you ever need to delete a user from your ASP.Net Membership database this is a really useful SQL script to do just that (I often find that the ASP.Net web administration tool throws a SQL Exception while trying to delete a user).
To use the code to delete a user from the ASP.Net membership database simple identify the Guid of the user and enter it where I've written 'THE GUID OF THE USER HERE' and hit go :)
USE ASPNet
GODECLARE @UserId uniqueidentifierSET @UserId =
'THE GUID OF THE USER HERE'DELETE FROM aspnet_Profile
WHERE UserID =
@UserIdDELETE FROM aspnet_UsersInRoles
WHERE UserID =
@UserIdDELETE FROM aspnet_PersonalizationPerUser
WHERE UserID =
@UserIdDELETE FROM dbo
.aspnet_Membership
WHERE UserID =
@UserIdDELETE FROM aspnet_users
WHERE UserID =
@UserIdThe message I was referring to above usually looks something like the following:
Msg 547, Level 16, State 0, Line 9
The DELETE statement conflicted with the REFERENCE constraint "FK__aspnet_Us__UserI__17036CC0". The conflict occurred in database "ASPNetMemberships", table "dbo.aspnet_UsersInRoles", column 'UserId'.
The statement has been terminated.
I've not looked into why it's happening (I expect it's something to do with an incorrect install on my behalf) but I'm sure there's a solution for it. I know there are a couple of built in SQL scripts i.e. aspnet_Users_DeleteUser but they required more params to get working ;)
Registration opens for Visual Studio 2008 launch events... but the UK doesn't exist (yet!)
Thursday, January 03, 2008 2:38:19 PM (GMT Standard Time, UTC+00:00)
This mad me smile, when surfing around at lunch I stumbled across www.heroeshappenhere.com -Microsoft's Visual Studio 2008 launch site. I got all giddy with excitement, downloaded the latest version of Silverlight and woohoo -a registration link! Finally!
Sadly though, you can only register for the LA event at the moment. Check the "Outside of the US" drop down though, it'll make you smile (or at least it did me) -notice anyone missing? (Other than France that is :P)
The King Daddy of Office chairs - Herman Miller's Aeron
Wednesday, January 02, 2008 9:47:13 AM (GMT Standard Time, UTC+00:00)
If you've found this article through a Google search I expect like me you've read a plethora of articles and blog posts that vary from saying how amazing the Aeron is, to how the Aeron is an over-priced relic of the burst dot com bubble of the 90s. Well this one is my take on Herman Miller's Aeron.
Before buying my Aeron I decided to make use of Herman Miller's trial Aeron, this isn't something they make you overly aware of so if you're thinking about getting a new office chair, contact your local representative (or the Herman Miller website) and ask if you can hire one for a month. It'll cost you somewhere around £40 but it'll at least allow you to see what you're getting before outlaying £400+. The trial Aeron took a little getting used to which I've put down to the fact that my posture in the old chair was seriously bad but after a week or so I was sitting very comfortably indeed.
One of the simpler things I liked about the Aeron was the fact you can raise it up higher than many other chairs, this is important for me as my desk is 4-5 inches too high which means I'm always sitting incorrectly. By raising the Aeron up a little more I was able to sit with my arms flat on the desk reducing shoulder and back ache considerably. Another aspect of Herman Miller's Aeron chair that I liked was the fact you could adjust the resistance of the back, again a simple; but important feature, it takes a little trial and error but you can get the balance just right so it lifts you up into your position but doesn't stop you from leaning back to relax (or in my case kick back when you do something right).
Rather than having a cushioned fabric seat, the Aeron has a mesh that stretches a little to offer the same comfort padding does but without the worry that in 2 years time, the padding turns to something more like cardboard (which is one of the factors that prompted my search for a new office chair). The downside I've found with this mesh is it overly aerated which in my case means my bum is kept very cool (and back which is a good thing as sweatiness is reduced to a minimum) -great in the summer but in the winter brrrr!
The main downside to having the Aeron is the price, as I wanted a grey one, I had mine imported from the States and paid a premium but you can pick up the basic spec chair for around £400 (and probably less if you do a little bargaining), baring in mind the 12 year warranty these chairs carry it should in theory outlast 3-4 £99 type office chairs and look after your back in the meantime. Being somewhat of a scrooge, I looked at it from the POV that the difference between what I would spend on new £99 chairs in the warranty period of the Aeron would only be a matter of £200 or so which equates to around 5p per day. That's got to be worth it :)
On the whole though I really like my Herman Miller Aeron, I feel it has really helped my posture and although I didn't really suffer from back ache after a long day (probably down to my canoeing) I feel that the small investment short-term will pay off in the longer term. I consider the chair a luxury and so wouldn't splash out on it if I were a start-up as there are far more important things to get sorted first! That said, if you're planning on spending long hours in your chair from the outset maybe it is worth the expense from the start.
It's worth stating at this point that in addition to trying out the Aeron, I also tried out Herman Miller's alternative offerings and a number of alternative office chairs but I didn't find I got the same comfort.
I did a lot of shopping around for a suitably cheap(er) supplier and was surprised to find out that the supplier just down the road from me was able to offer the cheapest price by far (ignoring delivery etc) so check out Creative Box in Birmingham, Kate from Creative Box in Birmingham was more than helpful and patient in answering my 101 questions so I'm sure she'll be able to help you out too.
How is your business perceived? You'll soon find out when you break big news...
Sunday, December 30, 2007 2:13:37 PM (GMT Standard Time, UTC+00:00)
What I have found the most incredible about Stacey leaving her job to come work with me is the fact that you soon start to find out how people perceive your business. I try not to talk to people in too much depth about what's going on with The Site Doctor as generally when people ask "How's the business going?" I've realised they don't want you to reel off how much debt you're in (they're not sure whether to pity you or whether you're asking for money) -or how much money you're making (which is just seen as gloating) but with something as momentums as this people start sticking their oar in...
Although after talking it through with them people can see that it's going to make life better all round (and hopefully richer in the longer term -not just financially) the initial reaction is generally one of amazement that we'd even be considering it what with the company being so "small". People find it very hard to comprehend that although we work from an office at the back of the house, the business earns enough to support the two of us.
I realise they don't mean to be insulting in anyway and they only have our best interests at heart but sometimes the cliches rule through -I think my favourite comment was from my mother who after listening to the reasoning behind the move (which included making a saving as we won't initially need to get a larger office to accommodate the new staff) said that we would need to get an office straight away, "a flag ship office" as she put it.
A little bewildered as to why she would say such a thing her response made me smile even more "it will appear more professional to the outside world". I admit, getting an office is on the cards for next year however the fact that in the 5 years we've now been operating I know of only one occasion when we've had a client ask to come to our offices so why incur such an expense merely for show? Of course what she meant to say however was "it would appear more professional to the family" ;)
I should add at this point that I love my mother to bits but I am still astonished at the assumptions people make about a business based on what they see (rather than hear).
Britain's gone nuts
Friday, December 21, 2007 11:33:37 AM (GMT Standard Time, UTC+00:00)
I don't know when Britain decided this but it seems that every time I read the papers at the moment I read yet another absurd idea from up high but this one had me laughing so I thought I'd share:
The Justice Ministry is calling for the removal of the word "prostitute" - which has been around for almost 200 years - from criminal statutes. Ministry officials argue the word carries too much social stigma and are pushing to replace it with the phrase "persons who sell sex persistently." Try saying that with a mouthful.
Ethical Christmas Presents/Cards
Thursday, December 20, 2007 10:37:17 AM (GMT Standard Time, UTC+00:00)
Last year was the first year we sent out presents to clients and it went down a storm though choosing the presents is somewhat awkward -especially when it comes to wine, what if they're a red wine drinker or a white wine drinker etc?
Anyway I digress, as usual we've started receiving gifts from companies and as usual we've had one or two "we're not sending out cards this year, instead we're donating the money to xyz" or "we've spent the money we were going to spend on you, on a goat". A little un-PC I know but -gee thanks.
What a ridiculous thing to do, it really gets my goat (pun intended) when people do this, it's so pretentious -and doesn't impress me in the slightest, they'd be better not to bother -or- donate and not tell me. Why, instead of not spending that £1.00 on a card "saving the environment" don't you pay your bills by BACS instead? That way you would avoid sending a small cheque in a huge envelope with your complement slip etc? Surely THAT would be making more of a contribution?
All these donations to me just say "We've not got the time or inclination to get you something personal so we won't bother". Further more, Stacey and I donate to charities on a monthly basis anyway -to charities that we care about. Some of you may remember the Cheshire Ring Race we did for charity for example.
As I mentioned earlier, this year we were donated a goat -ok it's supposedly gone off to a family in Africa somewhere but quite frankly they should have saved all the donations up and gone over there and helped out, now THAT would have got my attention. Having been on a charity aid project in The Gambia myself I know that would mean a lot more to the locals than (apparently) being sent a goat.
Anyway, enough ranting, if you want a nice Christmas hamper or bottle (or two) of wine for your friends, family or client this year check out the Wine and Hamper Gift website for some ideas.
Gerald Ratner: The Rise... And Fall... And Rise Again -yet another autobiography
Tuesday, December 18, 2007 11:18:00 AM (GMT Standard Time, UTC+00:00)
I don't know whether it's just I've had my head in the sand for the past few years or whether there really is an influx of autobiographies hitting the book stores, either way after finding time to read Duncan Bannatyne's book I thought I'd try another -"Gerald Ratner: The Rise... And Fall... And Rise Again" which I only bought out of curiosity but have found to be most interesting.
I don't know why many people read these sorts of books, I guess there are some looking for that "golden ticket to the riches" but I like to find out where someone's come from and what sort of attitudes businessmen have to life. One thing is for sure is that most of them want to write books1 ;)
I realise the book is his take on the events that passed (my mother is still insistent that he MUST have said the jewellery was crap as otherwise the press wouldn't have pursued him as ferociously) but either way what I found most interesting are the values that he learnt along the way.
One can only feel sorry for what he has been through -regardless of whether he was seen to be "flash with his cash" when he had it or not (to be fair who wouldn't be if they could be), to see that he's managed to recover from it is a real achievement.
Until recently, when asked the "If you could meet one person who's alive" type question I would probably have said Peter Jones as he always came across as an entrepreneur with a little gusto and flare about him but recently -perhaps just due to the producer's discretion I've gone off that idea and would much rather share a beer with Gerald Ratner. I wish him and geraldonline.com all the success in the future.
The book is an easy read and can easily be picked up and put down as needed so if you've not had a chance to read it, pick up a copy of "Gerald Ratner: The Rise... And Fall... And Rise Again" your local book store (or Amazon if you live in the sticks!).
1 For those of you interested, I have already got my book underway, it's going to be an epic -and exciting- tale of woe about my raise to fame (and hopefully without fall...). I think I'm going to name it "Coming from nowhere to go somewhere". I wish I could say you can pre-order it somewhere but you can't -if you want a copy email me and I'll add you to the list (you'll probably be the first...)
February 8th - a date for your diary!
Monday, December 03, 2007 5:13:35 PM (GMT Standard Time, UTC+00:00)
Well it's been a hectic few days what with breaking the news to everyone and getting things in place but we've finally got Stacey's management to give her a leaving date -February 8th. It's still a fair way off but a lot better than we were expecting (sometime in March) so we can't complain.
I just hope the new office is in place in time -let alone the new website (still very much in development)!