Access vs SQL Server: some stats (part 1)

In the perspective of upsizing my current Access 2007 application, I have been trying to understand a bit more about the possible performance impact of various choices of Primary Keys. My problem is that currently, the Access application uses autoincrement numbers as surrogate Primary Keys (PK). Since I will need to synchronise the data over... » read more

Sysadmin: SQL server performance madness

I’ve just lost 2 days going completely bananas over a performance issue that I could not explain. I’ve got this [Dell R300][1] rack server that runs Windows Server 2008 that I dedicate to running IIS and SQL Server 2008, mostly for development purposes. ![Dell PowerEdge R300 Rack servers][dellr300] In my [previous blog entry][2], I was... » read more

Access: building ‘upsizable’ applications.

When you start building an Access application, it’s tempting to just think about today’s problem and not worry at all about the future. If your application is successful, people will want more out of it and, over time, you’ll be faced with the task of moving the back-end database to a more robust system like... » read more