Archive for April, 2007

Removing the Time from SQL SERVER datetime

April 25, 2007

Just discovered a new trick, one that speeds up my SQL. I often use datetime columns and hate the SQL Server format where all dates include the time, which results in date conversion or bizarre arithmetics. Here ‘s a nice solution


RETURN CAST( FLOOR( CAST( @d AS INTEGER) ) AS DATETIME )

What does it do? The cast/floor/cast trio pushes the internal datetime to a float, then removes the decimal part and converts it back to a datetime, as the time portion of the datetime datatype in SQL server is stored in the decimal places of a float equivalent type, then converting to an integer removes them and sets the date to midnight.

tlbox – tools for programmers

April 25, 2007

This is a nice utility meta-library with some neat features, very simple design, you basically add the tools to your toolbox, essentially bookmarking them (and with community voting features). Doesn’t yet have a way for a tool developer to link to the tlbox though through an ‘add me to your tlbox’ which would close the loop on the whole thing.

All the same very very nice little utility. (thanks for the tipoff Matt)

Using HTTP caching to improve performance

April 17, 2007

This Article from the BetterExplained blog is a pretty nice explanation of how to configure your server for better performance by using cache headers. Which complements nicely the article on Varnish I was just reading.

Caching is a great example of the ubiquitous time-space tradeoff in programming. You can save time by using space to store results.

SaveNetRadio – sign the petition

April 17, 2007

Streaming radio is under threat, as I was previously DJ’ing on freeradiosf, I think this is important. please sign the petition

Article on Pandora blog.

Hi, it’s Tim from Pandora,

I’m writing today to ask for your help. The survival of Pandora and all of Internet radio is in jeopardy because of a recent decision by the Copyright Royalty Board in Washington, DC to almost triple the licensing fees for Internet radio sites like Pandora. The new royalty rates are irrationally high, more than four times what satellite radio pays, and broadcast radio doesn’t pay these at all. Left unchanged, these new royalties will kill every Internet radio site, including Pandora.

In response to these new and unfair fees, we have formed the SaveNetRadio Coalition, a group that includes listeners, artists, labels and webcasters. I hope that you will consider joining us.

Please sign our petition urging your Congressional representative to act to save Internet radio: it’s here

Please feel free to forward this link/email to your friends – the more petitioners we can get, the better.

Understand that we are fully supportive of paying royalties to the artists whose music we play, and have done so since our inception. As a former touring musician myself, I’m no stranger to the challenges facing working musicians. The issue we have with the recent ruling is that it puts the cost o streaming far out of the range of ANY webcaster’s business potential.

I hope you’ll take just a few minutes to sign our petition – it WILL make a difference. As a young industry, we do not have the lobbying power of the RIAA. You, our listeners, are by far our biggest and most influential allies.

As always, and now more than ever, thank you for your support.

tim_signature.jpg
-Tim Westergren
(Pandora founder)

links for 2007-04-14

April 14, 2007