Tuesday, 17 June 2008

Firefox 3.0 is out but impossible to download

I've been impressed with the RC releases of Firefox, and was looking forward (a little) to grabbing the final release. However, as soon as Moz posted the links their download locations were immediately overwhelmed. Now, how could they not have predicted this? Surely there are CDNs (Akamai, Limelight, Level3) out there that could have helped circumvent this. Amazon S3? Marketing did a great job of promoting the release but the dead download links must have nuked their credibility a little.

SQL Profiler & Duration - 2000 VS 2005

I'm not a DBA by any stretch, but like to think I know a thing or two when it comes to Microsoft SQL Server as I have used it extensively in just about all of my work experiences.

With that in mind, I wrote a basic insert statement wrapped in a stored procedure. Ran a load against it and watched SQL Profiler. To my surprise, the duration on the query was 64000+.

However, after a little research I found the reason. It was not query design, database schema, RAM, storage, etc. etc. but rather a change to the metric used in SQL Profiler for duration.

In the SQL Profiler that shipped SQL Server 2000, duration was recorded in milliseconds. BUT, in the SQL Profiler that shipps with SQL Server 2005 duration is recorded in microseconds. 64k microsecods worked out to about .06 seconds. I can live with that.

Here is the MSDN article that set me straight.


Friday, 6 June 2008

Amazon.com is down!

Holy crap, this can't be good! With all the redundancies Amazon.com must have in place to get a "Http/1.1 Service Unavailable" error message from their website is scary. Not to mention the oodles (yes, oodles) of apps hosted with their web services.

AWS website is down too.