-
Migrating from one RDBMS to another
Here is some of my thoughts on migrating MySQL to Sql Server. It came out of an email discussion. I’d love to hear your thoughts on migrating to a different database platform, not just MySQL to Sql Server. I actually thought about writing a white paper or even a course on migrating from MySQL to…
-
TableDiff in Sql Server 2005
TableDiff is a great tool to compare the content of tables with the same structure. It is part of replication tools, but can be used for other purposes as well. This is the requirement of the tool, as spelled out in this error message: The replication table difference tool requires the comparison tables/views to have…
-
Logo programming fun
My son had the idea, and I just implemented it in Logo. It’s been really fun. We learned typing, math, geometry, and all that together without even knowing it. We did it on Ubuntu with KTurtle. By the way, it looks KTurtle’s Logo implementation is not consistent with documentations found in other sites. The next…
-
Big Security Token cache affects performance of Sql Server 2005
I recently came across a Sql Server performance problem. It was caused by TokenAndPermUserStore taking too much of cache. Server specifications: Windows 2003 R2 SP2 Enterprise b4-bit, Sql Server 2005 Enterprise 64-bit SP2, 2 Quad-Core Dell server with 32 gig of memory Symptoms that I have experienced: 1. Over time, the application got timeout messages.…
-
Script all jobs out in Sql Server 2005
In Sql Server 2000, there is an option to script out all jobs in an instance. That option disappeared in Sql Server 2005. You can still do it. In Object Explorer, click on Jobs folder. Then go to the Object Explorer Details window. All jobs in this instance will be listed there. Select all, and…