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

» HOME
» NEWS
» VIDEO
» 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


















VMware CEO Maritz Charts Virtualization's Future

Are We Ready for DTV?

Cisco's Virtual Acceleration Nexus

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

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


Database Programmer / Systems Manager
Command Web Offset
US-NJ-Secaucus

Senior Quality Management Analyst (PA)
Next Step Systems
US-PA-King of Prussia

Unix / AIX Systems Administrator
The Computer Merchant, Ltd
US-IL-Schaumburg





 
Recent Headlines
Oracle
Oracle Database 11g: Adaptive Cursor Sharing 9/30
Unleashing DBMS_PROFILER 9/24
Free Hands-on Oracle E-Business Suite Training 9/11
more...
MS SQL
SQL Server 2008 Data Collections and the Management Data Warehouse 9/29
SqlCredit – Part 19: Exploring SQL 2005’s Ranking Functions – RANK() and DENSE_RANK() 9/26
Mastering OLAP Reports: Parameterized Grouping 9/23
more...
MS Access
MS Access and MySQL 9/15
Creating Charts in an Access 2007 Database 8/11
Focus on Popular Objects to Speed up an Access 2007 Database 7/18
more...
DB2
DB2 9 and Microsoft Access 2007 - Part 3: DB2 Reports 8/04
A Product Overview of DB2 9 for Linux, UNIX, and Windows 7/01
DB2 and Visual Studio 2008: Getting Started 6/11
more...

Oracle Database 11g: Adaptive Cursor Sharing 9/30
This article discusses a new Oracle Database 11gR1 feature - Adaptive Cursor Sharing - and illustrates how to use it in practical situations to limit hard parsing of SQL statements with bind variables while increasing the relative execution efficiency of those statements.

SQL Server 2008 Data Collections and the Management Data Warehouse 9/29
Data Collections are a great tool that allows DBAs to gather different statistics, and the Management Data Warehouse (MDW) is the repository for storing those statistics. This article offers an overview of Data Collections and how to configure the MDW.

SqlCredit – Part 19: Exploring SQL 2005’s Ranking Functions – RANK() and DENSE_RANK() 9/26
Part 19 digs deep into two of SQL 2005's ranking functions: RANK() and DENSE_RANK(). It includes performance considerations and using CTEs to avoid table variables.

The Missing Sync 9/25
This article offers an overview of what is needed in a robust data synchronization system.


Intro to Databases
By Bill Hatfield
Published July 2, 2008
New to databases? Start by learning the basic terminology.

Access Database
By Helen Bradley
Published June 2, 2008
Learn how to create a database as well as a report and query to go along with it.

How to Use Queries
By Helen Bradley
Published June 2, 2008
Learn how to extract information from your Microsoft Access database to answer typical business questions and analyze your data in new ways.

Data Binding to Forms Made Simple in .Net 2.0
By Wei-Meng Lee
Published June 4, 2008
Creating a form that displays formatted information from a database is a matter of a few easy steps in .NET 2.0 using Visual Studio 2005

(More Videos)


Microsoft's Lineup of SQL Server Related Webcasts for October 2008 9/30
Four new webcasts are scheduled for October, covering such topics as "Add Business Intelligence to Service Oriented Architecture Applications", "Addressing Compliance with SQL Server 2008" and more.

Oracle DBAs cite lack of security measures 9/30
Increasingly complex database environments are making it difficult for database administrators to secure systems and protect against a data breach, according to a new survey.

Accessing Your MySQL Database from the Web with PHP 9/30
In this chapter, learn how to access a database from the Web using PHP, read from and write to the database, and filter potentially troublesome input data.

Microsoft offers the 'SQL Server experience' 9/29
Microsoft has launched an SQL Server 2008 Experience web site offering new resources for customers and partners.

Add Your News

Receive news via our XML/RSS feed



Dbvisit (Avisit Solutions Ltd)
Disaster recovery for Oracle databases. Automated standby database management.

HP Oracle Database Machine (Oracle Corp)
Combined hardware (from HP) and software (from Oracle) platform is especially performance tuned for data warehousing in large Enterprises. Supports a potential performance bandwidth of up to 14 GB/sec.

FortiDB (Fortinet, Inc)
Vulnerability assessment platform especially targeted to DBs, including Oracle, DB2, SQL Server, Sybase. Available in appliance and software flavors.


Grant SELECT permissions on all tables in all databases
This code will loop through all user tables in all databases and grant select permissions on each table.

Wait Sessions
The Script lists the Session ID,Event Name,Time Waited on the Database.

Find every occurrence of a value in a database
This script will iterate every field within a database for every occurrence of a specified value.

Insert message into multiple files
This script will insert a message into a specific line of multiple files.

Reports with summary
When you use an ORDER BY clause in your SQL SELECT command, rows with the same value in the ordered column (or expression) are displayed together in your output. The purpose of these scripts is to provide a solution for suppressing duplicate values and computing summary lines.

Check rerun status of failed or cancelled jobs
This script will check the rerun status of failed or cancelled jobs and the job steps.


