Newsletter

Toad World PIPELINE
Monthly Newsletter Archives

PIPELINE is the monthly newsletter for members of Toad World and DBPedia communities. Each month we feature database tech articles, techniques and tips for improving software development as well as insights on what's happening in the world of Toad.

Read past PIPELINE Newsletters:

Toad World PIPELINE - April 2012 Issue
- Feature Article: Toad for Data Analysts v3.1 is Here!
- Oracle: How to Recover from an Error while Restoring SPFILE
  by Kamran Agayev
- SQL Server: Top 10 Technological Time Savers for Keeping in Touch
  by Andy Lohn
- Emerging Technologies: Five Reasons to Use NoSQL
  by Jeremiah Peschka
Toad World PIPELINE - March 2012 Issue
- Feature Article: Become a Data Analyst Rock Star – TDA v3.1 Has Your All-Access Pass
- Oracle: Getting APEX to Play with Ref Cursors
  by Mike Smithers
- SQL Server: Database Mirroring Failover Considerations
  by Chris Shaw
- Emerging Technologies: Building Your Own Federated Database
  by Jeremiah Peschka
Toad World PIPELINE - January/February 2012 Issue
- Feature Article: Quest® Backup Reporter for Oracle Is Now Free with Toad® DBA Suite for Oracle (and RAC Edition)
- Oracle: Disaster Recovery in the Cloud
  by Patrick Schwanke
- IBM DB2: Toad for DB2 - Subsystem and Database Information
  by Udo Brede
- Emerging Technologies: Getting Started with Apache Pig
  by Guy Harrison
Toad World PIPELINE - December 2011 Issue
- Feature Article: Toad Simplifies Your Cloud-Data-Related Tasks for Free!
- Oracle: Dumping an Oracle Data Block, Reading the Output, and Doing Some Math
  by Kamran Agayev
- SQL Server: SQL Fingertips
  by Michael Swart
- Emerging Technologies: Developing a Cost Model for Cloud Applications
  by Buck Woody
Toad World PIPELINE - November 2011 Issue
- Feature Article: Catch the Toad Virtual Expo Today!
- Oracle: Setting SDU Size (mainly in Oracle 11.2)
  by Martin Nash
- SQL Server: Denormalizing Dimension Tables
  by James Serra
- Emerging Technologies: Comparing Hadoop Oracle Loaders
  by Guy Harrison
Toad World PIPELINE - October 2011 Issue
- Feature Article: Toad for Data Analysts 3.0 is Here! Cross-Platform Querying and Data Analysis Just Got Simple
- Oracle: Oracle's APPEND Hint - Faster INSERTs But Mind the Logging!
  by Jeff Smith
- SQL Server: Migrating Data to SQL Azure Using SSIS
  by Scott Klein
- Emerging Technologies: Secondary Indexes in Riak
  by Rusty Klophaus
- Software Development Tips & Techniques: Use White-Box and Black-Box Testing
  by Tom Mochal
Toad World PIPELINE - September 2011 Issue
- Feature Article: Get More Visibility, Better Code Quality, and Increased Productivity with Toad® for Oracle v11!
- Oracle: Easy, Fast and Reliable Oracle Backup and Recovery with RMAN
  by Quest Software
- Oracle: How to resolve Root Certificate Expiry Issue for Enterprise Manager - Database Control
  by Zaffer Khan
- Software Development Tips & Techniques: Four Basic Techniques for Gathering Requirements
  by Tom Mochal
Toad World PIPELINE - August 2011 Issue
- Feature Article: Frustrated with Conventional Code Reviews
- Emerging Technologies: Migrating from Elastic MapReduce to a Cloudera’s Distribution Including Apache Hadoop Cluster
  by Jennie Cochran-Chinn and Joe Crobak
- Emerging Technologies: MongoDB, Oracle and Toad for Cloud Databases
  by Guy Harrison
- Software Development Tips & Techniques: Ensure You Have Sold Architecture Foundation
  by Tom Mochal
Toad World PIPELINE - July 2011 Issue
- Feature Article: New Quest® Tools Simplify Microsoft Azure Infrastructure and Account Management
- Oracle: Oracle Database Registry Components
  by Julian Dyke
