-
Defining NO ACTION foreign key constraints in Oracle
In both Oracle and Sql Server, when creating a foreign key constraint on a child table, the default option is NO ACTION, meaning that this constraint will prevent the deletion or update of a parent key if there is a row in the child table that references the key. One popular option is CASCADE, meaning…
-
DTA works against Sql Server 2000 databases
Index Tuning Wizard morphed into Database Engine Tuning Advisor (DTA) in Sql Server 2005. The idea is still the same. You feed it with some profiling results, and it will make some recommendations. Sql Server Profiler 2005 still has the same look and feel of Profiler 2000. It does have some enhancement when picking event…
-
Learn Perl through Perl debugger
I attended an introductory Perl course recently. I’ve always wanted to learn the language. It is a very powerful scripting tool with excellent regular expression support. The training delivered by Daina Pettit from LearningTree was excellent. One nugget I got out of the class, that I think is worth half of the class cost, is…
-
Messages when installing SP1 for Sql Server 2005
Service Pack 1 for Sql Server 2005 was released in April. I have installed it on quite a few systems: 32-bit, 64-bit, and 64-bit cluster. SP1 is cluster-aware, meaning that if you want to upgrade a cluster, the installation package can detect that and will apply the changes to all nodes. Of my installs, all…
-
Upsizing Access Database to Sql Server 2005
One way to convert Access database to Sql Server database is through Access’ built-in Upsizing Wizard, accessible through Tools -> Database Utilities -> Upsizing Wizard. It works both with Sql Server 2000 and Sql Server 2005. When upsizing, you are provided with basically 3 choices: converting Access database to a ADP project; converting all tables…