December 2006 Blog Posts
In the normal course of events the statistics for SubText are kept up to date; but if you're messing around with the database they can get out of whack. In order to recalculate everything you can run the following SQL commands.set nocount ondeclare @Id intdeclare @BlogId intdeclare @EntryId intdeclare entries cursor fast_forward for select Id, BlogId from subtext_Content
open entriesfetch next from entries into@Id, @BlogIdwhile @@fetch_status = 0begin execute subtext_UpdateFeedbackCount @BlogId, @EntryId fetch next from entries into @Id, @BlogIdendclose entriesdeallocate entries
If you're reading this then the DNS update has happened and you're viewing my new host and my new blog. As you can see it's not the old software which was held together with sticky tape and string and was entirely my own work. I'm now running Subtext, an asp.net open source blogging solution branched from .Text and now mutated beyond belief. Now all I need to do is apply the categories to every post and make sure no images have broken. If you're seeing 404 errors, my apologies, I've tried to automate the procedure and redirect, but I may...
So Ben Hall tagged me with the latest blog me, appealing to my ego by calling me a "great presenter". Which mollified me somewhat; as I'd seen other people I know not tag me. That's the problem with these memes it reminds me of gym where you're chosen last (no offense Ben!)
So let's see;
I'm adopted; a certain person keeps saying that my parents got me from the pound. I have no real interest in tracing my biological parents but it did cause problems when I was getting security cleared for the Foreign Office; three months into...
Finally, an easy way to script databases beyond just the schema scripting the database tools provide. The wizard is part of the SQL Server Hosting Toolkit. It would be too much to hope that some hosting companies will roll it out and drop the cost of having a hosted SQL server. Why is SQL hosting so damned expensive?
SQL Server Database Publishing Wizard enables the deployment of SQL Server databases into a hosted environment on either a SQL Server 2000 or 2005 server. It generates a single SQL script file which can be used to recreate a database (both schema...
So yesterday Sarah appeared on the Scoble Show talking about the girl geek dinners and geeks versus nerds. Whilst I wasn't expecting podtech to have bothered supporting the Zune just yet I had expected them to at least support Windows. They don't; they only provide MPEG4 videos files which Windows doesn't support (well Vista Ultimate does apparently, but until Toshiba provide drivers for my laptop Vista isn't touching my machine). I attempted to install ffdshow which provides DirectShow filters to Windows Media Player but everytime I tried to play the file I got errors. Then I remember the installation dialog...
So the Channel9 camera made an appearance again in the UK, this time at DDD4 and yes, being the media whore that I am, I appeared, this time with Sarah to keep me in check [watch]....
Well in check up until the poor MS guys got called away and we "borrowed" the camera...
Video: DDD4 : "Borrowing the C9 Camera"
A slightly more relaxed Developer Day yesterday, with calming blue speaker polo shirts. This time I covered "Security ASP.NET Applications and Communications" which attempted to give an overview of ASP.NET's security model, guide the choices made when choosing authentication and authorisation strategies, a brief look at how to secure communications between tears and some how tos supporting the options I had covered previously. The slides and notes are available.
I ended up with a full session, with a couple of people sitting on the floor at the sides of the room, always quite intimidating and ego boasting at the same time....
Ok, so the title is an exaggeration, but I'm a hit slut and want more people to click. One of my complaints about the Zune software was the length of time it takes to scan the device when you plug it in; you have to wait for a few minutes to rebuild its database of tracks on the desktop before you can start to delete things. On Thursday that stopped working. When I browsed to the artist list on the device I saw 3 artists. When I looked at albums I saw a grand total of 8 albums, by those...
Dear Zune Marketing,
Thank you for attempting to brand device to device transfer of music as "squirting". It enables me to make a number of smutty jokes and encourages school boy humour.
Yours, Barry.
So anyway Dinner #9 of the London Girl Geek Dinners was on Wednesday in a very noisy Balls Bothers in London. The speakers were Mary Sharoe, talking about how to survive as a woman in the geek world (despite being an honourary girl at these events I felt that one didn't apply to me <g>), Nicholas Anpazis on Feeds 2.0 (yummy, an RSS aggregator that learns and recommends; except...