Newsletter Archive Tuesday June 8, 2010 - Summer issue HomeRun 7.0 CTO Memo New Training Videos HomeRun Special offer 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 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 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 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 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 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 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 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 Size: 768000B Thursday October 11, 2007 - Great reading! Useful tips and information - such as: SQLUDFs SQE vs CQE Part II Chaos in IT PICNIC 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 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 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 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 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 Size: 291134B Thursday, August 10, 2006 - iSUMMER READING for those who can't get enough SQL tuning tips. Announcements, news, tricks and more... Size: 489426B Wednesday, June 14, 2006 - Great summer technical reading from the pros in Rochester...and Germany! 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 Size: 928532B February/March 2006 -  ** Database Goodies for V5R4 ** Top 5 Reasons to Create an Index ** STRSQL Conundrum 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... Size: 116926B Friday, October 14, 2005 - Tips, tricks and more from the SQL experts at CTI Size: 464795B Tuesday, August 09, 2005 - Tips from our SQL experts Size: 529942B Tuesday, June 07, 2005 - Tips from the SQL iSeries Pros Size: 1502161B Friday, April 01, 2005 - An in-depth look into iSeries performance Size: 731838B Tuesday, February 08, 2005 - NEWS - iSeries tips and links from the pros at Centerfield Technology Size: 387385B more news