Project Base

AKA Plan b

A digital communication and data storage and syncing device in tablet form to allow a digital whiteboard like interface with layers and blending and spline masks etc. Video and audio playback and recording, color grading, EQing, etc.

Posted on the go.

I’m not insane…

So much of this testing structure matches the mvc pattern. It’s cool to hear other aspects of this pattern. I think that a lot of the cowboys have left the field, and a lot of people who are serious about what they do are on the rise. Perhaps there will come a time when computer science is taken more seriously by other engineering fields.

Posted on the go.

Debian multi-arch – beware

Sounds a little alarmist, I know, but yes beware. The thing is, I don’t want to install 64-bit arch on machines that have less than 4 GB of RAM. It doesn’t make sense. Not only is the execution theoretically marginally slower, the files also take up more space. When building virtual machines, it begins to make even more sense to install 32-bit.

Debian’s new fangled (probably been out for a while now) multi-arch installer will install a 64-bit OS if the CPU supports it. So beware. Either download the 32-bit installer or perhaps there is some switch to force the multi-arch installer to install a certain arch. I don’t want a multi-arch CD laying around. The risk of installing the wrong arch is too great.

It’s good I noticed before putting this server into production. (Goes off to install 32-bit Debian…)

search MS SQL stored procedures

Trying to make sense of an overgrown undocumented database and how various departments use it can be almost impossible. One thing I’ve found possible is searching SPs:

1
2
3
4
5
6
select o.type_desc as routine_type,
o.[name] as routine_name,
m.definition as routine_definition
from sys.sql_modules as m
inner join sys.objects as o on m.object_id = o.object_id
where m.definition like '%string%'
select o.type_desc as routine_type,
o.[name] as routine_name,
m.definition as routine_definition
from sys.sql_modules as m
inner join sys.objects as o on m.object_id = o.object_id
where m.definition like '%string%'

Thanks to Brad