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
PDAs
PC Notebooks
Printers
Monitors

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

Marketplace Partners
Be a Marketplace Partner


Compare Project Management Software Now!




Read “The Oracle DBA of Tomorrow”

Webcast: Governing IT in a Green World


Webcast:Implementing a Green Data Center


Meeting the Challenge of SMB Storage




internet.commerce
Be a Commerce Partner
Promos and Premiums
KVM Switches
Memory Upgrades
Home Improvement
Auto Insurance Quote
Computer Deals
GPS
Server Racks
Corporate Gifts
Promotional Golf
Hurricane Shutters
Online Universities
Find Software
PDA Phones & Cases




Blue Coat: We Grow One Packet at a Time

Rhapsody Bets DRM-Free Downloads Can Foil iTunes

Heavies Joining Against Patent Suits?

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

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


Windows Server Catalog: Certified Servers. Search the Windows Server 2008 catalog to find servers you can deploy with confidence.


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
PDF: Storage Is Changing Fast--Are You Ready?
Sponsored by HP
The storage landscape is headed for dramatic change, thanks to new technologies like Fibre Channel over Ethernet (FCoE), pNFS, object-based storage and SAS that will affect everything from NAS and SANs to disk drives. Get the knowledge you need to make the most of your storage environment, now and in the future. >>

View the Instruction Pipeline with AMD CodeAnalystTM Performance Analyzer
Sponsored by AMD
With AMD's Instruction Based Sampling technology, it's easy for you to see how your program instructions are being executed through the processor pipeline. With CodeAnalyst Performance Analyzer you'll know right away whether your code is moving through the pipeline or stalling it out. Learn more. Click here.
Learn more at AMD Developer Central.

 
Recent Headlines
Oracle
Looking at Memory Usage for Oracle Processes 7/03
Oracle Database 11g: Database Replay, Part 3 6/30
Product Review – Toad Data Modeler 3 6/25
more...
MS SQL
SQL Server Profiler Part 2 7/02
Check your SQL Server using Windows PowerShell – Part II 7/01
Mastering OLAP Reports: Parameterizing Number of “Look Back” Periods with the MDX LastPeriods() Function, Part II 6/27
more...
MS Access
Secure Microsoft Access Passwords and Encryption in Access 2007 6/16
Posting Microsoft Access Information “Into the cloud” 5/16
“In the cloud” ~ Using Microsoft Access to query and update Web sites 4/14
more...
DB2
DB2 and Visual Studio 2008: Getting Started 6/11
IBM DB2 at 25 6/10
DB2 9.5 and IBM Data Studio - Part 10: Building Stored Procedures 5/19
more...

Looking at Memory Usage for Oracle Processes 7/03
When an Oracle instance starts, or an application uses the Oracle database, the associated Oracle processes are allocated and consume memory. Learn how to use the V$PROCESS view and V$PROCESS_MEMORY to look at this memory usage.

SQL Server Profiler Part 2 7/02
Part 1 of this series discussed the difference between a Trace and Profiler. This installment examines additional preconfigured templates, how to synchronizing Profiler and Perfmon and how to run Profiler as a scheduled task.

Check your SQL Server using Windows PowerShell – Part II 7/01
Part two of this series illustrates how to access the Windows service on a remote machine using Windows PowerShell and WMI-Object to see if all of the windows services related to SQL Server are up and running.

Oracle Database 11g: Database Replay, Part 3 6/30
The final article in this series illustrates how to use Oracle Database 11gR1's new Database Replay (DBR) features to capture and prepare a workload from a current Oracle 10gR2 single-instance database environment and then replay that identical workload in an Oracle 11gR1 Real Application Clusters (RAC) testing environment.


Rebuild Only the Indexes that Need Help 7/03
Don’t give in to the temptation of rebuilding your indexes at the first evidence of fragmentation. Instead, use the rebuild_indexes_by_db stored procedure to tackle only the indexes that actually need help.

SQL Server and the Windows Server 2008 Firewall 7/03
We’ve long recommended that customers use the Windows Firewall to protect SQL Server installations. Starting with Windows XP/SP2, and continuing with Windows Vista, the firewall has been...

Should You Consolidate Your Database? 7/03
Database consolidation can have a huge impact on IT budgets by lowering hardware and database license costs. But the perils are numerous.

SQL Server 2008 Feature Pack RC0 7/02
The SQL Server 2008 Feature Pack for RC0 is now live...

