Can Oracle kick SQL Server's behind?

Lean the interesting discussion about that Can Oracle kick SQL Server's behind? Oracle versus SQL Server in the Enterprise Edition. Oracle expert David throws down the gauntlet to Microsoft devotees.

Physical and logical structuring of Oracle Database

An Oracle database system comprises at least one instance of the application, along with data storage. An instance comprises a set of operating-system processes and memory-structures that interact with the storage.

How To Send Email From An Oracle Procedure Using UTL_SMTP

As of Oracle 8.1, we can now send email from within an Oracle application. This is done by using the UTL_SMTP package. However, it should be noted that there are some shortcomings with this package that may or may not be a problem for us.

Oracle, MySQL and PostgreSQL feature comparison

With the ever-burgeoning feature sets available in modern databases, it's difficult to separate the wheat from the chaff. There are plenty of high-level data warehousing features in Oracle for instance that you might never need.

Steps for Advanced Queuing In Oracle9i

This article is a basic primer to get you started using Advanced Queuing in Oracle9i and Oracle8i. Such as
* Environment Setup
* Define Payload
* Create Queue Table And Queue
* Grant Privilege On Queue
* Enqueue Message
* Dequeue Message
* Variations

ANSI/ISO SQL 1999 standards Support In Oracle9i

Oracle9i now supports the ANSI/ISO SQL: 1999 standards. This allows easier product migration and a reduced learning curve when cross-training, but there is no performance increase compared to the existing syntax.

Simulating ASM with 10g Oracle Database by faking the hardware

Most of the Oracle 10g databases are using ASM for storage as it's very simple to maintain the storage w.r.t. to Disks, Datafiles etc. We can get most of the ASM details & implementation details from OTN here...

SQL Tuning made easy in Oracle 10g

?Find out how to use DBMS_SQLTUNE package to tune SQL Statements in Oracle 10g? Have you ever been frustrated with SQL Tuning? Did you get lost in the maze of /+ HINTS +/ and analysis paralysis? Pre-10g you have to be either a SQL tuning expert or should have a license to...

Oracle 10g a Flashback Database

Oracle 10g?s brilliant alternative to database point in time recovery is the the Flashback Database feature. With this feature in place you can do almost everything that you can do with point in time recovery,

Parse XML Documents in Oracle

The use of XML for data transfer has increased dramatically over the last few years. Since most applications still rely on structured relational data it is necessary to explode the non-structured XML data into relations tables

10 things you can do to make sure your data doesn't walk out the door

Hacker attacks that bring down the network get a lot of attention, so companies concern themselves with protecting against those threats to prevent your database.

List of New Features in DB2 UDB V9

New Features in DB2 UDB V9 One of the new features in DB2 version 9 which got a lot of attention is certainly Row Compression. While compression algorithms are in place already in DB2 before for instance backup compression, value compression, row compression is unique for several reasons

How to Optimize of IBM DB2

The optimizer is the heart and soul of DB2. It analyzes SQL statements and determines the most efficient access path available for satisfying each statement. DB2 UDB accomplishes this by parsing the SQL statement to determine which tables and columns must be accessed.

How to Use DB2 native XML with PHP

Learn about the effectiveness of using the native XML capabilities coming in the next version of DB2 Universal Database? for Linux?, UNIX?, & Windows? to simplify application code and relational schemas. This article looks at the impact of schema evolution on the application

Top 20 mistakes a DBA can make, you know!

Do one of the 20 things seasoned DBA and Oracle expert Carmichael of Dragonfly Consulting LLC listed in her presentation at the Oracle user event International Oracle Users Group (IOUG) Live!, and you could find yourself holding a pink slip faster than you can say Victorias Secret on Fox Tonight

How to handle email addresses in SQL Server

Handling email addresses in SQL Server. SQL Server databases is quite common, especially in those tables, that store information about customers, clients, subscribers etc.

Die Sucker - Killing SQL Server Process Ids (spids)

We have noticed some of my processes are failing because spids are already connected to the database. This happens specifically when we need to a restore database. We catch this problem pretty quick when we are working on it during the data and can fix it.

Options and Analysis - Exclusive Database Access

Problems and solutions. Do any other options exist? What are the advantages and disadvantages to these approaches? When should one approach be used over another?

Microsoft SQL Server Support Guide.

The objective of the Microsoft SQL (MSSQL) port is to provide another database alternative to MYSQL to take advantage of SQL server in business environments where Mysql may be a barrier to entry. The goal was to provide the ability for GL1.4.0 to work in either Mysql or MS SQL server