uring my years as a database developer I have often faced the task of finding and deleting duplicate data in a database. Duplicates impact data accuracy and credibility, and they
he “ORA-01555 snapshot too old” error, which causes user transactions to fail, is a nightmare for Oracle DBAs and developers. It usually occurs after queries or batch processes have been
hen I started using SQL Server in version 4.2, backups were relatively simple. There were only two possibilities: a full backup or a transaction log backup. Starting with SQL Server
Editor’s note: This is the second of a three-part series about how to build your own XML editor. f you’ve been looking for a cross-platform, open-source, XML editor, you’ve likely
t’s becoming common to retrieve data from a relational database formatted as a hierarchical XML document. By using an XML schema, it’s possible to generate data from XML documents and
Editor’s note: This is the first of a three-part series about how to build your own XML editor. f you’ve been looking for a cross-platform, open-source XML editor, you’ve likely
t is very common to encounter situations where users need to query a database directly. Even though you’ve created 100 reports in a given application, there will always be the
he “ORA-01555 snapshot too old” error, which causes user transactions to fail, is a nightmare for Oracle DBAs and developers. It usually occurs after queries or batch processes have been
anagers loved Eddie; he always had the answers on-hand. Eddie was a production supervisor in the pre-computer era. He received comprehensive hourly production reports on paper. He also received urgent