By Charles Babcock – IBM is challenging Microsoft for midsize- and small-business database users by pricing the Express version of its DB2 database at $598 for a single user running it on a single processor.
Other News
Truncating Data When Exporting to Excel
I built a Data Transformation Services (DTS) package that exports data from a table in SQL Server 7.0 to a spreadsheet in Microsoft Excel. The package’s first run works fine, but subsequent runs just append the data to the spreadsheet instead of replacing it in the spreadsheet. How can I avoid this
SQL Server anti blocking strategies
In this article Sancho Fock discusses various strategies for reducing blocking in SQL Server databases.
Recovering Accidentally Lost Data Using Oracle’s Flashback Query
by Sreeram Surapaneni – Oracle database uses a version based read consistency mechanism by saving an image of the data prior to making any modifications. These changes are stored in the undo tablespace. If the users decide not to commit the transaction, Oracle uses the data saved in the undo tablesp
IBM To Add Order To XML
By Antone Gonsalves – IBM plans to release next year a software tool that will improve DB2 Content Manager’s ability to manage the many different XML documents used by enterprises.Code-named “Cinnamon,” the utility will be integrated with the administrative tools for Content Manager’s reposi
Oracle Debuts Free Hosted Verification Service
Oracle on Friday introduced a free hosted verification service for developers and independent software vendors, who can use the Oracle Portal Verification Service to test the interoperability of their Web-based content and applications.
SQL Server Security Checklist
Neil Boyle shares a checklist of 24 common security gaps. Don’t let your server fall under any of these lapses. You’ve been warned.
IBM adds database support to Risk Manager
IBM will expand its Tivoli Risk Manager security event management product to manage security events from a number of common enterprise databases.The Risk Manager software can now manage security events from IBM DB2 Universal Database as well as Oracle Database by Oracle and Microsoft’s SQL S
Oracle CSO sees ‘unbreakable’ security as a must
By Michael S. Mimoso – In this interview, Oracle chief security officer Mary Ann Davidson talks about Oracle’s “Unbreakable” campaign, Trustworthy Computing and making security part of the corporate culture.
IBM Fits DB2 With Automation
By Lisa Vaas – An upgrade to IBM’s DB2 Express database offers small and midsize businesses a no-click, quiet-as-a-mouse, self-installing version of its enterprise-level DB2 Universal Database, IBM officials said.