The Wayback Machine - https://web.archive.org/web/20071022173623/http://www.databasejournal.com:80/


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




internet.commerce
Be a Commerce Partner
Custom Products
GPS
Build a Server Rack
Car Donation
Affiliate Programs
Domains for Business
Promote Your Website
Computer Deals
Boat Donations
GPS Devices
Internet Security
Marketing Products
Promotional Pens
Compare Prices




AT&T; CEO Has Tough Message For Regulators

Comcast Suspected of Limiting BitTorrent Use

Acceleration, Security to Dominate Talk at Interop

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

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



Webcast: Storage Security--Managing Vulnerabilities in the Datacenter. Learn what steps to take to assess your security needs around storage to steer clear of data breaches.

Data Management
Expand Information Access without Compromising Security
Learn how expanding access and linkage between separate databases does not have to equate with decreased security. View this Microsoft Webcast, which addresses the unique aspects of security from the perspective of the server, the database, and database objects. ;

Featured on the ProCurve Resource Center
Whitepaper: Network Immunity Solution
More networks are being attacked and threatened, in more devious and creative ways, than ever before. Incidents range from viruses and worms to Trojan horses and internal sabotage. Find out how to defend yourself with a simple, efficient, and affordable architecture that provides broad coverage of internal threat protection for wired and wireless networks.»

Featured in the eBook Library for Technology Professionals
eBook: Guide to Managing an IT Staff
Why is managing technical people difficult? Some would say techies are socially inept and simply can't communicate well. While that may be true in some cases, saying so doesn't help managers deal with techies any better: It just defers the problem. Download this eBook for advice on how to bridge the communications gap. Download this eBook now.

 
Recent Headlines
Oracle
Using Oracle 10g Tuning Utilities 10/18
Oracle RAC Benchmarking with SwingBench 2.2 10/17
Oracle, MySQL and PostgreSQL feature comparison – Part 2 10/11
more...
MS SQL
SQL Server 2005 Express Edition - Part 9 - Managing User Instances 10/22
Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 10 10/16
SQL Server 2005 Express Edition - Part 8 - XCopy Deployment 10/12
more...
MS Access
Converting Access Queries to SQL Server 10/15
Migrating Access Apps to SQL Server 9/21
Migrating From MS Access To MySQL 8/23
more...
DB2
DB2 Viper II and the IBM Data Studio Developer Workbench 10/19
DB2 9 and Microsoft Excel 2007: Part 4: Creating a Pivot Table... 8/13
DB2 9 and Microsoft Excel 2007 Part 3: Building Your Own Queries... 8/06
more...

SQL Server 2005 Express Edition - Part 9 - Managing User Instances 10/22
SQL Server 2005 Express Edition's unique functionality allows you to distribute and implement single-user databases, without the dependency of having administrative privileges or the need for a cumbersome configuration. This article illustrates the practical use of this feature, known as XCopy deployment.

DB2 Viper II and the IBM Data Studio Developer Workbench 10/19
In part 1 of this new series, Paul Zikopoulos introduces the Database Explorer that's part of the new IBM DS DWB in the DB2 Viper II open beta.

Using Oracle 10g Tuning Utilities 10/18
Starting with 10g, Oracle introduced Advisors, which are part of the ADDM (Automatic Database Diagnostic Monitor) and run in the background. This article discusses some of the more common ADDM utilities used and how they can help troubleshoot and tune the database.

Oracle RAC Benchmarking with SwingBench 2.2 10/17
Tarry Singh discusses why benchmarking is important and offers an overview of SwingBench 2.2, a free Java based utility, to stress test Oracle databases.


Imperva Clears Another Compliance Visibility Cloud Caused by Pooled Database Connections 10/22
SecureSphere traces and links individuals to actions on shared SQL connections; provides most flexible options for user tracking.

MDX: Why it will matter to application developers 10/22
Since when did application developers need to know about an analytical querying language like MDX? Since February 27th, next year.

