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
 
Search
 



» 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:Implementing a Green Data Center


Webcast: Governing IT in a Green World


Meeting the Challenge of SMB Storage




internet.commerce
Be a Commerce Partner
KVM Switch over IP
Online Universities
Promotional Products
Disney World Tickets
Car Donations
Cell Phones
Desktop Computers
Memory
Best Price
Imprinted Gifts
Laptops
Baby Photo Contest
Online Shopping
Shop Online




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


Q&A with Lutz Ziob, GM of Microsoft Learning. Learn how IT professionals can become "certified heroes" within their enterprises by getting trained and certified in Windows Server 2008.


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. >>

Featured Solutions for Technology Professionals from Internet.com
eBook: Storage Networking 2, Configuration and Planning
Sponsored by HP
Learn best practices and cover the general concepts you must know before configuring SAN-attached storage. The most critical part of setting up a SAN is configuring each individual disk array. This guide examines configurations for SAN-attached servers and disk arrays, and also includes a look at the future of IP storage. Learn more.

 
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: The Cost Advantages of Blade Servers. 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: Rightsizing Blades for the Midmarket. Sponsored by HP.
Intel eBook: Managing the Evolving Data Center
Intel Whitepaper: Wireless Technologies and e-Learning--Bridging the Digital Divide


Latest Forum Threads
Database Journal Forum
Topic By Replies Updated
user connections DLu 2 July 1st, 02:56 PM
Don't run the SQL Server Account as Local Administrator ?? Veronica 2 July 1st, 02:14 PM
SQL help needed JADE 6 July 1st, 01:54 PM
MySQL admin tools ? anselme 1 July 1st, 01:49 PM
DBA Support Forum
Topic By Replies Updated
RMAN - removing old catalog entries KenEwald 0 July 1st, 02:58 PM
query required ahmsha1 0 July 1st, 02:33 PM
Oracle Updates Entire Family of Oracle Berkeley DB Embeddable Databases lcole 0 July 1st, 10:12 AM

Hot Forum Threads
Database Journal Forum
Topic By Replies Updated
SQL help needed JADE 6 July 1st, 01:54 PM
Simple Query, but so slow. Any Advice for me? o1webdawg 6 July 1st, 12:22 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
Oracle 10g RAC muzammil.dba 6 July 1st, 01:41 AM
Unable to start crs in a 10g RAC divroro12 8 June 30th, 10:34 AM
listener error reeshe 6 June 30th, 06:15 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