By Kevin Brown – Developers often take advantage of stored procedures to enhance the performance of database applications that use Microsoft SQL Server. Stored procedures offer a number of advantages over normal SQL statements: They’re precompiled and preoptimized, and they offer some programmable f
Author: SSWUG Research
Borland, Oracle heat up Java tools
By Wylie Wong – Oracle is shipping its Oracle 9i Developer Suite, a set of tools that Java and SQL developers can use to build their Web-based software. It includes the 9i JDeveloper Java development application and tools for building data warehousing and analysis systems, through which companies ca
XML Europe 2002 Coverage
by Leigh Dodds – In his opening keynote at the XML Europe 2002 conference, Peter Pappamikail, head of the European Union (EU) Information Resource Management Group, gave some background on their activities within European government and the unique challenges which they face in defining a new informa
Is XML the next big thing?
By James A. Cooke – For the past two decades, EDI has served as the mainstay for business-to-business data communication. But many experts believe that an alternative method of computer-to-computer communication–the use of extensible markup language (XML)–has begun to make inroads. To gauge where
How to select DISTINCT items from XML via XSLT
By Qing-Hua Jiang – How to select DISTINCT items from XML via XSLT Like SQL query "SELECT DISTINCT year FROM projets" ? To use "preceding-sibling", like select="/publish/book[not(year = preceding-sibling::book/year)]<br><br>How to select DISTINCT items from XML via XSLT Like SQ
Reasons to move your .NET network from Oracle to SQL Server
By Sanders Kaufman, Jr. – In the case of a .NET architecture, the answer to both questions is a .NET server. In this article, we explore the reasons why there may be an Oracle server in your network, what it will take to move it to SQL Server, and what you will gain by the move.
SQL Server Accelerator for BI Overview
Reduced time to market is a competitive advantage in today’s fast-moving, information-driven economy. To respond rapidly in this environment, companies must be able to quickly and easily access the information they need to make decisions that impact their customers, sales and profit growth opportuni
Accessing SQL Server Using HTTP
You can access Microsoft® SQL Server™ 2000 using HTTP. For more information about the URL syntax that is support by the SQL ISAPI extension, see URL Access. Before queries can be specified using HTTP, a virtual root must be created using the IIS Virtual Directory Management for SQL Server utility.
Pull Parsing in C# and Java
by Niel Bornstein – In my first article in this series, I wrote about porting a SAX application called RSSReader to the new Microsoft .NET Framework XmlReader. After publication, I received a message from Chris Lovett of Microsoft suggesting I revisit the subject. As he said, while the code I presen
DB2 to gain XML querying
By Martin Veitch – IBM plans to include XML querying capabilities so database administrators can delve into unstructured data, including multimedia files. Jeff Jones, DB2 marketing director, said the next DB2 will host "some form of XQuery support". XQuery is one of the most popular emerging