By Matt Hicks and John S. McCright – Moves by Oracle Corp. and IBM to embed new business intelligence functionality in their database management systems are designed to improve performance and simplify data warehousing. But they could also add unwanted complexity.Release 2 of Oracle’s 9i dat
Community
OASIS Sets Sights on XML for DRM
By Clint Boulton – OASIS — a group responsible for crafting XML interoperability standards — revealed the latest in its flood of technical commmittees formed over the last several months to mesh the Extensible Markup Language with other technologies. Tuesday the Boston-based said it has targeted t
Peer-to-peer communications using XML
XML is a critical ingredient in peer-to-peer information sharing schemes, including grid computing, instant messaging, and Web services. In this article, Anne Zieger explores the cutting-edge efforts intended to create a unified P2P fabric based on adaptations of existing XML technology.
Putting Attributes to Work
by Bob DuCharme – Once an XML document is read into a source tree, where an XSLT stylesheet can get a hold of it, there's a lot that the stylesheet can do with the source document's attribute values. This month we'll look at how to convert attributes to result tree elements, how to grab
Performing a Cascade Delete in SQL Server 7
From SQLTeam – This article comes to us from Tim Young. Tim writes “One of the (few) very handy things about Access is the cascade delete function. If you delete a record from a parent table, all relating records in the child tables are also deleted. I couldn’t find any way of doing this in SQL Serv
SQL Server management dos and don’ts
By Meredith B. Derby – It’s time to re-arrange your thinking. Consider your SQL Servers not as regular database servers but as data centers, said Kent Erickson. “Think of them as critical business applications,” with the goal of achieving the highest availability possible. Better overall business pr
Monitoring the performance of Microsoft SQL Server
by Steven Warren – When you install Microsoft SQL Server, additional Performance monitor objects and counters are automatically installed. While you must have administrative access to your SQL Server to use these objects, SQL Server admins should find them invaluable in monitoring and tuning the dat
SQL Server Versions
From SQLTeam – I’m continually trying to track down what service packs are installed on various SQL Servers I support. I can never find the right support page on Microsoft’s site. So here’s an article with all the SQL Server version information I can track down.
Updatable Snapshots
By Prakash – Updatable Snapshots, a feature of Oracle Enterprise Edition only, is the snapshot, or copy, of a table, or part of a table. This copy can also be updated. Thus, updatable snapshot sites can also propagate any changes made upon them back to the parent.‘Updatable Snapshots’ should
The toughest SQL Server and Oracle questions answered
By Tim DiChiara – A few weeks ago, I called upon you loyal SearchDatabase readers to submit your toughest questions to stump our site experts. We received over a hundred questions — I knew the modern DBMS was complex, but wow! The experts’ responses ranged from a confident “None of them really pose