(Philip Gunning) Regardless of how well a RDBMS performs, the monitoring of SQL statements and resources is required to ensure continued good performance and to identify problem areas. Using the information gathered, adjustments can be made to instance and database configuration parameters, physica
Other News
Oracle Unveils More of Its Siebel Plans
(Renee Boucher Ferguson) While Oracle has remained, out of necessity, relatively quiet about its plans with Siebel Systems, some details are starting to emerge.
Serialize and deserialize objects to an XML file
(Edward Tanguay) This code shows the simplest way to automatically convert the information in an object to an XML file and back into an object. This is useful if you need to make information available web-server like on your server for other applications to pick it up. I just cut the significant par
BI and Beyond: The Rise of Operational Business Intelligence Through Embedded Reporting
(Fred Richards) In the late nineties, the concept of “intelligence everywhere” or pervasive business intelligence began to emerge. Arising from the vision of the traditional business intelligence community, intelligence everywhere conveyed the thought of unleashing the tremendous power inherent in d
Teach Your Old Web Cam New Tricks: Use Video Captures in Your .NET Applications
(Wei-Meng Lee) Today, a webcam is a common peripheral, used most often for video conferencing, that most people can easily afford. But what can you do with your webcam besides video conferencing? If you are a developer, the answer is plenty; you will be glad to know that integrating a webcam with an
Monitoring Oracle 10g RAC with Quest Spotlight on RAC – Part I
(Tarry Singh) You have heard the hype around a particular technology. It’s cool and everyone wants a piece of it. Then it’s the post-hype era for a technology where it is getting serious attention from the Big Players and eventually its commoditization. Breakthrough technologies, like Oracle RAC or
FIX: Error message when you run an UPDATE statement that uses two JOIN hints to update a table in SQL Server 2000: ‘Internal SQL Server error’
Consider the following scenario. In Microsoft SQL Server 2000, you try to update a table by running an UPDATE statement. The UPDATE statement joins three tables by using two JOIN hints. In this scenario, you receive the following error message: Server: Msg 8624, Level 16, State 1, Line 1 Intern
Build upon SQL’s built-in statistical functions
(Arthur Fuller) Even though SQL wasn’t designed for calculating statistics, it does include a number of basic statistical functions. In this article, I’ll define statistical terms and functions and then demonstrate how you can benefit from using SQL’s built-in statistical functions.
Migrating Oracle Application Server Apps to BEA WebLogic Server 9.0!
Now you can not only get the facts on why it’s important to move your organization’s critical applications from Oracle Application Server to BEA WebLogic Server 9.0, you can also get in-depth guidance on how to make a smart move easier and more cost-effective. Learn how your organization can: –D
Comparing Microsoft SQL Server Replication and DataXtend RE Replication for Mobile and Distributed Applications
If you are considering Microsoft replication capabilities you need to understand how these capabilities compare to DataXtend RE. This white paper discusses the differences in SQL Server and DataXtend RE replication capabilities across several areas and also reviews the challenges of supporting multi