November 19, 2004
deleting duplicates (more)
here's a version uses a self join, on a derivative table instead of a view... this example uses "mytableid" to distinguish records (by adding a index there) - but you might have used "mydatefield" in a similar manner (assuming the date field differentiates the records, and you adjust the comparisons around accordingly).
November 17, 2004
3d maps: add contour to usgs images
you can project usgs topo and aerial images onto 3d contours using 3dem, from Visualization Software. first, you have to download the terrain data in a dem (digital elevation model) sdts (spacial data transfer standard), or srtm (shuttle radar topography mission) file manually, for the area you want to render.
  portland, sdts contour w/ usgs images. |
asp.net error CS1595
i got "Compiler Error Message: CS1595" after making a simple change in my project.
there's an msdn article on this error - however - it didn't help... something else caused the error...
November 15, 2004
HBH-35 charging issues
after about 2 months of not using (or charging) my HBH-35 headset, it stopped working.
i went to charge it and the led flickered intermittently, orange -- not red or green (both simultaneously? appears that way, seems to be the first thing that happens during power-up, on a working model).
read more...November 12, 2004
installing mappoint over a network
you can't just run setup.exe over a network share... if you don't run setup from the local cd, here is what you need to do...
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/mappoint2004/BIZDeployMPOverNetwork.asp
November 09, 2004
sql job accounts and sqlagent
the user (or security context) a sql job runs under varies based on how the job is launched. meaning you might have tested everything, and it's all working fine - only to find your scheduled task fails (with something along the lines of 'access denied').
read more...maintenance plan, error 5070
i got an error while executing a database maintenance plan. looking into it closer, revealed that the plan was performing an integrity check with the repair option set.
read more...binary files differ, vss file types
visual source safe doesn't always recognize text file types properly. when checking-in files using 'auto' type -- it treats them as binary.
read more...November 06, 2004
sony rmr-d100, fuse replacement
i got the rmr-d100 to use as a spdif interface (for my sony pcm-m1 dat). i've stopped using it more or less - since a simple cable from core audio works really well (easy to carry too). really, i only tend to archive my dat recordings to disk - had i known the cable would have done the job, i might have just stuck with the $40 cable. it's a much cheaper option. *however* the rmr-d100 does properly convert the 3.3 volts supplied by the dat, to the full 5 volt spdif standard, and it's two-way as well if you need that. (though, there are two-way cables).
anyway, i was a little surprised when one day the rmr-d100 just didn't work, wouldn't turn on (of course just when needed it, this was before i got the cable). anyway, like everything else i own, i decided to take it apart and take a look inside.
read more...November 04, 2004
the election
i can't believe people are so blind. it's the lack of education in our country. you voted for bush? yes, you are just a tool. this has been a very bad week for human rights. and the people who voted for it, have no idea.
i voted for kerry, i think he would have made a great president.
by the way, 51 to 48% is not a mandate. why are republicans so pompous?
November 01, 2004
enterprise mananger taskpad view error
i get the following error sometimes when i click on a database in Enterprise Manager in Task Pad View:
Internet Explorer Script Error
Line: 307
Char: 2
Error: Unspecified Error
Code: 0
URL: res://C:\Program%20Files\Microsoft%20SQL%20Server\80
\Tools\Binn\Resources\1033\sqlmmc.rll/Tabs.html
Do you want to continue running scripts?
Yes|No
This is a problem with Enterprise manager gui... read more...