- Oracle: How to Read ERRORSTACK Output
  by Tanel Poder
- Software Development Tips & Techniques: Recognize Good and Bad Requirements
  by Tom Mochal
Toad World PIPELINE - June 2011 Issue
- Feature Article: Save up to 50 Percent on the new Toad Multi-DB Suites
- DB2: Toad for DB2: Two Nice Helpful Options
  by Udo Brede
- Emerging Technologies: Statistical Analysis of Oracle Performance Data using R
  by Guy Harrison
- Software Development Tips & Techniques: Why Don't Organizations Use Good Lifecycle Processes
  by Tom Mochal
Toad World PIPELINE - May 2011 Issue
- Feature Article: Quest Backup Report for Oracle is now Generally Available
- Emerging Technologies: Ten Common Hadoopable Problems
  by Cloudera
- Emerging Technologies: Consistency Models in Non-Relational Databases
  by Guy Harrison
- Software Development Tips & Techniques: Practice These Solid Programming Techniques
  by Tom Mochal
Toad World PIPELINE - April 2011 Issue
Toad World PIPELINE - March 2011 Issue
- Feature Article: How to Navigate the New World of Database Technologies
- Oracle: Using the Oracle ASM Cluster File System (Oracle ACFS) on Linux
  by Jeff Hunter
- Oracle: RAC Be Nimble, RAC Be Quick
  by Bert Scalzo
- Software Development Tips & Techniques: Perform User Acceptance Testing
  by Tom Mochal
Toad World PIPELINE - February 2011 Issue
Toad World PIPELINE - January 2011 Issue
Toad World PIPELINE - December 2010 Issue
Toad World PIPELINE - November 2010 Issue
Toad World PIPELINE - October 2010 Issue
Toad World PIPELINE - September 2010 Issue
Toad World PIPELINE - August 2010 Issue
- Feature Article: Toad Idea Pond
- Oracle: Patching and Upgrading Oracle Clusterware
  Upcoming Content from Knowledge Expert for Oracle
- Oracle: How Managers Can Help Their Developers Write Excellent Code
  by Steven Feuerstein
- Software Development Tips & Techniques: Get the Support Organization Involved Early on IT Projects
  by Tom Mochal
Toad World PIPELINE - July 2010 Issue
- Feature Article: Exciting New Toad Feature - Oracle RMAN Backup Reporting and Analysis
- Oracle: Installing Oracle Clusterware
  Upcoming Content from Knowledge Expert for Oracle
- Oracle: Troubleshooting Oracle Enterprise Manager 10G
  by Jeff Hunter
- Software Development Tips & Techniques: Create a Testing Strategy For Your Project
  by Tom Mochal
Toad World PIPELINE - June 2010 Issue
- Feature Article: What in the World are Predictive Diagnostics?
- Oracle: The Fundamentals of Maintaining correct PL/SQL
  by Steven Feuerstein
- Oracle: Database Disaster Recovery using only RMAN Backups
  by Zaffer Khan
- Software Development Tips & Techniques: In Praise of Automated testing Tools
  by Tom Mochal
- The Confident Technical Leader: Open and Honest Communication
  by John Weathington
Toad World PIPELINE - May 2010 Issue
- Feature Article: Toad® Extension for Visual Studio Is Here!
- Oracle: Top 10 Strategies for Oracle Database Performance (Part 4)
  by Guy Harrison
- Software Development Tips & Techniques: Eliciting Requirements with Group Interviews
  by Tom Mochal
- The Confident Technical Leader: How to Run a Technical Meeting
  by John Weathington
Toad World PIPELINE - April 2010 Issue
- Feature Article: Online Conference for Developers
- Oracle: Top 10 Strategies for Oracle Database Performance (Part 3)
  by Guy Harrison
- DB2: Assuring Data Integrity in DB2
  by Craig Mullins
- Software Development Tips & Techniques: Create a Security Risk Assessment for your Project
  by Tom Mochal
- The Confident Technical Leader: Focusing on Results
  by John Weathington
