by Randy Dyess – This article is the second article in a series to share those stored procedures and methods I have learned with you, in order to help you document and learn a new environment if you move on, or obtain another project at your existing company.
Community
Oracle SQL Techniques
by Sanjay Mishra, Alan Beaulieu – If you write programs to run against an Oracle database, you spend a lot of time and mental energy writing queries to return the data your programs need. Knowledge of SQL, and particularly of Oracle’s implementation of SQL, is the key to writing good queries in a ti
Oracle 9i R1 allows any user to access any table
By Chris Eaton – This was posted on the forum (comp.database.oracle.server) and I have tried it on my test system and it is a real problem: Any user can access any table using 9i. Someone on the forum posted that there is a TAR 2121935 open stating that it will be fixed in 9iR2 and not in 9.0.x. I s
Privacy and XML, Part 2
by Paul Madsen, Carlisle Adams – There are a number of efforts currently underway in standards bodies and other organizations to address various aspects of privacy with XML-based technologies. This section gives an overview of this work, noting which of the privacy concepts discussed in the first pa
Interactive Java & JDOM Online Tutorial
James Britt walks through the Java JDOM in this 45 page online interactive tutorial. This tutorial includes complete coverage of the JDOM objects from creation, through to SAX and Java-based exception handling.
Libxslt 1.0.17
Code cleanup, XSLT debugger support, EXSLT date improvements, Windows Makefile improvements.
SQL Server CE 2.0 Might Foster the Killer App
By Brian Moran – Microsoft’s new .NET Compact Framework and SQL Server CE 2.0 might encourage the development of killer apps for mobile devices that even SQL Server administrators couldn’t live without.
Moving from Access to SQL Server
By Jorge Cano – These kinds of tasks are a little more complex because we have to take care of the objects that we’ll move (or migrate) from Access to SQL Server. SQL Server has some tools and wizards that can help you, like the Enterprise Manager, Query Analyzer and others. SQL Server does not mana
Take Advantage of SQLXML with ASP.NET
Randy Holloway explains how to use SQLXML 3.0 with SQL Server to expose Web services through your ASP.NET applications by executing T-SQL stored procedures and user-defined functions.
Losing the E
By David Baum – Leveraging the internet to improve business communications and processes is still referred to as “e-business,” but these Oracle customers say e-business will soon become the standard for all business.