XML has become more popular as an authoring format, and it brings with it the frustrating choice between typing tags ad nauseum, or adopting XML GUIs that may be too expensive, too buggy or too proprietary for preference. Numerous systems, formats and tools have sprung up to provide useful authoring
Other News
Copy the structure of a table
(Urmila Verma) Here is a very simple tip for Oracle users. Many times in my various projects I have come across cases where I needed to CREATE a table with exactly the same structure as an existing table but without any records. Here’s how to do it. (R)
Log Switch Activity
by Darrin Deeter – Description: Here’s a simple script that determines when your database is seeing the largest amount of change activity. This is very useful for answering questions like, why was the system so slow yesterday about 2:30? Or trying to balance out a large amount of batch work. Credit
Run Full-Text Database Searches On a Shoestring
by Roger Jennings – The emergence of XML as the lingua franca of data interchange has caused an increasing demand for storing hierarchical XML documents in relational databases. Inserting XML documents in [n]varchar or [n]text columns of SQL Server tables is easy, but retrieving rows containing rele
Some tips about tempdb database
By Alexander Chigrik – When SQL Server is installed the setup program creates tempdb database. Tempdb is a system database used by SQL Server to store temporary tables and temporary stored procedures, for sorting, subqueries, and aggregates with GROUP BY, ORDER BY, for cursors and so on. Tempdb data
Sagent adopts Web services
By Heather Harreld – BUSINESS INTELLIGENCE VENDOR Sagent on announced support for Web services in an effort to give its customers the ability to more easily embed BI (business intelligence) into their applications and develop collaborative BI solutions leveraging data from multiple organizations.
SOAP Test Harness
By Craig Emilio Probus – My project team is currently developing a distributed .NET application using Web Services as a basis for a component model. Because of this intensive use of Web services, we needed to facilitate the testing process of our components for both component consumers and component
Examining WSDL
by Rich Salz – Unlike today's Web, web services can be viewed as a set of programs interacting cross a network with no explicit human interaction involved during the transaction. In order for programs to exchange data, it's necessary to define strictly the communications protocol, the data t
Oracle bets on XML for 9i software
By Wylie Wong – Oracle, looking to regain market share lost to its rivals, is set to launch a new version of its flagship database software. The software maker said it plans to ship a new release of its 9i database later this week or early next week. Topping the list of new features in the re
Oracle Uses Streaming Media to Reach Potential Customers
By John Zipperer – When Mark Jarvis, senior vice president and chief marketing officer for Oracle Corp., came to speak at the Streaming Media West event (which was collocated with Internet World Spring 2002) on April 26, he came not to speak about his company’s databases or enterprise applications.