(Bala Murugan) It is very important to capture the visitor’s or customer’s feedback in terms of rating in any public facing websites like shopping, news, reviews or article, etc. This rating will help everyone to understand the credibility and worthiness of our website’s products. There are some ha
Other News
Oracle DBMS SCHEDULER Part 2 – The API
(Lewis Cunningham) In Part 1 of this series, I introduced you to the basic components and some information you need to know before using the scheduler. Today’s post will cover using the API to create some basic objects. I’ll show how to use SQL Developer to simplify some of these tasks.
Avoiding the flash chart security warning in Apex with EPG
(Flavio Casetta) If you host multiple web sites on the same apex server (using Apache as proxy and EPG) and some of these applications display flash charts, you might incur in the annoying problem of the security warning:
Are SQL Server BI systems compatible with virtualization?
(Don Jones) As more small and medium-sized businesses (SMBs) investigate and adopt business intelligence (BI) technologies for SQL Server, one question eventually gets asked: Can we virtualize SQL Server BI?
Linq to XML
(Jesse Liberty) Earlier, we took a look at two variants on Linq statements, one against a collection of integers, and then another against a collection of user-defined objects (Customers).
dbWatch Database Monitoring Tool
(Frank Kalis) In an ideal world companies would have only one operating system for all servers, all of them always on the same patch level. There would be only one strategic database platform and every database administrator knows that system and the management tools that ship with it from the insid
Update on the IBM DB2 ‘SQL Skin’ for Migrating from Sybase ASE
(Conor O’Mahony) Last year, I wrote about how IBM DB2 adds “SQL Skin for Sybase ASE” to Ease Database Migrations. I have been lucky enough to hear from some of the luminaries involved in the SQL Skin, so I thought I would take a few moments to follow up on that blog post.
Managing DB2 10 for z/OS with DB2 Administration Tool for z/OS V10
(Paolo Bruni, Tom Crocker, Elaine Morelli, Richard Schaufuss and Li Chuan Wang) Today’s business environment has increased the complexity and rate of change that a database administrator must control. The ability to respond quickly to a changing environment is constantly challenged by the explosion
Query optimization in MySQL with Subqueries
Recently I had to fetch data from several tables using ORDER BY and LIMIT statements in MySQL. The problem with LIMIT statement is that it’s applied in the last step after all the rows are fetched. I needed to fetch rows that fit in boundaries specified by x1,y1,x2,y2 as well as information about th
Learning Oracle GoldenGate
(Steve Callan) In this article, we’ll take a look at what takes place within Oracle GoldenGate in terms of how data gets from the source database to the target database. As the diagram below shows, there are four steps to perform in configuring GoldenGate.