(Debu Panda) Transactions are always a vital part of everybody’s life .. Transactions are involved when we withdraw some money using an ATM or buy a mocha from the Starbucks or shop at Amazon.com. However most java developers misunderstand transactions and its impact on performance and robustness of
Other News
Setting Up Email Notifications for Alerts in Oracle Enterprise Manager 10g Grid Control
(Ana Hernandez) Many IT organizations require that email notifications (including email-to-page notifications) be sent to the appropriate administrators when an alert is detected. This Technical Note describes a best-practice methodology for setting this process up in the Enterprise Manager (EM) 10g
The Scalable Vector Graphics (SVG) pocket reference, Part 2
(Donovan Cowie) In Part 1 of this article we examined Scalable Vector Graphics (SVG) as an XML-based image format. In Part 2, we investigate SVG’s dynamic and interactive nature and delve into the scripting techniques that make SVG come to life. (R)
An instance of SQL Server 2000 may not start successfully after you restore the model database by using the WITH NORECOVERY option
When you try to start an instance of SQL Server after you restore the model system database by using the WITH NORECOVERY option, the instance of SQL Server may not start successfully. Additionally, you may notice the following error messages in the SQL Server error log files: 2003-04-18 09:37:3
Schedule Away the Routine
(Jonathan Gennick) Routine tasks are boring. If you perform them manually, you wind up doing the same task over and over, with the risk that one day you might slip up and skip a step or make some other mistake. Oracle Database 10g’s new built-in job scheduler gives you powerful capabilities for
Checking Your Database Fragmentation Level
(Nicholas Cain) There are a lot of posts on the site regarding index fragmentation and possible ways to deal with this. You could certainly use the Database Maintenance Plans built into SQL Server to handle your re-indexing needs, however frequently you want something a little more directed than the
Runstats command to update all columns of multi-column index
(Craig Mullins) If I run the following Runstats command: Runstats Database.tablespace Index(all) will it update ALL columns of a multi-column index or just the first column? (R)
Practical database design, Part 1
(Philipp K. Janert) What are the best choices when designing the schema for a relational database? What is the rationale in deciding in favor of one and against some other alternative? Given the amount of vendor-specific recommendations, it is all too easy to overlook basic relational database funda
DOM NodeFilters and XML data binding
(Nicholas ChasUsing a DOM NodeFilter lets you control the contents of a set of XML data without touching the base application, but the NodeFilter itself is still a class, and needs to be recompiled in order to make any non-trivial changes. This tutorial explains how to build a system that enables a
How to set up and troubleshoot a linked server to Oracle in SQL Server
This step-by-step article describes how to set up a linked server from a Microsoft SQL Server computer to an Oracle database and also provides basic troubleshooting steps for common errors you may encounter when you set up a linked server to Oracle.