Free Newsletters:
DatabaseJournal  
DBANews
Database Journal
Search Database Journal:
 
HOME News MS SQL Oracle DB2 Access MySQL PostgreSQL PHP SQL Etc Scripts Links Discussion
internet.com

» HOME
» NEWS
» FEATURES
» SERIES
MS SQL
Oracle
MS Access
MySQL
DB2
» RESOURCES
Products
Scripts
Links
» DISCUSSION
» TECH JOBS

Marketplace Partners
Be a Marketplace Partner




internet.commerce
Be a Commerce Partner
Web Design
GPS Devices
Corporate Gifts
Domain registration
Imprinted Gifts
Dental Insurance
Best Price
Computer Hardware
Car Donations
Holiday Gift Ideas
Promote Your Website
KVM Switch over IP
Logo Design
Online Shopping




MySpace Joins eBay, Yahoo in Open Profile Push

News Corp. Unit Under Fire for Ties to Hacker

Are Non-PC Devices Hurting 'Net Innovation?

internet.com
IT
Developer
Internet News
Small Business
Personal Technology
International

Search internet.com
Advertise
Corporate Info
Newsletters
Tech Jobs
E-mail Offers


Linked Data Planet Conference & Expo

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

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


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

Featured Solutions for Technology Professionals from Internet.com
Whitepaper: Storage Management Costs in the Enterprise
Sponsored by HP
This report should be read by anyone responsible for choosing storage solutions for their organizations or for making administrative personnel decisions in the data center. Many factors contribute to the ownership cost for enterprise storage. Get the comparison of Mid-Range Array Solutions here. Learn more.

 
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.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
DB2 9 and Microsoft Access 2007 Part 1: Getting the Data... 4/21
more...

DB2 9.5 and IBM Data Studio Part 9: The SQL Editor Development Accelerators 5/12
The last article of this series noted that you can write SQL using both the SQL Builder and SQL Editor. This installment touches on the differences between SQL Builder and SQL Editor by showing you the capabilities of the SQL Editor in more depth.

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.


Sybase Delivers Extreme Analytics Out of the Box With New Analytic Appliance 5/12
Sybase, Inc. today announced the new Sybase Analytic Appliance, configured and tuned to provide extreme analytics and alleviate overburdened enterprise data warehouses, data marts and reporting systems.

The future of PHP 5/12
Know what changes are in store for PHP V6 and how your scripts will change.

Oracle Introduces Oracle’s JD Edwards EnterpriseOne Financial Management and Compliance Console 5/12
New console delivers targeted financial performance metrics and powerful business analytics to user desktops.

Navicat MySQL GUI for Mac OS X ver. 7.1.3 released 5/09
This new version supports Excel Import, Virtual Grouping, Tabbed Window, Tabbed Windows,SSH Connection, Structure Synchronization and other usability and stability enhancements.

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.


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.

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.


Latest Database Articles from DevX
Taming Trees: Building Branching Structures
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

Download: SQL Compare Pro 6--The fastest, easiest way to compare and synchronize two databases.
Learn Tools & Techniques to Justify and Fund Your IT Investments. Download Complimentary Report Now!
Whitepaper: Enterprise Information Integration--Deployment Best Practices for Low-Cost Implementation
Learn about expanding business opportunities for the reseller channel. Visit IT Channel Planet.
Download: Solaris 8 Migration Assistant. Run Solaris 8 apps on the latest SPARC systems and Solaris 10.


Latest Forum Threads
Database Journal Forum
Topic By Replies Updated
DB2 9.5 and IBM Data Studio Part 9: The SQL Editor Development Accelerators lcole 0 May 12th, 04:26 PM
Sybase Delivers Extreme Analytics Out of the Box With New Analytic Appliance lcole 0 May 12th, 04:26 PM
The future of PHP lcole 0 May 12th, 04:25 PM
Oracle Introduces Oracle’s JD Edwards EnterpriseOne Financial Management and Complian lcole 0 May 12th, 04:23 PM
DBA Support Forum
Topic By Replies Updated
Backup & recovery j_e_paul 1 May 13th, 04:08 AM
Materialized views j_e_paul 3 May 13th, 03:19 AM
Update Lucky A 4 May 13th, 02:31 AM

Hot Forum Threads
Database Journal Forum
Topic By Replies Updated
User Access in SQL 2005 pegeot2000 9 May 12th, 12:44 PM
Portable db CDF 7 April 21st, 03:31 PM
Hopefully simple SQL Query? smjohns 10 April 17th, 11:58 AM
"SELECT rowguidcol" vs. "SELECT <actual name>" rgarrison 9 April 16th, 03:46 PM
DBA Support Forum
Topic By Replies Updated
Oracle RAC on SUSE SLES 10/NetApp NAS Nikee 6 May 13th, 02:28 AM
Add datafile to UNDOTBS claire 9 May 12th, 10:34 PM
Help to slove the Date Format Problem in a procedure NBSR 24 May 12th, 01:29 PM







JupiterOnlineMedia

internet.comearthweb.comDevx.commediabistro.comGraphics.com

Search:

Jupitermedia Corporation has two divisions: Jupiterimages and JupiterOnlineMedia

Jupitermedia Corporate Info


Legal Notices, Licensing, Reprints, & Permissions, Privacy Policy.

Advertise | Newsletters | Tech Jobs | Shopping | E-mail Offers

Solutions
Whitepapers and eBooks
Microsoft Article: HyperV-The Killer Feature in WinServer ‘08
Avaya Article: How to Feed Data into the Avaya Event Processor
Microsoft Article: Install What You Need with Win Server ‘08
HP eBook: Putting the Green into IT
Whitepaper: HP Integrated Citrix XenServer for HP ProLiant Servers
Intel Go Parallel Portal: Interview with C++ Guru Herb Sutter, Part 1
Intel Go Parallel Portal: Interview with C++ Guru Herb Sutter, Part 2--The Future of Concurrency
Avaya Article: Setting Up a SIP A/S Development Environment
IBM Article: How Cool Is Your Data Center?
Microsoft Article: Managing Virtual Machines with Microsoft System Center
HP eBook: Storage Networking , Part 1
Microsoft Article: Solving Data Center Complexity with Microsoft System Center Configuration Manager 2007
MORE WHITEPAPERS, EBOOKS, AND ARTICLES
Webcasts
Intel Video: Are Multi-core Processors Here to Stay?
On-Demand Webcast: Five Virtualization Trends to Watch
HP Video: Page Cost Calculator
Intel Video: APIs for Parallel Programming
HP Webcast: Storage Is Changing Fast - Be Ready or Be Left Behind
Microsoft Silverlight Video: Creating Fading Controls with Expression Design and Expression Blend 2
MORE WEBCASTS, PODCASTS, AND VIDEOS
Downloads and eKits
Sun Download: Solaris 8 Migration Assistant
Sybase Download: SQL Anywhere Developer Edition
Red Gate Download: SQL Backup Pro and free DBA Best Practices eBook
Red Gate Download: SQL Compare Pro 6
Iron Speed Designer Application Generator
MORE DOWNLOADS, EKITS, AND FREE TRIALS
Tutorials and Demos
How-to-Article: Preparing for Hyper-Threading Technology and Dual Core Technology
eTouch PDF: Conquering the Tyranny of E-Mail and Word Processors
IBM Article: Collaborating in the High-Performance Workplace
HP Demo: StorageWorks EVA4400
Intel Featured Algorhythm: Intel Threading Building Blocks--The Pipeline Class
Microsoft How-to Article: Get Going with Silverlight and Windows Live
MORE TUTORIALS, DEMOS AND STEP-BY-STEP GUIDES