-
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…
-
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…
-
Co-writing a book on Sql Server 2005 admin
I am co-writing another book on Sql Server 2005. This book will focus on administration. I’ve been busy with a lot of technical work lately, and will not post as often as before. Long time readers know that I co-wrote a book on Sql Server Integration Services. It has brought me fame from all over…
-
Using up and down arrow to cycle through sql command
Like osql, if you use up and down arrow, sqlcmd will cycle through sql statements you ran earlier. This can be handy. You can also invoke your editor for command editing, as I discussed here.