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.
   

Nullable DateTimePicker

The DateTimePicker winform control in .NET v1.1 doesn't accept null value, so I surf and find this replacement:

Nullable DateTimePicker
http://www.codeguru.com/Csharp/Csharp/cs_controls/custom/article.php/c9645/

So far it works fine, in general.
As it's written in C#, I have to compile it to class library for my VB.NET project.