SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

SQL Musings

Add to Technorati Favorites Add to Google
Author Bio
Steve Jones Editor at SQLServerCentral.com You can follow Steve on Twitter as way0utwest (www.twitter.com/way0utwest)
Browse by Tag : hobbies (RSS)

Stupid Coding Tricks

By Steve Jones in SQL Musings | 12-11-2008 9:12 AM | Categories: Filed under: , ,
Rating: (not yet rated) Rate this |  Discuss | 2,130 Reads | 85 Reads in Last 30 Days |3 comment(s)

Can anyone here write a SQL statement that generates a Mandelbrot Set? I’m sure a few of you can, and if you want to try, please do so, but it’s something that I’m not particularly good at. I used to like solving problems like this in coding when I was a student, but now I know I can do many of them, and so it’s not really something that excites me.

However I do appreciate the effort and intelligence that goes into writing code like this. Over at TheDailyWTF, there is a post on someone generating a Mandelbrot Set in T-SQL. It’s a fairly short, single T-SQL command with a CTE that’s less than 50 lines.

If you want to see the results in notepad, here’s what they look like:

Give it a try if you like challenges, or view the code here.


Kindle Part 2

By Steve Jones in SQL Musings | 05-28-2008 10:13 AM | Categories: Filed under: , ,
Rating: (not yet rated) Rate this |  Discuss | 2,429 Reads | 112 Reads in Last 30 Days

Or maybe part 3, depending.

 Amazon reduced the cost of the Kindle yesterday. It's $40 off, a 10% discount, down to $359 from $399 and that's tempting. I've got some Amazon credits, about $100, and since I could conceivably deduct this as a business expense, review it for the site, I'm very tempted. If I had $200 in credits it would be a no brainer.

 I found this very interesting review from a book lover. It mirrors a lot of what I think about the Kindle and how I would use it. This was the first review to talk about how easy it is to hold and read with the device. I'll admit that flipping from left to right with a paperback gets tough on my arms, and at night. I find myself shifting positions every minute or so to read the other page when I'd like to have the ability to keep reading the left side or right side only. It might be nice as well when I'm with a kid or someone and don't have two hands free.

I saw a post from Geekbrief on someone that keeps little around. It struck a chord with me since I have lots of books, so many that the shelves are overflowing, and lots of DVDs as well, but it I could go with less, I would.  I like re-reading some at times, the last two years I've re-read perhaps 20-30 books from the shelf, but I'm a content person. I like the content, but I don't need to have them all around. I used to, and perhaps would like a library, but it's an extravangance I don't "need."

 The other thing that struck me is on our trip this past weekend, I took 4 books, plus one in the car that is almost done. I found myself looking for books a few times or regretting that I didn't have a particular book with me. I also left one book at home that I wish I'd brought.

I'm getting close, and I'm not sure I'd save a lot waiting until Christmas for the Kindle. I think I'll give it a month to see if I get any more Amazon referrals and make any more $$.