Recovery Manager, Oracle’s backup and recovery utility, was first released with Oracle 8.0 providing DBAs an integrated backup and recovery solution for the Oracle Database. With over seven years in the field, RMAN has been implemented by Oracle customers in production environments ranging from simp
Author: SSWUG Research
Oracle 10g Free training- Database Introduction
This tutorial covers the basics of Database Management Systems, Various types of Databases, The Relational Model, Benefits of RDBMS and Oracle Database along with Frequently Asked Questions.
Data Conversion and Transformation Considerations
Before using Data Transformation Services (DTS) to convert or transform data between heterogeneous data and destinations, consider these variations in the way different programs, providers, and drivers support data types and SQL statements.
SQL Server 2005: CLR Integration
(Miles Trochesset) Using a CLR trigger we can register all user defined functions, procedures, types, aggregates etc., contained in an assembly when it is created in the database on “CREATE ASSEMBLY … “. This saves us the time of registering all these ourselfves. We skip the “CREATE PROCEDURE …”
A Perfect Union
(Howard Goldberg) In an earlier article, I described the virtues of an enterprise information integration (EII) approach and how it can help enterprises get a handle on integration needs (see Resources). As I explained, EII is not a panacea for solving all data integration problems; it isn’t in any
Creating and Using Code Snippets in Visual Studio 2005
(Scott Mitchell) If you create your web applications using Visual Basic, you’re likely aware that Visual Studio .NET 2002/2003 provides some nice auto-complete features that were sorely missing from the C# side. For example, when creating a class in Visual Studio .NET 2002/2003 using Visual Basic, b
Date processing in Informix Dynamic Server
(Jacques Roy) IBM Informix Dynamic Server has several functions that manipulate date and datetime types. You can exploit these functions to provide better processing and analysis of your business data. You can also add new functions that will simplify the solution of some date-based business problem
Remote Backup Software – A Lifeline to Businesses Greatest Asset
(Tommy Gardner) The single most valuable asset of businesses is not the inventory of products or services that they provide, or the process by which they deliver them. It isn’t the hardware and machinery that they employ in their efforts. It is not even the building the business is housed in, nor th
Type Design Guidelines for Reusable .NET Libraries
(Krzysztof Cwalina and Brad Adams) From the CLR perspective, there are only two categories of types- reference types and value types-but for the purpose of framework design discussion we divide types into more logical groups, each with its own specific design rules. Figure 1 shows these logical grou
Publishing IMS and DB2 Data using WebSphere Information Integrator: Configuration and Monitoring Guide
(Nagraj Alur, Neale Armstrong, Tadakatsu Azuma, Christian Daser and Manuel Mueller) This IBM Redbook provides an overview of IBM’s event publishing solution delivered via its WebSphere Information Integrator Classic Event Publisher and WebSphere Information Integrator Event Publisher products, and