We have an app that stores documents in the database as a varbinary(max) column. Our current average document size is about 475KB, so these are not large documents by any means, but there are a fair ...

Do you have a BackupExec SQL Agent CAL? You can't (well, shouldn't) back up the MDF/LDF files directly. If you have the CAL, BackupExec will use VSS to do a snapshot and backup a consistent copy of ...

In my last blog entry, I talked about VLDBs. One of the tactics suggested was to use as many data files on as many drives as possible to give better I/O performance. This makes sense, but the usual ...

For as long as I can remember, I have always configured the computers within my own organization to store data on network servers as opposed to the data being stored on workstations. That way, if one ...