Many companies now have a requirement to keep data for long periods of time. While this data does have to be available if requested, it usually does not need to be accessible by the application for any current transactions. Data that falls into this category are a good candidate for archival.  Read more...

Today Steve Jones talks about some of the issues with keeping data around a long time and a new archival medium.  Read more...

It seems that archival isn't on the mind of most designers when they first build a database, which is OK, but DBAs ought to be building skills to implement this if the data size grows large.  Read more...

This Friday Steve Jones explores archived data. Can you restate past results or change old data? This week Steve Jones asks how data professionals feel about this and what guidance they give to their customers.  Read more...

This function will return a string in sortable format YYYYMMDD-hhmmssnnn to append to file names for archiving.  Read more...