-
Toy with Sploggers w/ Dynamic Images
Over at my second home, I talked about how to annoy sploggers w/ a dynamic image. A dynamic image is merely any image generated programmatically at request time. So with a dynamic image, you have total control of the content that will get displayed when the url gets requested.
Typically, when a splogger copies a blog post, they often times leave all the original hyperlinks and images links intact. Sploggers are lazy folks. If they are too lazy to write their own blog post, they are usually too lazy to edit yours. So if they do hotlink to an image...
-
Building A Perfect Beast
I recently started the process of building a new machine. Vista has shipped, along with a new Adobe Creative Suite 3, Microsoft Office 2007, and since new and improved CPU cycle sapping – "productivity enhancers" are on the way (Orcas and Katmai) it's time to upgrade. My old AGP based, AMD socket 939 motherboard, with DDR 400 memory and IDE drives doesn't feel fast anymore. My Xbox 360 currently smokes my PC as a game machine at the moment. It felt like a new chapter in the never ending war between Gate's Law and Moore's Law (right now I'd say...
-
Is there a better way to compute a Median in SQL?
I'm currently playing with random ideas I have for Nimitz (aka the next version of my NWMLS search tool), and one of the things I'm thinking about is displaying the Median value of properties that match an arbitrary search criteria. I already do something similar to this now on Zearch (the current version of my NWMLS search tool). with MIN, MAX, and AVG. So I wrote a Stored Proc (using MS SQL 2005 features), and came up with the following. (FYI - I was inspired by this blog post).
1: CREATE PROC [dbo].[GetMedian]
2:...