Web Software Architecture and Engineering – Life on the Bleeding Edge

Archive for November, 2008

New CF/Lucene Project – GOAT

Just saw this, looks interesting. ColdFusion and Lucene 2.4.
Check out Revorg GOAT Search Solution on RiaForge


Positive Side to the Economic Downturn

My last post was a sad one, so I thought, what’s good about all thats going on?
Well, less emails from recruiters is a big one for me. I’m getting maybe 1/10th of what I used to on a daily basis.
What do you guys see as positive?

Tis a Sad Day – Sr. CF Developer Laid Off

The situation is quite bad. I’ve worked hard over the years to build a solid team.
Over the years we’ve built complex Mach II, ColdSpring, & Reactor based ColdFusion Products in a SaaS model. I’d never want to let anyone from my team go. Unfortunately, the situation is out of my control.
On Friday, we didn’t technically layoff or fire, but “closed the position” for two of my team members. One of them was for one of the Sr. Web Developer positions, and a person I’ve know for years, and one of the nicest guys on the block (not to mention a family man). We had no choice. Our clientele, local and state governments are hard hit due to the financial crisis, and despite growing 30% per year, we had to trim because banks are tighetning up and 2009 looks bleak.
Its not a decision that came easily. I’m still stressed! If we had the money, we’d hire him back up in a second. So while this is bad news for us, it may be good news for you.
Anyone looking for someone to work remote, who is a well known CF developer and all-around great guy? I can provide more details and a strong reference. Let me know!

SQL Server Script to Find Foreign Key Dependencies

I used to be a fan of MS SQL Server 2000. It was so easy to get up and running.
But, SQL Server 2005, is another story. To do even the most basic of things, requires, extensive knowledge or ugly workarounds.
We do a lot of merge replication with SQL Server 2005. We added some tables to two-way merges, and the replication failed. as usual, it was due to foreign key dependencies. (By default, SQL Sevrer wants to drop the table, and re-create it with replication properties.)
There is no command that I know of, where you can select the PK, and say, give me all foreign keys that link to this PK. Easy enough Use Case though, right? There are some scripts out there to give similar column names, but those aren’t accurate, because they dont have a foreign key reference necessarily.
After some searching, I found this. It was everything I needed. If you guys have better scripts, do share!

select cast(f.name  as varchar(255)) as foreign_key_name
    , r.keycnt
    , cast(c.name as  varchar(255)) as foreign_table
    , cast(fc.name as varchar(255)) as  foreign_column_1
    , cast(fc2.name as varchar(255)) as foreign_column_2
    ,  cast(p.name as varchar(255)) as primary_table
    , cast(rc.name as varchar(255))  as primary_column_1
    , cast(rc2.name as varchar(255)) as  primary_column_2
    from sysobjects f
    inner join sysobjects c on  f.parent_obj = c.id
    inner join sysreferences r on f.id =  r.constid
    inner join sysobjects p on r.rkeyid = p.id
    inner  join syscolumns rc on r.rkeyid = rc.id and r.rkey1 = rc.colid
    inner  join syscolumns fc on r.fkeyid = fc.id and r.fkey1 = fc.colid
    left join  syscolumns rc2 on r.rkeyid = rc2.id and r.rkey2 = rc.colid
    left join  syscolumns fc2 on r.fkeyid = fc2.id and r.fkey2 = fc.colid
    where f.type =  'F'
 ORDER BY cast(p.name as varchar(255))