-
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…
-
Disable simple file sharing in Windows XP
Simple file sharing means that when you go to a property page of a folder, you will not see the Security and Sharing tabs. This is the default for Windows XP if the machine is not part of a domain. This can be problematic, because you cannot add specific users and groups to access a…