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.