Add Your News

Receive news via our XML/RSS feed



MicroOLAP Database Designer for MySQL / PostgreSQL (microOLAP Technologies LTD)
Visual development system for MySQL or PostgreSQL database design and modeling.

JasperSoft Business Intelligence Suite (JasperSoft Corp)
Open source BI platform features reporting (embedded engine and server), analysis, and data integration components. Now with an AJAX-based GUI that can be embedded in Web apps.

Postgres Plus Advanced Server (EnterpriseDB Corp)
Oracle compatible database built on open source PostgreSQL.


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

Find all numbers in a string
This function finds all the numbers in a string.

Email Validation
This procedure returns 0 if invalid mail ID else 1.

Delete all duplicate records in a table
This script will delete all duplicate records in a table.


Latest Database Articles from DevX
Use UNION ALL Instead of UNION
Persisting Data in Your Windows Mobile Device
Generating Reports and Statistics in PHP
Leveraging Silverlight 2 with SQL Server and XML
Build Occasionally Connected Systems Using Sync Services for ADO.NET v1.0

Whitepaper: Rightsizing Blades for the Midmarket. Sponsored by HP.
Try the SQL Toolbelt and get a copy of Grant Fritcheys’s book on the art of high-performance SQL code.
Whitepaper: The Cost Advantages of Blade Servers. Sponsored by HP.
Intel Whitepaper: Comparing Multi-Core Processors for Server Virtualization
Intel eBook: Managing the Evolving Data Center


Latest Forum Threads
Database Journal Forum
Topic By Replies Updated
SSIS help - basics nijojo 0 July 3rd, 08:27 PM
Looking at Memory Usage for Oracle Processes lcole 0 July 3rd, 05:56 PM
Rebuild Only the Indexes that Need Help lcole 0 July 3rd, 05:55 PM
SQL Server and the Windows Server 2008 Firewall lcole 0 July 3rd, 05:54 PM
DBA Support Forum
Topic By Replies Updated
RMAN - removing old catalog entries KenEwald 11 July 3rd, 02:28 PM
RMAN - advisable maintenance? KenEwald 2 July 3rd, 02:27 PM
Voting/OCR how to take backup on AIX muzammil.dba 1 July 3rd, 02:26 PM

Hot Forum Threads
Database Journal Forum
Topic By Replies Updated
SQL help needed JADE 7 July 2nd, 09:17 AM
Simple Query, but so slow. Any Advice for me? o1webdawg 8 July 1st, 10:52 PM
How to create user login form (MS Access 2000 - 2003) meLady 23 July 1st, 04:01 AM
Expired account tiz 8 June 26th, 09:49 AM
DBA Support Forum
Topic By Replies Updated
RMAN - removing old catalog entries KenEwald 11 July 3rd, 02:28 PM
Import / Tablespace NetCohort 8 July 3rd, 10:17 AM
Inexplicably high phyisical reads on table causes query delay suhasd75 7 July 3rd, 06:48 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 eBook: Planning a Service Oriented Architecture
IBM eBook: Choosing the Right Architecture--What It Means for You and Your Business
Microsoft Article: Will Hyper-V Make VMware This Decade's Netscape?
Avaya Article: Using Intelligent Presence to Create Smarter Business Applications
Intel Go Parallel Article: Getting Started with TBB on Windows
Microsoft Article: 7.0, Microsoft's Lucky Version?
Avaya Article: How to Feed Data into the Avaya Event Processor
IBM Article: Developing a Software Policy for Your Organization
Microsoft Article: Managing Virtual Machines with Microsoft System Center
Intel Go Parallel Article: Intel Threading Tools and OpenMP
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
HP Video: StorageWorks EVA4400 and Oracle
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
Red Gate Download: SQL Toolbelt and free High-Performance SQL Code eBook
Iron Speed Designer Application Generator
MORE DOWNLOADS, EKITS, AND FREE TRIALS
Tutorials and Demos
Silverlight 2 App and Walkthrough: Leverage Silverlight 2 with SQL Server and XML
IBM Article: Enterprise Search--Do You Know What's Out There?
HP Demo: StorageWorks EVA4400
Microsoft Article: The Progress and Promise of Deep Zoom
Microsoft How-to Article: Get Going with Silverlight and Windows Live
MORE TUTORIALS, DEMOS AND STEP-BY-STEP GUIDES