FFClickOnce :: Firefox Add-ons

Just wondering why the ClickOnce deployment fail in Firefox.

M$ was saying that ClickOnce only run on IE in MSDN.

Here is a nice plug-in for Running ClickOnce app in Firefox:
FFClickOnce :: Firefox Add-ons

VS IDE bug?

It seems the VS2005 IDE is still not quite stable...and not quite responsive too.

Row Number Transformation

Here is a Row Number Transformation component of SSIS
http://www.sqlis.com/93.aspx

It's great, just fit my needs.
I suppose SSIS should provide this component...

Performance of SSIS Package

I think I need to study Database Tuning later... when I have time.

Recently I'm doing a Data Conversion project.
There are around 1.x million history records storing in 70+ VFP tables (1 table for each month).
I've made a looping package (it's new, great job M$!) to import such tables.
But the performance of the package is just bullshit.

Well, I guess the bottleneck is on VFP side (maybe VFP OleDB Provider, or File I/O of such VFP files (.dbf, .fpt ...).

SSIS IDE bug...?

Recently I am studying SSIS for my project.
I was stuck at some points while importing data from a VFP table.

The Execute Package Utility kept saying that there is a Truncation Error.
After spending for the whole afternoon, I got it...

It is because the IDE (VS2005) didn't always refresh the length of my source columns.

SSIS Home: SQL Server Integration Service
http://msdn2.microsoft.com/en-us/library/ms141026.aspx

well, I will patch my VS2005 up to SP1...soon

DB Designer 4 - a Powerful Database Tool

Recently I am studying a "legacy" system and founding some tools to grab its database schema.
Well, I found, on my friend's blog last year...
Ken Choy Professional Edition: DB Designer 4

It is just great to have such tool.
It supports both forward and reverse engineering.

Thanks to the Open-Source community again!

Indexed View in SQL2K

It seems the usage of Indexed View is limited...to data warehouse only?
Mostly I am dealing with OLTP...

I wanna use index to boost my system, but it seems indexed view will slow down the performance.

some readings:
http://www.databasejournal.com/features/mssql/article.php/2119721
http://www.sqlteam.com/item.asp?ItemID=1015

System Table in SQL2K

It's interesting to have an "system" table declaring itself as a user table in the ANSI INFORMATION_SCHEMA views.

This message pointed out the findings while checking the system table "dtproperties"
microsoft.public.sqlserver.security | Google Groups

Restarting my pro blog

hello to the new blogger.com

I plan to blog again.
It seems the blogger does improve...

during the past year, there are several changes hit me much.

1. I was once away from development jobs.
2. I was jumping from in-house IT to software house.
3. I was leaving my lovely colleagues
   
4. I was off working on time before but now I kept working OT every day.