(Dean Hiller) Although software and architectural reuse has been a constant drumbeat in the technical press for many years, it’s still common to see code and designs that violate many principles of reuse. For example, how many software systems have you seen that are similar to the diagram in Figure
Other News
Improving Data Quality
(Jonathan Geiger) Data profiling does not improve data quality directly. It provides a better understanding of the challenges you face in delivering information that meets business expectations. To improve data quality, you must act on the information.
Chat with the Lab: Database Performance
(Susan Visser) Mark your calendar for this upcoming chat, taking place Wednesday, Feb 21, 2007, 1 PM Eastern, 12 noon Central, 10 AM Pacific.
Oracle revamps TimesTen In-Memory Database
(Mark Brunelli) The new version of Oracle’s TimesTen embeddable database is designed to give enterprises in financial, telecommunications and other high-volume markets quicker throughput and speedier response times. (R)
FIX: Error message when you run a full-text query in SQL Server 2000: ‘Error: 17883, Severity: 1, State: 0’
When you run a full-text query in SQL Server 2000 while a catalog merge operation also occurs, the result set may not return quickly. When this delay occurs, the SQL Server User Mode Scheduler (UMS) may stop responding. Additionally, you may experience stalled worker request behavior.
How to delete duplicate rows with SQL, Part 2
(Xaprb) By reader request, this article explains ways to remove duplicate rows when they are completely identical, and you don’t have a primary key or other criterion to identify which rows to “save.”
Forms Services and multiple IIS Web Applications
(Alexei Levenkov, Nicholas Lovell and Balbir Singh) We often get questions asking if the XmlFormView control can be used in a particular environment. Usually you will use it on a regular page that belongs to a WSS Site or on a page in _layouts folder of a WSS site. These scenarios are supported and
IBM XQuery Whiteboard for DB2
IBM XQuery Whiteboard for DB2 is a graphical tool that extends the XQuery capabilities in IBM DB2 Version 9.1 for Linux, UNIX, and Windows. A user can enter an XQuery expression and see the result after it has been executed. The XQuery expression can refer to information in the database, in local do
Trade risk for speed with Oracle 10g’s asynchronous COMMIT
(Bob Watkins) One thing that Oracle DBAs know for a fact is that a transaction isn’t committed until it is written to the online redo log files. If a COMMIT statement in an application completes, the application can trust that the data is protected against instance failure, and can be recovered by ”
Persisting Your Visual Basic .NET Objects with .NET Serialization
(Jeff Cogswell) If you’re developing a standalone .NET application, more than likely you’ll need to provide your users with the ability to save and later load data. There are many ways to approach such a task. The wrong way to do it is to open a binary file and write the individual data strings and