(Tarry Singh) It is easy and convenient to assume that everything will go fine with all of the automated features that most applications are sold with today. Oracle has also worked hard to achieve this since version 8. With the newer Oracle 10g, many administration tasks were automated, Oracle 11g c
Other News
Oracle BI EE – Execute Direct Database Requests
(Venkatakrishnan J) This article is just to show the one of the features of OBI EE. It is not recommended to use this feature since it bypasses the metadata layer and executes direct database requests. If it has to be used in your environment, do it with utmost care and caution taking all the securi
Basics of Ajax
(Debjani Mallick) Ajax is the shorthand notation for Asynchronous JavaScript and XML. It is a web development technique that is used for developing interactive web applications. Ajax develops interactive web application by sending a small amount of data to the server behind the scenes. The advantage
The Baker’s Dozen: A 13-Step Crash Course for Using LINQ
(Kevin S. Goff) How many software tasks DON’T involve querying data? Answer: very few.
DB2 reserved words: DB2 9 edition
(Willie Favero) With every release of DB2, additions are made to the list of reserved words in the SQL Reference manual (for DB2 9 it’s SC18-9854 with the latest version as of this writing being placed on the web March 2007). DB2 9 has been out long enough that customers have started planning their
The Domino DB2 Debate: Why No System i DB2 Domino Data Store?
(Thomas M. Stockwell) Several weeks ago, when Domino 8 began to ship, a System i reporter noticed that Domino 8 permits the storage of Notes/Domino data in the format of the DB2 Universal Database (sometimes marketed as DB2 UDB). Evidently, this reporter had expected Lotus to extend this capability
MySQL Database To Get Replication Monitoring, Multi-Concurrency Features
(Charles Babcock) The MySQL open source database by the end of September will offer a beta version that shows several capabilities normally associated with more sophisticated database systems, such as online database replication monitoring.
Migrate ERwin data models to Rational Data Architect
(Denis Vasconcelos) IBM Rational Data Architect delivers unique features not available in many of today’s data modeling tools in the market, including CA ERwin. Migrate existing data models created in CA ERwin Data Modeler to Rational Data Architect, and explore some of Rational Data Architect’s fea
Speed up SQL Server database queries with these tips
(Tim Chapman) If you’ve worked with SQL Server databases for any amount of time, it’s practically a given that you’ve run into slow running queries. Sometimes the reason for the slow response time is due to the load on the system, and other times it is because the query is not written to perform as
SQL Gotcha: Do you know what data type is used when running ad-hoc queries?
(Denis Gobo) This is for SQL Server 2000 only, SQL Server 2005 is a lot smarter which is another reason to upgrade. When running the following query you probably already know that 2 is converted to an int datatype.