SQL Server 2000 Performance Tuning

I recently looked at an underperformaing 32-bit SQL Server 2000 server recently, and had to come up with some suggestions as to how performance could be increased. Surprisingly the ‘best practice’ guides for this version of SQL Server were hard to come by, and quite often refered to facilities only available in SQL Server 2005 [...]

Should I migrate from Sybase to SQL Server?

I’m giving a presentation this weekend at SQL CodeCamp about Sybase to SQL Server migrations. I’ve been looking into the background of Sybase in order to give reasons ‘why’ you should do it, and found that as with all technologies there are passionate supporters.
Sybase ASE is a good product from what I can tell. I [...]