XML Handling in Microsoft SQL Server 2005 10/19
Ivan Pepelnjak describes how to use the XML data type introduced in Microsoft SQL Server 2005 to increase the speed of your SQL queries and updates.

Oracle licensing, support pose VMware virtualization hurdle 10/19
An increasing number of VMware shops have expressed interest in migrating their Oracle applications off dedicated physical machines and onto virtual machines (VMs), but Oracle's virtualization-unfriendly licensing and support policies don't make the move easy.

Add Your News

Receive news via our XML/RSS feed



SQL CodeSecure (SqlLabs)
Audits and protects your SQL Server database from unauthorized modification of code and creation and deletion of database objects.

SQL Documentation Tool (Winnersh Triangle Web Solutions Ltd)
Creates technical documentation for Microsoft SQL Server databases.

CompareData (Zidsoft)
Native Windows cross-DBMS application that allows you to visually compare and synchronize data between two SQL databases using ODBC drivers.


Database Lock Information
Look for Object Name and for how long the Lock has been there (Locked Time in Sec).

Track Table Fragmentation Script
A diagnostic table and stored procedure to track the fragmentation of large tables within databases. The user passes the database name and the table name as parameters to the SP. The SP can be set up to run as a scheduled job every few hours to produce a historical trend of fragmentation.

Session Information
Use this script to find the session information.

SQL trace and TKPROF in SQLPLUS
Purpose: To read raw session trace file with option to format trace file with TKPROF and read it in SQLPLUS Session.

Table Compare
This sp can compare two tables with the same structure.


Latest Database Articles from DevX
Getting Started with Crystal Reports for Visual Studio 2005
Working with Nullable Types in C#
Visualizing Data: Self-Documenting Ant files
SQL Server Management Objects: Lessons from the Wild
Converting Numbers to Column Names in Excel 2007

Symantec Whitepaper: Breaking Through the Dissimilar Hardware Restore Challenge.
Whitepaper: Linux vs. Microsoft--Making the Right Choice for Your Client-Server Infrastructure.
Keep up with the latest business and technology news and information! Visit Internet.com.
Stay up to date! Get real-time news and reviews about the latest innovations in internet technology.
Webcast: Storage Security--Managing Vulnerabilities in the Datacenter. With so much at stake, don�t wait.


Latest Forum Threads
Database Journal Forum
Topic By Replies Updated
DB2 Viper II and the IBM Data Studio Developer Workbench lcole 0 October 19th, 03:46 PM
XML Handling in Microsoft SQL Server 2005 lcole 0 October 19th, 03:45 PM
Oracle licensing, support pose VMware virtualization hurdle lcole 0 October 19th, 03:44 PM
Imperva adds firewall for SQL lcole 0 October 19th, 03:44 PM
DBA Support Forum
Topic By Replies Updated
White space (space once used, but reserved) in tables JChiappa 4 October 19th, 08:02 PM
Load test for DB bang_dba 3 October 19th, 06:43 PM
sql tuning puneet 0 October 19th, 06:23 PM

Hot Forum Threads
Database Journal Forum
Topic By Replies Updated
SQL 2005 Japanese KANA Character Set myBU 7 October 19th, 12:46 PM
Adding 6 months to the month from a date Jayshree 6 October 19th, 05:15 AM
Order by field not in Group by elt 10 October 19th, 05:04 AM
Query result set of stored procedure maartens 6 October 17th, 04:16 PM
DBA Support Forum
Topic By Replies Updated
install Oracle 10g R2 on AIX p5 yxez 11 October 19th, 07:52 AM
error on dbms_job ams-jamali 6 October 19th, 05:42 AM
Accessing Oracle Database programatically from a remote machine janani.raman 6 October 18th, 05:50 AM





Solutions


JupiterOnlineMedia

internet.comearthweb.comDevx.commediabistro.comGraphics.com

Search:

Jupitermedia Corporation has two divisions: Jupiterimages and JupiterOnlineMedia

Jupitermedia Corporate Info