Recent Articles by Websolete · Page 2

DBX 10.1.12 Released

This update allows DBX to display included columns when enumerating indexes for tables. Based off the sp_helpindex2 stored procedure from http://www.sqlskills.com.

Download from dbx.riaforge.org.

Helpful Spelling Tip

Been a long time since I’ve posted, mostly since no one except spammers bother to come to the site, but I’ve finally had it and had to vent into the ether before my head explodes.

Read More…

DBX 10.1.11 Released

A bug fix and a minor change:

– fixed miscalculation of total in database/table info pane
– changed sort in extended properties tab for 2005/2008 tables/views to match the ordinal position of the column

Programmatically kill a cfthread spawned from anywhere

In certain instances where you have endlessly running/sleeping ‘monitoring’ threads, there is effectively no way to kill them short of a CF server cycle or via the CF8 server monitor.

I had this issue during development where inside an app scoped component I was creating two ‘monitor’ threads, which were charged with monitoring two separate queues, sleeping every few seconds. Whenever the app scope was reinitialized, two more threads would be created, up to the point where all threads were utilized and the app bombed due to the lingering (and idle) threads left from the previous instantiation.

Read More…

DBX 10.1.9 Released

Minor fix in this version:

– added handling for stored html content display in data sample tab