(Dratz) Ok, by now you should have a fair understanding of the major architectural components used in Oracle and what they do. We’ve just discussed SQL because it is the major interface to communicate with Oracle.
Author: SSWUG Research
Oracle 10g: A Self Managed Database?
(Sreeram Surapaneni) All DBAs, at one time or another, worry that their jobs will become obsolete if Oracle delivers on their promise to deliver a self-managing database. Oracle wants to penetrate into smaller-scale Oracle installations where, in practice, no database tuning and maintenance takes pl
Using and Monitoring SQL 2005 Query Notification
(Sanchan Sahai Saxena) With the advent of SQL Server 2005, your application can request SQL Server to notify it when critical data in a database has changed. Up to that point, an application can safely continue to retrieve data from the cache. This provides a much more granular level of control and
Oracle vs. SAP: Picking the right path to SOA
(Mark Brunelli) Oracle and SAP AG’s distinctly different approaches to service-oriented architecture (SOA) encapsulate a major problem faced by IT organizations the world over: whether to go with a packaged application provider or a middleware provider to meet their SOA requirements. (R)
Open source making way in SMBs
(Carol Hildebrand) Ernie Ball Inc. is certainly not the norm when it comes to software use. The San Luis Obispo, Calif.-based company switched completely to open source software after a surprise audit by the Business Software Alliance produced a hefty fine for using unlicensed software. (R)
Using XML and XSLT
(Krishnan) XML Stylesheet Transformation(XSLT) is defined as a language for converting XML documents to other document formats. This article shows how to perform the transformation using classes of .NET Framework.
Higher-Order Functional Programming with XSLT 2.0 and FXSL
(Dimitre Novatchev) This article describes the added support in FXSL 2.0 for writing higher-order functions in XSLT 2.0 based on new fundamental XPath 2.0/XSLT 2.0 features such as the sequence datatype, strong typing and writing functions natively in XSLT. FXSL 2.0 makes nearly all standard XPath 2
DB2 9 Fundamentals exam 730 prep, Part 3: Accessing DB2 data
(George Baklarz) This tutorial gives you an introduction to the objects that make up a DB2 database, and the different factors which affect how the database is created. After a brief introduction to DB2 objects, we’ll examine the different tools to create, access, and manipulate DB2 objects. This is
The Baker’s Dozen: 13 Productivity Tips for Remoting in Visual Studio 2005
(Kevin S. Goff)This installment of the Baker’s Dozen presents an introduction to remoting and remoting interfaces.
VSTS meets unit test: Part 3
(George Lawton) Unit testing has during recent years become a cornerstone practice in writing quality applications. Extreme programming advocates in the Java camp promoted use of unit tests, and their open source tool of choice, JUnit, quickly found .NET fans via a .NET version known as NUnit.