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 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 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 Whitepaper: HP Integrated Citrix XenServer for HP ProLiant Servers Sponsored by HP, Citrix, and Intel Learn how a single server can be easily and rapidly set up as a virtualization server to manage the server and the virtual machines. Download this whitepaper now and get a chance to receive FREE XenServer HP Select Edition Software. Solutions for Technology Professionals from Internet.com

Recent Headlines Oracle Multi Table Loop 5/07 Programming, Perl + Oracle 5/05 Create your own reports with Oracle’s Snapshot Information 5/01 more... MS SQL SQL Server 2005 Express Edition - Part 22 - Upgrading from Microsoft SQL Server Desktop Engine (MSDE) 5/09 Row Value Constructor in SQL Server 2008 5/06 SQL Server Management Studio Reports and Dashboard 5/02 more... MS Access “In the clouds” ~ Using Microsoft Access to query and update Web sites 4/14 Access TreeView-ListView Basics 3/21 Peter's Software Launches Shrinkerstretcher V10.0 for Microsoft Access 3/04 more... DB2 DB2 9 and Microsoft Access 2007: Working with your DB2 Data in Access 2007 4/28 DB2 9 and Microsoft Access 2007 Part 1: Getting the Data... 4/21 Understanding DB2: Learning Visually with Examples 4/01 more...

SQL Server 2005 Express Edition - Part 22 - Upgrading from Microsoft SQL Server Desktop Engine (MSDE) 5/09
This installment focuses on upgrading from Microsoft Desktop Engine (MSDE) to SQL Server 2005 Express Edition.

Multi Table Loop 5/07
This article examines how to loop through multiple tables to process the data.

Row Value Constructor in SQL Server 2008 5/06
This article illustrates different methods to insert data into a table, including the new Row Value Constructor, which simplifies the data insertion.

Programming, Perl + Oracle 5/05
Perl is a powerful scripting language that can meet your day-to-day scripting needs as a database administrator, and if used prudently, and responsibly, as a language to build large web-based applications. Here's a quick introduction to using Perl with Oracle.

SaaS Tool Offers Custom Database Development 5/09
Now non-programmers can build enterprise-class apps fast and on the cheap.

MySQL Workbench for Database Change Management 5/08
MySQL Workbench contains a number of database change control features that you may not have noticed at first. Robin Schumacher introduces them and shows why they can be a big help when it comes to managing change in your databases.

Sarbanes-Oxley compliance checklist: IT security and SQL audits 5/08
Get security practices, procedures and documentation to meet Sarbanes-Oxley (SOX) compliance. This tip includes checklists to guide SQL DBAs and developers to inspect systems.

Is your Oracle database really secure? 5/08
While Oracle databases are nowhere near as vulnerable as they were five years ago, there is still a great deal of attention being paid to them by both security professionals and hackers alike.

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.

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.

Measure the Buffercache Hit Ratio for User Wise
This script allows you to see the bufferhit ratio of all application users, when all application users are running on the server, so that you can measure individual performance.

View the process block chain (sp_who_blocks)
This procedure is an extension of sp_who2 that shows additional information about the block chain using CTE.

Latest Database Articles from DevX

Performing CRUD and Grouping Operations with the LinqDataSource Control Advanced Ranking and Grouping with SQL Server Reporting Services Tracking Events Using a Semi-Structured Repository Running In the Field: How to Make Your Handheld Your Best Friend Advanced Matrix Reporting Techniques

Data Sheet: IBM Information Server Blade
Quest Whitepaper: Improving Oracle Database Performance Using Real-Time Visual Diagnostics
Download: SQL Backup & DBA Best Practices eBook
Webcast: Five Virtualization Trends to Watch. Produced for HP, Citrix, and Intel.
Download: Solaris 8 Migration Assistant. Run Solaris 8 apps on the latest SPARC systems and Solaris 10.