By Martin LaMonica – The free service, available from BEA’s developer Web site, is based on XML Beans, software that the company is testing. The software converts Extensible Markup Language (XML) document definitions into Java code. By generating much of the Java needed to process an XML document wi
Author: SSWUG Research
Determine the number of rows in a table without a table scan
By Andrew Novick – If you don’t require an exact answer, it isn’t necessary use a SELECT count(*) query on the rows in a table to get the row count. SQL Server keeps the row count in sysindexes and it can be retrieved there. The key is to select the correct record from sysindexes.
Gartner warns users not to expect cost cuts from Oracle offering
Analyst firm Gartner Group has warned users that Oracle’s new All In One programme may not guarantee cost reduction despite the company’s promise that it will enable enterprises to predict cost of ownership for applications.
Backup and Restore – Back to Basics with SQL LiteSpeed
This article by Greg Robidoux provides some great information about SQL LiteSpeed. One of the most important aspects for a database environment is ensuring reliable backups are being executed and a dependable recovery plan is established in the event of a system failure or data corruption. Sev
How To Retrieve Relational Data Using OpenXML with ADO in Visual C++
OpenXML.exe demonstrates how to retrieve an ADO Recordset from an input XML document by using the OpenXML feature in SQL Server 2000.
Beware of the System Generated Constraint Name
No one writes code that references constraint names so it is not important to name a constraint. If this is your thought, it may be time to think again. Eventually you are bound to end up coding a small piece of T-SQL code, which will reference a constraint name; you had better be aware that constra
New Oracle9i Application Developer Certification Track Beta Exam
The second exam in this new track is in beta and available for only US$50 from January 6, 2003 through March 6, 2003.
OASIS Looks To Use XML To Assist Fight Aginst Terrorism
The OASIS technology standards group said Thursday it has formed a committee to develop a global technical framework for the searching and sharing of suspected criminal and terrorist evidence by law enforcement agencies.
How to Search for Date and Time Values Using Microsoft SQL Server 2000
by Bryan Syverson – Learn how to perform searches on date and time columns. Includes some tips on performance.
BEA Service Aims to Ease XML-Java Fusion
Angling for the convergence of application integration and application development, BEA looks to make life easier for Java developers with XMLBeans.