Toad World PIPELINE - March 2010 Issue
- Feature Article: The Future of Oracle Development in Visual Studio Is Coming
- Oracle: Top 10 Strategies for Oracle Database Performance (Part 2)
  by Guy Harrison
- Oracle: Integrating Workload Replays into Database Change Management
  by Bert Scalzo
- Oracle: Automatic RMAN Backup with Oracle Scheduler
  by Johannes Ahrends
- Software Development Tips & Techniques: Gathering Requirements through a JAD Session
  by Tom Mochal
- The Confident Technical Leader: Becoming a Great Technical Leader
  by John Weathington
Toad World PIPELINE - January/February 2010 Issue
- Feature Article: A New Toad® DBA Suite for Oracle RAC
- Oracle: Top 10 Strategies for Oracle Database Performance (Part 1)
  by Guy Harrison
- Oracle: Using Toad Reports Manager to Enhance Oracle E-Business Suite (OEBS) Management
  by Gary Piper
- Oracle: Being Successful with Toad and RMAN
  by Johannes Ahrends
- Software Development Tips & Techniques: Develop Acceptance Criteria to Ensure no Surprises
  by Tom Mochal
Toad World PIPELINE - December 2009 Issue
- Feature Article: Toad® the Next Generation
- Oracle: Database Replay Overview
  by Knowledge Xpert for Oracle
- DB2: The Top 10 Things a DBA Should Know About Toad for DB2
  by Jim Wankowski
- Software Development Tips & Techniques: Use a Prototype to Elicit Requirement Roles
  by Tom Mochal
Toad World PIPELINE - November 2009 Issue
- Feature Article: A Perfect 10 for Toad® Version 10
- Oracle: OCR File and Voting Disk Administration by Example
  by Jeff Hunter
- DB2: The Definition of Database Performance
  by Craig Mullins
- Java: Proactive Performance Tuning for Enterprise Java Developers
  by Steven Haines
- Software Development Tips & Techniques: Common Project Roles
  by Tom Mochal
Toad World PIPELINE - October 2009 Issue
- Feature Article: Toad® and JProbe® Bundles
- Oracle: PLSQL News You Can Use
  by Steven Feuerstein
- DB2: An Overview of Mainframe Specialty Processors
  by Craig Mullins
- Software Development Tips & Techniques: Resolving "Subtle" Program Bugs
  by Tom Mochal
Toad World PIPELINE - September 2009 Issue
- Feature Article: Toad for Data Analysts V2.5 is Here!
- Oracle: Diagnosing and Solving Oracle Parsing Issues
  by Guy Harrison
- Oracle: Toad and Oracle's Flashback Technologies
  by Johannes Ahrends
- Oracle: Toad for the Oracle DBA
  by Bert Scalzo
- Software Development Tips & Techniques: Tips for General Design Approach
  by Tom Mochal
Toad World PIPELINE - August 2009 Issue
- Feature Article: Toad for Data Analysts V2.5 is Coming!
- Oracle: Range Partitioning of an Existing Table
  by Darko Egersdorfer
- Oracle: Optimizing the 11G Result Set Cache
  by Guy Harrison
- Oracle: Extending Toad for Oracle's Code Xpert With the Sonarsource Dashboard
  by Olivier Gaudin
- SQL Server: Developing Something for Nothing with SQL Server
  Jeremiah Peschka
- Software Development Tips & Techniques: Use Active Listening Skills When Gathering Requirements
  by Tom Mochal
Toad World PIPELINE - July 2009 Issue
- Feature Article: Toad for Oracle 10 Offers the Enhancements You Requested
- Oracle: My Journey from 9.0.1 to 9.2.0.8
  by Zaffer Khan
- Oracle: Preliminary TPC-C Results
  by Mike Ault
- DB2: DB2, Stored Procedures, Cobol, and Result Sets
  by Robert Catterall
- Software Development Tips & Techniques: Understanding The Nature of Requirements
  by Tom Mochal
Toad World PIPELINE - June 2009 Issue
- Feature Article: Toad Virtual Expo 2009
- Oracle: Installing Grid Control on RHEL 5 With 11G Database Repository
  by Jeff Hunter
