DatabaseJournal.com Staff

[From Dr. Dobb’s Portal] Data security is not optional in today’s business environment. High-visibility hacking and fraud, Sarbanes-Oxley, HIPAA regulations, and the Patriot Act all reinforce the need to present the right data to the right users and prevent the wrong ones from gaining access. Typically, “row level security” is one requirement: to allow or […]

[From InternetNews] Cisco today unveiled its long-awaited push for a greater role in the enterprise datacenter, with a major new product initiative called the Unified Computing System aimed at unifying network, storage, server and virtualization capabilities into one system. The article continues at http://www.internetnews.com/hardware/article.php/3810571/Cisco+Makes+Its+Play+for+the+Rest+of+the+Datacente.htm

>>Script Language and Platform: Oracle As an Oracle DBA, I connect to several databases. During login to a database running on a UNIX operating system, these steps are inevitable. export ORACLE_SID=jiwa sqlplus /nolog connect /as sysdba This script simplifies these steps by taking the ORACLE_SID arguement to connect to the database. Author: JP Vijaykumar Download […]

[From Eye on Oracle] Oracle has always been known as a fierce competitor, but when it comes to one area — virtualization — the software giant has stayed somewhat out of the limelight. Is that about to change? Oracle is reportedly in talks to acquire Virtual Iron, the fifth-largest server virtualization vendor,, and if they […]

[From eWeek Europe] Microsoft has created a software system that runs on Microsoft’s own distributed data centers. Microsoft has made available its Windows Azure SDK, which currently is in Community Technology Preview form, for application development. The article continues at http://www.eweekeurope.co.uk/product/microsoft-azure-cloud-sdk-311

[From IT Jungle] MySQL and IBM last week started a public beta for the new DB2 for i (IBMDB2i) Storage Engine for the MySQL database, a long-awaited product that will allow System i shops to care and feed for their MySQL-based PHP applications running on their i OS server just as they do for ordinary […]

[From IBM] HANNOVER, GERMANY – 02 Mar 2009: In a joint demonstration at CeBIT, IBM (NYSE: IBM) and SAP (XETRA: SAP.DE) previewed a technology that enables the live migration of SAP applications across remote IBM POWER6 systems via cloud computing. The technology, developed as a part of the European Union-funded RESERVOIR cloud computing project, is […]

[From OTN] This column shows you two new features in Oracle Application Development Framework (Oracle ADF) 11g that make data entry easier and more efficient for end users. You’ll configure a declarative list of values (LOV) with an autocompletion feature (similar to what you may have used in Oracle Forms). In the process, you’ll see […]

[From SQL Server Central] In this article I want to show you one tricky issue I faced recently. This took around 6 hours to track down what exactly was happening and hence I am sharing the details so that if you have the same problem it will be a quick check for you instead of […]

[From eWeek] HANNOVER, Germany — Amazon Web Services, which is rapidly catching up to its retail division and will soon become the Web 2.0 company’s bread-and-butter business, on March 3 launched a new option for the European Union region that allows software developers to run Microsoft Windows Server and Microsoft SQL Server in the cloud. […]

by Jeffrey Garbus Introduction Fixing a performance problem isn’t usually difficult, once you’ve found it. According to studies, 80% of the mean time to resolution in performance is the identification of the root cause. When you consider that other studies have shown that 24% of IT staff time is devoted to performance issues, the math […]

>>Script Language and Platform: Oracle Use this query to find free/used/allocated space in temp files. Author: Sameer SELECT f.tablespace_name tname, round(SUM(ROUND((f.bytes_free + f.bytes_used) / 1024 / 1024, 2)),0) allocated_mb, round(SUM(ROUND(nvl(p.bytes_used, 0) / 1024 / 1024, 2)),0) Used_MB, round(SUM(ROUND(((f.bytes_free + f.bytes_used) – nvl(p.bytes_used, 0)) / 1024 / 1024, 2)),0) Free_MB, round((SUM(ROUND(nvl(p.bytes_used, 0) / 1024 / 1024, […]