(Greg Robidoux) There is one task I hope you never face: May you never have to recreate data at different points in time in order to unfold a suspicious act or uncover lost or stolen data. Most databases store data at a core data level, which reveals only the most recent state of the data to the end
Other News
Semantic Wikis and Disaster Relief Operations
(Soenke Ziesche) Access to timely information is critical for relief operations in emergency situations. Over the last years social-networking web systems, such as wikis, have become more and more sophisticated and can also be applied fruitfully in humanitarian information management. However, a maj
Does XLOCK always prevent reads by others?
(Louis Davidson) I was going back through my files of draft blogs for the past 6 months (particularly looking for things that are wrong in my book,) and I found this one that covers something that I found really fascinating.) In this thread, a person was attempting to create a pessimistic lock by a
Upcoming innotop features
(Xaprb) It’s been a while since I released an update to the innotop InnoDB and MySQL monitor, but I have not been idle. I’m currently working hard to add major new features and functionality.
Index Build strategy in SQL Server – Part 2: Offline, Parallel, No Partitioning (Non stats plan (no histogram))
When histogram is not available (for example when we building an index on a view) we can’t use the same methods as described in previous post (For statistics gathering, it is possible only for ‘real’ object. We are building index on view, so index does not exist at this point and we are not able to
XSL transformation of SpreadsheetML to HTML — Part 1
(Muthu Kumar Arjunan) This article explains how a generic xml file(generated from a Spreadsheet ML document) can be converted to a HTML table that could be displayed in a browser using XSLT and styled using CSS.
Getting to know the Atom Publishing Protocol, Part 3: Introducing the Apache Abdera project
(James Snell) Earlier articles in this series provided an overview of the Atom Publishing Protocol and described the various ways it is being utilized in real world applications. This article begins to demonstrate how you can start to implement Atom-enabled applications using a new open-source proje
Hackers in your Database
(Steve Callan) Tinker, Tailor, Soldier, Spy comes to mind when the subject of database security comes up. How would you know if there was a mole in your database? A mole, in this context, refers to a malicious user who has hacked Oracle objects to cover his tracks, and much like the mole in John le
Importing extra columns as null values
(Maria Anderson) We are migrating our Oracle database to a new environment. There are some custom tables which are present in both the databases, but the new environment database has some extra columns in those tables. Could you please help me in using the export/import utility so that the extra col
Changes to Daylight Savings Time in 2007 may affect your databases (DB2, Oracle and others)
(Chris Eaton) In the United States the start and end of daylight savings times are being changed in 2007. Daylight savings time will now start on March 11, 2007 (rather than early April) and will end on November 4, 2007 (rather than late October). Canada has also decided to follow the same schedule.