- Oracle: Partitioning in 11G
  by Jacques Kilchoer & Thomas Szekely
- Software Development Tips & Techniques: Let's Look at the Role of an Analyst
  by Tom Mochal
Toad World PIPELINE - May 2009 Issue
- Feature Article: Boost your Toad Knowledge
- Oracle: Memory Management in 11G
  by Patrick Schwanke
- DB2: The Mystery of DB2 Sorts
  by Bonnie Baker
- JAVA: Advanced Memory Analysis
  by Steven Haines
- Software Development Tips & Techniques: Understand the Value of Project Lifecycle Processes
  by Tom Mochal
Toad World PIPELINE - April 2009 Issue
- Feature Article: Using Toad DBA Suite for Oracle with Oracle Enterprise Manager
- Oracle: The Humble Count Function
  by John Russell
- Oracle: Explain Plan Tips
  by Dan Hotka
- DB2: The Mystery of DB2 for Z/OS Index-Only Updates and Deletes
  by Bonnie Baker
- Software Development Tips & Techniques: Use Caution When Downloading Components From The Web
  by Tom Mochal
Toad World PIPELINE - March 2009 Issue
- Feature Article: Toad Around the World
- Oracle: Good DBAs Work Smarter – Not Harder
  by John Pocknell
- Oracle: 10 Simple Steps for Boosting Database Performance in a Virtualized Environment
  by Bert Scalzo
- DB2: The Mystery of the DB2 SIX Lock
  by Bonnie Baker
- MySQL: How much memory can MySQL use in the worst case?
  by Baron Schwartz
- Software Development Tips & Techniques: Convert Critical Data to Prepare for the New Solution
  by Tom Mochal
Toad World PIPELINE - February 2009 Issue
- Feature Article: What version of Toad should I be using?
- Oracle: Taming Queries from Hell
  by Bert Scalzo
- DB2: DECFLOAT
  by George Baklarz for Knowledge Xpert
- SQL Server: Backup and Restore
  by Brent Ozar
- Software Development Tips & Techniques: Terminating a Project Successfully
  by Tom Mochal
Toad World PIPELINE - January 2009 Issue
- Feature Article: Toad World Hosts Expert Blogs
- Oracle: ORACLE VMWARE = SUCCESS
  by Bert Scalzo
- Oracle: Oracle Grid Computing
  by Surbhi Jain
- Oracle: EXPLAIN THIS!
  by Jeff Smith
- Software Development Tips & Techniques: Reviewing the Application Technical Design
  by Tom Mochal
Toad World PIPELINE - December 2008 Issue
- Feature Article: Resources still available for Toad Virtual Expo 2008
- Oracle: Getting Started with Oracle in the Amazon Cloud
  by Guy Harrison
- DB2: It's Not All Bad to be a Space Cadet
  by Doug Williams
- Java: Performance Analysis in Eclipse
  by Steven Haines
- Software Development Tips & Techniques: Many Organizations Have Responsibility for Security
  by Tom Mochal
Toad World PIPELINE - November 2008 Issue
- Feature Article: Toad Virtual Expo 2008
- Oracle: Disabling Oracle's AWR
  by Bert Scalzo
- DB2: On DB2 and Table-Pinning
  by Robert Catterall
- MySQL: Automatic MySQL Backup Script
  by Dagon Design
- Software Development Tips & Techniques: Use One-on-One Interviews to Solicit Requirements
  by Tom Mochal
Toad World PIPELINE - October 2008 Issue
- Feature Article: Toad for Oracle V9.7 now includes Toad for Data Analysis
- Oracle: Thanks for the Memory
  by Guy Harrison
- Oracle: RAC the Casba
  by Bert Scalzo
- MySQL: A Quick Look at MySQL 6.0's New Backup
  by Robin Schumacher
- Software Development Tips & Techniques: Develop Information Retention Criteria for Data on your Project
  by Tom Mochal
Toad World PIPELINE - September 2008 Issue
- Feature Article: Best Toad Story Winners Announced
- Oracle: Enabling Archive Logs in a RAC Environment
  by Jeff Hunter
