A common task that all database and system administrators face is patching systems. Patching your systems is very important -- first and foremost, security fixes are included in patches. Patches also ...

When I worked for Sybase, much of the advertising we published was based on the TPC performance benchmark figures of Sybase SQL Server compared to the competition ...

As a consultant whose job description includes putting out performance fires, I get to see a lot of problematic queries that can dramatically harm overall server performance and throughput. Wondering ...

When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...

OK, I’ll admit it. I’m not a DBA, but that doesn’t mean I haven’t overseen databases and their performance. I was (and probably still am) the guy who installed a Microsoft SQL database by hitting Next ...

A typical screen in your user interface probably combines data from several different tables. To handle that, I typically have my back-end processes generate Data Transfer Objects (DTOs) which combine ...