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, ...

While working with SQL Server databases, if you often find the database performance sluggish, it could be due to bad coding of procedures or incorrectly set database variables. Here's a tool that can ...

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 ...

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 ...

I have users complaining about slow performance in one of our internal applications. The application is, essentially, a front end to a SQL database. We've built a new server for it because the old one ...