CA ERwin® Data Modeler Proven database design and modeling. Efficiently analyze, design and deploy effective database solutions. Whitepaper: Manage SQL Server Deployments Try it free: CA ERwin® Data Modeler

Featured DBA Jobs Production Manager (hands on) Aquent US-MA-Cambridge ASP 3.0/.NET Developer Jupitermedia US-NY-New York Access Database Developer The Computer Merchant, Ltd US-MA-Cambridge Search all DBA Jobs | Post A Resume | Post A Job Guide to Oracle 11g and Database Migration Oracle Database 11g includes more features for self-management and automation, which makes it easier for customers to cost-effectively manage their data. Download this Internet.com eBook for an overview of some of the new features in 11g and for an overview of the issues you need to consider as you prepare for a database migration. » Featured on the Solutions for Midsize Businesses Solaris 8 Migration Assistant Rapidly move your Solaris 8 application environments to new systems running Solaris 10 with the Solaris 8 Migration Assistant. Reduce migration risk while taking advantage of increased performance, reliability and security of the latest SPARC hardware platforms and Solaris 10 OS. » Featured on the Sun Server and Solaris Solution Center

Recent Headlines Oracle Oracle 10g Cloning Guide: A Small County Government Approach 5/20 Oracle Warehouse Builder Automated ETL Processing 5/14 Multi Table Loop 5/07 more... MS SQL Dimension Attributes: Introduction and Overview, Part III 5/15 Policy-based Management in SQL Server 2008 – Part II 5/13 SQL Server 2005 Express Edition - Part 22 - Upgrading from Microsoft SQL Server Desktop Engine (MSDE) 5/09 more... MS Access Posting Microsoft Access Information “Into the clouds” 5/16 “In the clouds” ~ Using Microsoft Access to query and update Web sites 4/14 Access TreeView-ListView Basics 3/21 more... DB2 DB2 9.5 and IBM Data Studio - Part 10: Building Stored Procedures 5/19 DB2 9.5 and IBM Data Studio Part 9: The SQL Editor Development Accelerators 5/12 DB2 9 and Microsoft Access 2007: Working with your DB2 Data in Access 2007 4/28 more...

Oracle 10g Cloning Guide: A Small County Government Approach 5/20
This document offers one approach to database refreshes for Oracle 10g databases on Windows 32 and 64 bit servers.

DB2 9.5 and IBM Data Studio - Part 10: Building Stored Procedures 5/19
Learn how to take an SQL statement that you built using either the SQL Editor or the SQL Builder and quickly turn it into a deployed SQL/PL stored procedure. In addition, this article explains how to move a data development project between servers.

Posting Microsoft Access Information “Into the clouds” 5/16
Part one of this article demonstrated how to retrieve data and save it into XML using Microsoft Access and MSXML. Part 2 shows how to add new data to a Web2 website ("in the clouds").

Dimension Attributes: Introduction and Overview, Part III 5/15
Join Business Intelligence Architect Bill Pearson as he continues his subseries surrounding components of the Analysis Services dimensional model. In this article we continue our introduction to dimension attributes, focusing upon the Misc group of attribute properties.

Startup launches 'Internet-scale' database 5/20
Startup Aster Data Systems is coming to market with what it calls an "Internet-scale" cluster database, and has landed a major initial customer: MySpace, to back up the claim.

When Is A Data Warehouse Not A Data Warehouse? 5/20
Answer: When it's a database-less appliance. Unlike some competing products, Dataupia's data warehouse appliance performs analysis on data stored in existing databases.

Mass SQL injection attack hits Chinese Web sites 5/19
Web sites across China and Taiwan are being hit by a mass SQL injection attack that has implanted malware in thousands of Web sites...

Oracle Plans to Build New Global Information Technology Facility 5/19
Oracle Corporation announces plans to build a new Global Information Technology facility in West Jordan, Utah.

Add Your News

Receive news via our XML/RSS feed

SQL Excel (SQL Excel)
Adds database access to MS Excel.

e-SoftEasy Business Analytics (e-SoftEasy)
Creates reports, charts, and dashboards in HTML/PDF format from multiple database servers.

LyteRAD (Lytecube.com)
Integrated application development framework for light-weight database applications; a Java framework for building standalone applications.

Test SQL Connectivity
This script tests connectivity to SQL Server box from a client machine when there is no SQL Client.

Database Physical & Actual Size
Useful on Oracle 8.1.7 onwards or remove the dba_temp_files line & run for earlier versions.

Drop all user schema tables
Using cascade constraints you can drop all tables from user schema.

DEFAULT column values
To avoide ARC_Triggers creation, you can use DEFAULT column values.

How to compare NULL with NULL
This script will compare NULL with NULL, because NULL is not equal to NULL.

Backup in Noarchivelog in RMAN
This script will backup in noarchivelog using RMAN.

Latest Database Articles from DevX

PerformancePoint 2007: Installing Planning Server Secure Internet File-Sharing with PHP, MySQL, and JavaScript Using the GRANT Command Quickly Copy Data Rows from DataReader to a DataTable Taming Trees: Building Branching Structures

Whitepaper: HP Integrated Citrix XenServer for HP ProLiant Servers. Sponsored by HP, Citrix, and Intel.
Download: SQL Backup & DBA Best Practices eBook.
Five Trends for Application Development. Download Your Complimentary Report. Exclusive. Act Now.
HP eBook: Using Business Service Management (BSM) to Manage Your Business Applications
What's The Future Of IT? Find Out By Reading "IT in 2018" Now. Free Registration Required.