Query your SQL Server Error Log

Often the things I post about are the items that I am using that day, or recently. Many of the topics, are simply based on how I may have made using SQL Server a bit easier for me to use one way or another. In another SQL Server Error Log post I had mentioned a few of...

Test That Database Backup

Are you testing your database backups, If so how? Sure there are a couple options that you can use to help validate backups but does this mean you are 100% sure, without a doubt, that it can be restored? Have you ever seen a backup file not restore? Recently I was...
Informix Extents: Sizing and Performance

Informix Extents: Sizing and Performance

When tuning performance for an IBM Informix instance, one important issue to look for is the presence of tables and indexes containing a large number of extents.  Today’s high speed disks and SSD drives can mask some of the performance hit, making this an area...

Delivering Your Enterprise: Freshness

This article is part of an ongoing series. See the blog entry Delivering Your Enterprise: The ilities for an overall discussion. I’m about to give away one of my secrets. I probably shouldn’t, but as long as you promise to not tell anyone else, I’ll...