One of the problems I've experienced using third-party DLLs is the way that they handle new and delete for C++ classes, which can lead to memory leaks or even memory corruption. This was a particular problem when developing the Guild Wars model and … [Continue reading]
Using transaction rate-limiting to improve service reliability
November 4, 2011 by 8 Comments
I develop and publish multiplayer games for a living, and have discovered some useful solutions for running reliable online services. The one I'm writing about today is how to implement reasonable usage limits so that services are less likely to be … [Continue reading]
A better way to update SQL stored procedures
October 30, 2011 by 9 Comments
A common pattern to manage SQL stored procedures is to drop the current procedure and recreate it. Unfortunately, this doesn't work if you're trying to run a high-availability service. Here's the (broken) drop+create pattern: -- Delete the stored … [Continue reading]
