New articles posted.

My article Single User Performance of SQLite v SQL Server was posted yesterday on SQLServerCentral. This one does a comparison of the performance of the python implementation of SQLite and SQL Server under single user scenarios. It also touches on some interesting performance aspects of primary keys that I came across while writing the article.

Some of the commenters have pointed out that this is a somewhat “apples-to-oranges” comparison, and they have a fair point. Still, I occasionally run into cases where both are valid choices so I thought it worth writing about. One comment mentioned that SQL SE would be a more valid comparison, so I may do a brief follow up when I get a chance.