(James Edmunds) “Don’t you have it set up so you can just automatically pull our listings from our Web sites?” the e-mail asked. “Not yet,” I typed in my response. “But it’s a great idea, and I’m working on it now.”
Other News
Get Table Details with SQL*Plus
(Ajay Garg) You can use SQL*Plus to provide the following details about a table: 1. Column Details 2. PRIMARY KEY 3. INDEXES 4. FOREIGN KEYS 5. CONSTRAINTS 6. ROWCOUNT 7. Other Tables That REFER to this Table 8. PARTITIONED COLUMNS 9. PARTITIONS 10. TRIGGERS 11. DEPENDANTS
Merging XML Files, Schema Validation, and More
(Aaron Skonnard) How can I merge the contents of multiple XML files into one? There are a variety of ways to accomplish this with the Microsoft .NET Framework, each of which uses a different type of XML API. To do this with the DOM API, you need to use the ImportNode function for copying XmlNode
Records management: Step-by-step programming IBM DB2 Records Manager V3.1 with WebSphere Studio Application Developer
(Naga Ayachitula) This is an introductory article on programming for IBM DB2 Records Manager. In this article we will walk step-by-step through an example showing how to create a program for IBM DB2 Records Manager using WebSphere Studio Application Developer.
Oracle Preps SMB App Server Assault
(Heather Clancy) Satisfied with its enterprise application server push, Oracle plans to spread its integration mantra throughout the much-wooed midmarket. But the company will need to convince smaller VARs and ISVs that its plans to hire additional application server suite sales specialists and
Introduction to Oracle 10g’s New SQLAccess Advisor
(James Koopmann) Have you have ever had a 3rd party application or internal application that you just never could get your hands on to tune? Now through the use of Oracle’s new SQLAccess Advisor you can capture the SQL from within the SQL cache and have this advisor help you decide the best plan of
The OLE DB Command Transformation
(Allan Mitchell) In the newsgroups we have been asked on a number of occasions how to execute a stored procedure once for every row of input data. There’s currently no really good way of doing this but in SQL Server 2005 DTS that is about to change. This article is going to show you how to take valu
Finding inactive machines using Active Directory
(Muthusamy Anantha Kumar) In a large organization, it can be difficult to find active and inactive machines as well as machines that are not used anymore. This article provides a basic guideline to query the Active Directory and ping all the machines on the network, in order to find all active and i
Preventing SQL Injection Attack
(William Sheldon) When defining your security implementation, your primary goal is to protect your organization’s data. SQL Server, as the data store, becomes the center of your security universe. To secure your data, you’ve run the Microsoft Baseline Security Analyzer (MBSA), limited database commu
Exploring E4X with Ruby
(Jack Herrington) E4X is a new standard for XML access in ECMAScript (JavaScript). Recently, I had the good fortune to meet some folks on the steering committee and to sample a demo. The idea is simple — XML access using SAX or DOM is too difficult, so make it easier.