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

Newsletter Archive

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

SQLUDFs
SQE vs CQE Part II
Chaos in IT
PICNIC

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

Newsletter Archive

Question / Quote Request?

Newsletter Subscription