DatabaseJournal.com Staff

>>Script Language and Platform: OracleUse of bind variables in sql*plus and pl/sql improve application performance. Handling nulls through the use of bind variables in pl/sql scripts is a tricky task. Here are some examples to handle nulls. Author: jp vijaykumar Download Script:Bind-Variables.txt Disclaimer: We hope that the information on these script pages is valuable to […]

by Eric Miner ASE 15 introduces completely new Optimizer and Query Processing engines, incorporating many fundamental changes. With these improvements comes the requirement that you give the optimizer as much accurate information about your data and databases as you possibly can. All that the optimizer needs to know is found in the ‘statistics’. This paper […]

[From InformationWeek Blogs] Yesterday I headed into Manhattan to meet with folks from Microsoft (NSDQ: MSFT)’s Platform Strategy group, another major division of Microsoft slowly edging the company away from behemoth-dom and towards fairer play for both proprietary and open source. Slow but steady may well win this race. The article continues at http://www.informationweek.com/blog/main/archives/2008/12/a_little_chat_w.html

[From PremiumSoft CyberTech Ltd.] PremiumSoft is offering 20% off on all of its products including Navicat for MySQL, Navicat for PostgreSQL, Navicat for Oracle and the Java IDE, JCODER. After discounts, Navicat starts from US$76. This promotion is only valid from December 9 ­ December 15, 2008. To take advantage of this time limited offer, […]

[From Birdstep Technology] Birdstep Technology today announced the general availability release of its Raima Database Manager Embedded version 9.0. This is the latest release from the Raima Database Management Family, which provides new capabilities and functionality for embedded systems application developers and topping the list is a MicroHTTP server. The article continues at http://www.raima.com/about-us/news–events/latest-press-releases/birdstep-announces-the-release-of-rdme90/

[From Geekzone] Zoho has announced Zoho CloudSQL, a middleware service that uses the familiar SQL (Structured Query Language) to connect business data stored in Zoho with traditional, on-premises applications as well as other SaaS offerings. Zoho Reports, the company’s online reporting and business intelligence service previously known as Zoho DB & Reports, is the first […]

[From Softpedia] Launched officially at the end of February 2008, concomitantly with Windows Server 2008, SQL Server 2008 was only released to manufacturing at the start of August 2008. Formerly codenamed Katmai, SQL Server 2008 represents not only Microsoft’s way of taking its database platform to the next level, but also mixing in out-of-the-box business […]

[From OTN] First introduced in Oracle9i Database, Oracle Flashback technology comprises a group of features with which you can view data at different points in time and recover data without using point-in-time media recovery. Oracle Database 11g offers two key new flashback technology features that continue to provide DBAs with a powerful set of data […]

[From Search Oracle] In the previous installment, we explored ways the Oracle manager could cut his budget by trimming hardware and software costs,. But the sad reality is that the lion’s share of a typical budget is for highly talented and well-compensated Oracle professionals, those indispensable folks who create and maintain the applications that allow […]

[From TMCNet] Businesses using Oracle CRM On Demand are now able to get automated access to a business-to-business resource thanks to the new Jigsaw for Oracle CRM On Demand. With this new offering, users can automatically export contact and company records into their customer relationship management (CRM) environment. The article continues at http://outbound-call-center.tmcnet.com/topics/hosted-call-center/articles/45952-jigsaw-oracle-crm-demand-launched.htm

[From Internet News] SAN JOSE, Calif. — Memo to enterprises moving toward service oriented architecture (SOA) as a way to slash costs.

[From ZDNet Asia] In a previous article, I gave a brief introduction to Policy Based Management, a new SQL Server 2008 feature that allows the Database Administrator the ability to define and enforce policies through the database engine. In this article I’ll look at how you can use SQL Server Management Studio to define your […]