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 animation exporter for 3ds Max, since 3ds Max uses plugins extensively, many […]
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 abused by hackers. Y’see, hackers find ways to manipulate games by simulating the behavior […]
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 procedure if it already exists if exists ( select * from sys.objects where name = N’p_MyProc’ and […]