- DB2: DB2 LUW V9.5 SQL Cookbook
  by Graeme Birchall
- MySQL: A Look at Falcon Diagnostic Tables
  by Robin Schumacher
- Software Development Tips & Techniques: Monitor Your Solution Before Turning Over to Support
  by Tom Mochal
Toad World PIPELINE - August 2008 Issue
- Feature Article: Discovering the hidden treasures of Toad
- Oracle: Back Up and Recover
  by Sushma Jagannath
- DB2: Don't Be Memory Misers
  by Robert Catterall
- Java: Continuous Performance Management in Eclipse
  by Steven Haines
- Software Development Tips & Techniques: Create a Testing Plan for your Project
  by Tom Mochal
Toad World PIPELINE - July 2008 Issue
- Feature Article: Toad is Turning 10 - Join the Party!
- Oracle: Make Oracle Work Smarter, Not Harder
  by Guy Harrison
- DB2: Performance Automation in DB2 LUW
  by Jim Wankowski
- MySQL: Query Performance Optimization
  by Baron Schwartz
- Software Development Tips & Techniques: Design Your Solution for Reuse
  by Tom Mochal
Toad World PIPELINE - June 2008 Issue
- Feature Article: Practical Best PL/SQL Video Series
- Oracle: How To Baseline Compliance
  by John Weathington
- DB2: Elevating the DBA Role
  by Robert Catterall
- MySQL: Tuning MySQL SQL Code
  by Guy Harrison
- Software Development Tips & Techniques: Use Models for Visualizing Processes
  by Tom Mochal
Toad World PIPELINE - May 2008 Issue
- Feature Article: Quest Software at COLLABORATE 2008
- Oracle: Troubleshooting Unsuccessful Configuration Scripts by Tracing the Operating System Call
  by Harish Kumar Kalra
- DB2: Performance Automation in DB2 LUW
  by Jim Wankowski
- Software Development Tips & Techniques: There are Many Organizations with a Role in Security
  by Tom Mochal
Toad World PIPELINE - April 2008 Issue
- Feature Article: Using Toad and Quest Code Tester for quick data analysis
- Oracle: Which Query Implementation Runs the Slowest?
  by Steven Feuerstein
- DB2: Managing Performance in a Heterogeneous DB2 Environment
  by Jim Wankowski
- Software Development Tips & Techniques: Techniques for Creating Solid Report Layouts
  by Tom Mochal
Toad World PIPELINE - March 2008 Issue
- Feature Article: What's New in Toad World? A lot. And it's not just for Toad users
- Oracle: Simultaneous Program Execution in PL/SQL
  by Steven Feuerstein
- DB2: Table Spaces And Locking Levels, Part 3
  by Bonnie Baker
- MySQL: Using MySQL Stored Functions
  by Guy Harrison
- Software Development Tips & Techniques: Create Use Cases to Define Processes from a Client Perspective
  by Tom Mochal
Toad World PIPELINE - February 2008 Issue
- Feature Article: Toad for IBM DB2 3.1 is here!
- Oracle: Contention the Proverbial Bottleneck
  by Guy Harrison
- DB2: Table Spaces And Locking Levels, Part 2
  by Bonnie Baker
- MySQL: A Practical Look at the MySQL Query Cache
  by Robin Schumacher
- Software Development Tips & Techniques: Use Regression Testing to Validate New Changes
  by Tom Mochal
Toad World PIPELINE - January 2008 Issue
- Feature Article: Work Smarter, Not Harder with the New Toad DBA Suite for Oracle
- Oracle: Draw a Map of Variables and Subprograms Using PL/Scope
  by Arup Nanda
- DB2: Table Spaces And Locking Levels, Part 1
  by Bonnie Baker
- Software Development Tips & Techniques: Prepare Properly for Systems Implementation
  by Tom Mochal

Toad World 360 - Newsletters

Toad World 360° was the previous monthly newsletter for members of Toad World. View last year's Toad World 360 newsletters:

Don't wait for us to post the newsletter. Get the Toad World PIPELINE newsletter emailed to you each month by subscribing today. It's free and you can unsubscribe at any time.