inline SQL statements
code :: nested queries in MSSQL
the world of database programming can be a dark and treacherous journey. when you first set out, your quest seems manageable. but as time progresses your start to realize you need more queries, more tables, etc, etc, to achieve your goal. well today i’m going teach you a little trick that might help you need one less stored procedure then you thought...
sometimes it’s true, you actually do need two queries to get the job done. but other times you can circumvent this by using something like a "join" or "inner join" query to merge two tables together and pull your results from both.
but the optimizer in you says that still isn’t enough...
Read: inline SQL statements »
abstract render tutorial
art :: with 3D studio max
this is a "long image" tutorial i did under my alias 0x000000 for igraphixz.com
Read: abstract render tutorial »
PQ torus knot
lab :: papervision3D math art
here we go again, another papervision3D demo featuring math permeated lines. this time im working with a classic piece of code known as the PQ torus. the vague idea is that you have 2 numbers (P + Q) that are used in the algorithm to define the knot. in general, given P + Q mutually prime, the line wraps meridionally around the torus P times and wraps the longitudinally around it Q times. i was having some trouble grasping exactly how this was going to be achieved, until i read this article on blackpawn’s website. he really breaks down the algo to a very simplistic level...
Read: PQ torus knot »
wavebubble
lab :: DIY portable RF jammer
i just got clued in on a new project from one of the members of the cDc (cult of the dead cow), a notorious hacker group from way back in the l0pht days. the wave bubble is a self-tuning, wide-bandwidth portable RF jammer. an internal lithium-ion battery provides up to 2 hours of jamming (two bands, such as cell) or 4 hours (single band, such as cordless phone, GPS, WiFi, bluetooth, etc). the battery is rechargeable via a mini-USB connector or 4mm DC jack (a common size). alternately, 3 AAA batteries may also be used. self-tuning is provided via dual PLL, therefore, no spectrum analyzer is necessary to build this jammer and a single wave bubble can jam many different frequency bands...
Read: wavebubble »
NYC
random :: photos from our trip
i was just on vacation in NYC. the crew was myself, nina, and our friend nik. nina wanted to check out fordum university, and visit our friend john who lives in yonkers. not to mention that she had never been to the big apple before. we spent four days in the city, spending 75% of our time in museums, 15% in restaurants, and the remaining 10% walking/riding public transport. but when the sun went down we had a shofar. john (aka jaze juce) is a native new yorker, who nina met at school. jaze is a rapper, a life guard, and all around man about town. we saw a lot of the city from in the car at night, which was awesome.
Read: NYC »
we went to florida
random :: mini-vacation
my grandparents moved to flordia a few years ago, and ever since, the rest of my family have slowly been moving there. my uncle mark lived there already, then my aunt joan moved there shortly after. then my cousin, then her mom... yeah, almost that entire side of the fam. so needless to say, we were due for a visit. my dad is dr. paranoia, and couldn't fly down there. and i in no way wanted to ride with him, my mother, nina and his road rage. nor did i want to drive there myself with nina and my road rage. so we opted to hop with the jet set. the flight was so short i barely beat metroid fusion on the plane ride there and back with 98% completion.
Read: we went to florida »
poultrygeist at the warhol
entertainment :: a night with lloyd kaufman
to kick off the pittsburgh zombie film festival, lloyd kaufman and the troma crew, made the venture down to the iron city to premiere their new film poultrygeist at the andy warhol museum. my buddy smitty and his girlfriend amanda decided that they would accompany nina and i. we didn't want to miss the show...