Centerfield Technology, Inc
3131 Superior Dr NW
Rochester, MN 55901

Newsletter Archive

Tuesday October 9, 2012 - COMMON 2012 Promo
Download (450KB)

Monday April 30, 2012 - Spring issue

  • A Responsive Note from Mark Holm
  • HomeRun Customer Feedback
  • HomeRun Suite 8.0
  • Introducing New Grounds' Crew
  • Databeam 3.0
  • Inside the Batter's Cage
  • Tech News: Hidden Gem
Download (3.40MB)

Tuesday April 19, 2011 - Databeam announcement issue

  • New Tool Offering
  • Webinar signup
  • Real-Time DB2 article
  • HomeRun Summer Special offer

Download (Size: 4.96MB)

Tuesday June 8, 2010 - Summer issue

  • HomeRun 7.0
  • CTO Memo
  • New Training Videos
  • HomeRun Special offer

Download (Size: 515413B)

Tuesday May 5, 2009 - DB2 and SQL News for i Professionals

  • .Net and iSeries Application Architecture
  • Enhancing SQL Triggers
  • The Unconstrained Primary Key
  • Finding Differences Between Two Libraries

Download (Size: 1626467B)

Wednesday February 4, 2009 - SPECIAL ISSUE

  • The Keys to the Kingdom by Daniel Cruikshank
    Best practices for unique database indexes. These best practices improve data security, performance, and application design.
  • SQL Stored Procedures by Elvis Budimlic
    Tips for better performance.
  • Choosing Between Hardware and Software Encryption:
    An interview with Protegrity Corporation CTO Ulf Mattson

Download (Size: 1219646B)

Friday January 16, 2009 - IBM i tips such as

  • Connecting DB2 for i and .NET
  • Sequential Thinking about Random I/O
  • Budget Efficiency through Database Efficiency
  • Optimistic Locking and DB2 for i 6.1

Download (Size: 1150967B)

Wednesday September 10, 2008 - SQL indexology and DB2 performancing tips such as

  • Clustered data for improved performance
  • Performance tuning QSQSRVR jobs
  • Getting rid of unused indexes and keyed LFs
  • Top 10 reasons you should create your own SQL indexes for JD Edwards

Download (Size: 1806000B)

Thursday June 12, 2008 - DB2, POWER performance and SQL tips such as

  • Application Modernization via Data Modernization
  • Server Mode Mysteries
  • Controlling Temporary Storage Consumption

Download (Size: 806000B)

Thursday April 24, 2008 - Hot Topics and Cool Insights for i Professionals

  • V6R1 Index Enhancements
  • Run SQL Scripts-the oft overlooked solution
  • DB2 Web Query: Defining Metadata
  • Visual Explain: the history and the practice

Download (Size: 614000B)

Thursday February 14, 2008 - Database, performance and SQL tips for IBM System i

  • SQL JOINS Primer
  • Data types in V6R1
  • Flirting with DB2 Web Query for System i

And a special article by Birgitta Hauser:Date Formats-Pitfalls in External User Defined Functions
Download (Size: 436000B)

Wednesday December 12, 2007 - SQL tips and tricks for power users - such as

  • MTI vs IDX
  • What Was That Name?
  • System i Database Modernization to SQL Now Automated

Download (Size: 768000B)

Thursday October 11, 2007 - Great reading! Useful tips and information - such as

  • SQE vs CQE Part II
  • Chaos in IT

Download (Size: 1090000B)

Tuesday, July 31, 2007 - Great summertime reading! Useful tips and information - such as

  • Good SQL in Bad Programs
  • Delete Duplicate Rows
  • Case for the Autonomic DBA
  • Create TABLE like
  • Successful Business Intelligence

Download (Size: 550860B)

Tuesday, May 1, 2007 - Full of tips and information designed to help - such as

  • The Four Types of Indexes
  • Getting data out of the other job's QTEMP
  • DB2 Expert on a Silver Platform
  • mySQL on System i
  • Control Queries - Don't Tune Them

Download (Size: 570368B)

Monday, February 12, 2007 - Full of tips and information designed to help - such as

  • SQL in CL...What a Variety!
  • ELAs: Trimming License Costs
  • Delete Old IFS Files

Download (Size: 446367B)

Tuesday, December 12, 2006 - Full of tips and information designed to help - such as

  • Some Index Usage No-No's
  • I/O, I/O, its off to the disk we go
  • Leverage and Tuning

Download (Size: 1083770B)

Tuesday, October 10, 2006 - Tips, tricks and treats designed to help

  • Disk Space: Strategy & Tactics
  • Falling Off the Cliff - Part Deux
  • Make Your UDFs Scream

Download (Size: 291134B)

Thursday, August 10, 2006

iSUMMER READING for those who can't get enough SQL tuning tips. Announcements, news, tricks and more...

Download (Size: 489426B)

Wednesday, June 14, 2006

Great summer technical reading from the pros in Rochester...and Germany!

Download (Size: 509211B)

Tuesday, April 25, 2006

INSIDE THIS BONUS ISSUE: DBMON—SQE vs CQE, Oh,DB2 UDB for iSeries, why are you so case-sensitive?, Giving Logical Files the Slip **11-PAGE BONUS** Auto-Increment and Unique Identifier

Download (Size: 928532B)

February/March 2006

** Database Goodies for V5R4
** Top 5 Reasons to Create an Index
** STRSQL Conundrum

Download (Size: 336422B)

Monday, December 05, 2005

Full of tips and information designed to help - such as: SOA, Speed and DB2, Customized QAQQINI file for specific ODBC/JDBC users, and more...

Download (Size: 116926B)

Friday, October 14, 2005

Tips, tricks and more from the SQL experts at CTI

Download (Size: 464795B)

Tuesday, August 09, 2005

Tips from our SQL experts

Download (Size: 529942B)

Tuesday, June 07, 2005

Tips from the SQL iSeries Pros

Download (Size: 1502161B)

Friday, April 01, 2005

An in-depth look into iSeries performance

Download (Size: 731838B)

Question / Quote Request?


Email Address

Newsletter Subscription

(Past Newsletters)