(Ed Tittel) This is the seventh of a nine-part series of tips on XSLT, the XML Stylesheet Language Transformations. So far, we’ve looked at XSLT structure and syntax, its processing model, elements, expressions, functions, and processing techniques. In this tip, we cover the broad outlines of what’s
Other News
Series title: Directory Services Markup Language Server
(Sachin Raut) The Directory Services Markup Language v1.0 (DSMLv1) provides a means for representing directory structural information as an XML document.DSMLv2 goes further, providing a method for expressing directory queries and updates and the results of these operations as XML documents. Thes
Reuse enterprise user data in DB2 Content Manager
(Gabriela Barowsky) Content Manager (CM) needs its own built-in user repository to grant users access to text documents, video files, pictures, and whatever else is stored in the system. In most cases, CM needs to be integrated into a complex enterprise environment. It coexists with several other sy
High Call Volume SQL Server Applications on NUMA Systems
(Joe Chang) One of the most difficult database operations to scale-up on high-end server systems is the network call. In fact, without special precautions, a high call volume database application can have severe negative scaling on large systems. It is suspected that this problem is more pronounced
Researcher lashes out at Oracle’s security effort
(René Millman) A vulnerability researcher has attacked Oracle for failing to tackle a number of flaws in its software products.
Predicting when you will run out of space
(Chris Eaton) Here is a simple script that can show you the amount of free space available in each of your tablespaces.
Access SQL Server securely using Windows domain accounts
(Serdar Yegulalp) You can authenticate to SQL Server using either a native SQL Server user account or a Windows domain account, such as Active Directory. All too often, a SQL Server administrator who simply wants to get things up and running will use SQL Server’s native administrator account (the sa
Just SQL Part VII – Hierarchical Queries
(James Koopmann) It is not a question as to whether or not hierarchical models are good or bad. We will all come across them no matter where we go. However, querying these structures has often baffled many practitioners. Not just in understanding the model behind them but in querying them properly.
Oracle Tip: Kill runaway Oracle processes on Windows with OraKill
(Scott Stephens) If you use the Windows Task Manager to kill the Oracle thread, it would bring down all users and background threads and crash the database. That’s why Oracle provides the command orakill.exe.
FIX: The Mail Profile combo box is disabled when you view SQL Server agent properties, and when you try to use the xp_sendmail stored procedure from a DTS package in SQL Server 2000
In Microsoft SQL Server 2000 Service Pack 3 (SP3), when you use Enterprise Manager to view SQL Server agent properties, the Mail Profile combo box that displays profiles is disabled. Additionally, when you try to use the xp_sendmail stored procedure from a DTS package, the operation may fail, and yo