Latest Database Articles from DevX
SQL Server Sanity: Maintain Healthy Transaction Logs for Easy Data Recovery
Navigationless Database XML: Hierarchical Data Processing
Programatically Set or Change DataRow's RowState
Using PHP's MDB2_Schema, an XML-Based Database Schema Manager
Performance Point 2007 Installation, Part 2: Installing Monitoring Server







Latest Forum Threads
Database Journal Forum
Topic By Replies Updated
Setting up a Two-node SQL Server 2008 Cluster from the Command Prompt - Preparation lcole 0 September 16th, 04:17 PM
Microsoft Closes on DATAllegro, Opens Up on Data Warehouse Road Map lcole 0 September 16th, 04:16 PM
Continuent Launches Open Source Replication Solution for Oracle lcole 0 September 16th, 04:16 PM
Oracle Introduces “Inner Circle” Partner Initiative For Oracle CRM On Demand lcole 0 September 16th, 04:15 PM
DBA Support Forum
Topic By Replies Updated
Can't connect to X11 window server using abdel 3 September 17th, 09:45 AM
Err in Export gopu_g 3 September 17th, 09:40 AM
Database Recovery issue Mimas 16 September 17th, 09:26 AM

Hot Forum Threads
Database Journal Forum
Topic By Replies Updated
Help in Database Design - MS Access Ignorant 6 September 16th, 08:09 AM
Upload jobs failing on weekends Picha Pie 7 September 11th, 08:46 AM
Moving Data and SP from Ms SQL Server 7 to SQL Server 2005 MrPK 13 September 10th, 12:05 PM
How to create user login form (MS Access 2000 - 2003) meLady 35 September 9th, 03:33 AM
DBA Support Forum
Topic By Replies Updated
Database Recovery issue Mimas 16 September 17th, 09:26 AM
Cross Platform oracle db migration aj_usa 10 September 17th, 06:45 AM
DBMS_Stats error message kebrith 10 September 17th, 06:29 AM







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
IBM Whitepaper: Service Component Architecture Enabling XML Web Services for Java Programmers
IBM Whitepaper: Innovative Collaboration to Advance Your Business
Intel Article: Using Power & Display Context in the Intel Mobile Platform SDK
Internet.com eBook: Real Life Rails
IBM SCA Center Article: Simplifying Composite Applications with Service Component Architecture
Intel PDF: Quad-Core Impacts More Than the Data Center
Internet.com eBook: The Pros and Cons of Outsourcing
Go Parallel Article: Scalable Parallelism with Intel(R) Threading Building Blocks
Intel PDF: Analysis of Early Testing of Intel vPro in Large IT Departments
Internet.com eBook: Best Practices for Developing a Web Site
Intel PDF: IT Agility through Automated, Policy-based Virtual Infrastructure
IBM CIO Whitepaper: The New Information Agenda. Do You Have One?
Microsoft Article: BitLocker Brings Encryption to Windows Server 2008
IBM Whitepaper: Service Component Architecture & Java EE Integration
Microsoft Article: RODCs Transform Branch Office Security
Go Parallel Article: James Reinders on the Intel Parallel Studio Beta Program
Avaya Article: Advancing the State of the Art in Customer Service
IBM Whitepaper: How are other CIOs driving growth?
Adobe Acrobat Connect Pro: Web Conferencing and eLearning Whitepapers
Avaya Article: Avaya AE Services Provide Rapid Telephony Integration with Facebook
Go Parallel Article: Getting Started with TBB on Windows
HP eBook: Storage Networking , Part 1
MORE WHITEPAPERS, EBOOKS, AND ARTICLES
Webcasts
Go Parallel Video: Intel(R) Threading Building Blocks: A New Method for Threading in C++
HP Video: Is Your Data Center Ready for a Real World Disaster?
HP On Demand Webcast: Virtualization in Action
Go Parallel Video: Performance and Threading Tools for Game Developers
Rackspace Hosting Center: Customer Videos
Intel vPro Developer Virtual Bootcamp
HP Disaster-Proof Solutions eSeminar
HP On Demand Webcast: Discover the Benefits of Virtualization
MORE WEBCASTS, PODCASTS, AND VIDEOS
Downloads and eKits
Download: IBM WebSphere Application Server V7.0 Feature Pack for Service Component Architecture
Actuate Download: Free Visual Report Development Tool
Microsoft Download: Silverlight 2 Software Development Kit Beta 2
30-Day Trial: SPAMfighter Exchange Module
Red Gate Download: SQL Toolbelt
IBM SCA Download: Start Building SCA Applications Today
Iron Speed Designer Application Generator
Microsoft Download: Silverlight 2 Beta 2 Runtime
MORE DOWNLOADS, EKITS, AND FREE TRIALS
Tutorials and Demos
IBM IT Innovation Article: Green Servers Provide a Competitive Advantage
Microsoft Article: Expression Web 2 for PHP Developers--Simplify Your PHP Applications
Featured Algorithm: Intel Threading Building Blocks - parallel_reduce
MORE TUTORIALS, DEMOS AND STEP-BY-STEP GUIDES