DatabaseJournal.com Staff

12.02.02.  The PostgreSQL Global Development Group yesterday announced the release of version 7.3 of the PostgreSQL object-relational database management system (ORDBMS). PostgreSQL, the world’s most advanced open source database, provides solutions for many of the most demanding applications in use today, saving businesses and governments millions of dollars each year. The worldwide PostgreSQL community is […]

1.     Introduction This article presents a basic introduction to transaction processing in PL/SQL and primarily focuses on the Autonomous transaction processing feature of PL/SQL and the changes that have occurred from Oracle 8i (8.1.7) to 9i (9.2.0.1.0). In the following sections, I will define transaction and describe the use of distributed transactions and autonomous transactions, […]

by Ajay Gursahani Overview This article describes the processes and procedures followed for writing external routines and accessing the same from Oracle SQL/PLSQL Blocks. Specifically, the articles covers: What is an External Routine (ER) How to Create an External Routine How to Register an External Routine How to interface PL/SQL with External Routines Advantages of […]

In the first article of this series, I presented a few simple scripts automating the most basic SQL Server administrative tasks, such as starting and stopping a SQL Server service and login management (changing passwords and determining mappings between server logins and database users). In this article, we will cover methods dealing mostly with SQL […]

Dante Lorenso The Problem So, you have a huge project that you want to build. It’s been determined that you want to use PHP, and your backend is Oracle. You’ve installed Oracle, you’ve installed your web server, and you’ve even gotten PHP to connect to your Oracle back end to do some simple queries. Now […]

[From SecurityFocus] SQL Injection is a way to attack the data in a database through a firewall protecting it. It is a method by which the parameters of a Web-based application are modified in order to change the SQL statements that are passed to a database to return data. For example, by adding a single […]

iAnywhere Solutions Inc., a subsidiary of Sybase, Inc., recently announced the general availability of SQL Anywhere(R) Studio 8.0.2, the latest version of the market-leading mobile data management and enterprise synchronization solution. Version 8.0.2 features the UltraLite(TM) Component Suite to simplify mobile application development, as well as significant security and performance enhancements. “We have been using […]

Windows Management Instrumentation is becoming one of the prevalent management technologies in Windows environments. Although it is primarily known among Windows server and desktop administrators, its tremendous versatility encompasses other management areas as well. The goal of this series of articles is to demonstrate the use of WMI in SQL Server management. The architecture of […]

[From Embedded.com] The Encirq 2e suite gives developers a database suitable for embedded systems, along with the tools to customize it for particular applications. According to the company, it’s possible to fit such an application into a memory footprint of less than 100KB. The suite consists of a SQL database engine, a tool for customizing […]

Results Prove Oracle Beats Microsoft on Performance and Price/Performance on Entry Level Intel-based Systems Oracle today announced four record benchmark results, measuring Oracle database performance for on-line transaction processing (OLTP) on Hewlett Packard (HP) systems using Intel Itanium 2 processors. With these results, Oracle beats Microsoft SQL Server on both performance and price-performance on single-system […]

sasha@neosystems.ru I am a Microsoft SQL Server Database Designer for Neo-Systems North-West – a security services, consulting, and training company. I have over eight years of experience in the IT field. I am currently working on several projects which involve the deployment of Microsoft Windows NT Server/Microsoft SQL Server within an enterprise business/financial environment. My […]

VigilEnt Security Agent for SQL Server v.1.0 automates database security management and bolsters native security controls PentaSafe Security Technologies, Inc., a leading provider of integrated security management solutions, announced earlier this week general availability of its VigilEnt Security Agent for Microsoft SQL Server v.1.0, which complements its existing line of Oracle and Sybase database security […]