By Craig S. Mullins – Most relational database management systems provide support for triggers. But just what is a trigger? If you have never had the opportunity to use them, their power may elude you at first.
Other News
Reinstalling SQL Server on a Failed Node
SQL Server 2000 Enterprise Edition installs SQL Server executables and program files on both of my clustered servers simultaneously. If one of my servers goes down, how can I rebuild the server and reinstall SQL Server on that node?
A Comparison of Oracle’s DATE and TIMESTAMP Datatypes
By James F. Koopmann – If you want to store date and time information in Oracle, you really only have two different options for the column’s datatype. Lets take a quick look at these two datatypes and what they offer.
PeopleSoft Customers Wary of Oracle Takeover
By Lisa Vaas – If Oracle Corp.’s Town Hall meeting on Thursday managed to lull the fears of any PeopleSoft Inc. customers, those customers kept mum about their newfound ease. The uncomforted, however, did not.
Extreme Markup Languages 2003: complete program available
The complete program of all sessions scheduled for the Extreme Markup Languages 2003 conference (“an unabashedly hard-core conference for the technically-oriented members of the information interchange and knowledge representation community” taking place in Montreal on August 5-8) is now available.
Subelement contents versus tag attributes
In this tip, developerWorks columnist David Mertz advises when to use tag attributes and when to use subelement contents to represent data. Learn what considerations go into designing a DTD, Schema, or just an ad hoc XML format. You’ll also learn when attributes and contents are interchangeable, and
XPathNavigator in the .NET Framework
The XPath functionality is the ability to query a data store for some node or set of nodes. The XPathNavigator is the class that provides the methods required to implement XPath queries over any data store, and is based upon the Data Model described in the XML Path Language (XPath) 1.0 Recommendatio
Take the Winter Corporation VLDB Survey!
Winter Corporation has announced a survey running from May 1 to September 2 to identify the largest commercial database implementations, the Top Ten Program Survey.
DB2 user certification prep, Part 1: DB2 Tools, data warehousing and OLAP
By Paul Zikopoulous – This tutorial introduces the basics of the DB2 Tools, and the concepts of data warehousing and OLAP. It is designed to help you prepare for the DB2 Fundamentals Certification (Exam 512). The material in this tutorial primarily covers the objectives in the first section of the e
System-Supplied Trace UDFs
Most of you have probably created your own SQL Server user-defined functions (UDFs), but did you know that Microsoft ships a fair number of its own UDFs, especially in the most recent SP3? In this article, Baya Pavliashvili and Kevin Kline explore a subset of them that are related to traces.