Recap: 2Q 2011 on Developer Exchange

Blog
The best minds from Teradata, our partners, and customers blog about whatever takes their fancy.
Teradata Employee

Summer is here (at least for those of us in the Northern Hemisphere), and I hope the living is easy. Time for a recap of last quarter's activity.

The BTEQ team started us off with an in-depth look at Logging On Teradata Session via BTEQ. Darrick Sogabe et al explain the Laddered Concurrent Connect (LCC) approach that can lead to significant client perfomance improvements - well worth a read. Francine Grimmer gives the lowdown on the 13.11 releases of SQL Assistant Java Edition and its sibling, Teradata Plug-in for Eclipse, while John Smith explains the usage of the SQL Ant Wizard and the iBatis CRUD Wizard in those products. There's a very in-depth article on Migrating Priority Scheduler settings to TASM Using Teradata Workload Analyzer, which is pretty much essential reading for TASM migration efforts. Mike Riordan has an excellent article on Teradata and Digital Image Processing, with useful client-side code tutorials for uploading and retrieving images from the database. Scott Shelton explains how to access System Logs for Teradata/Aprimo Relationship Manager 6.3, and finally there's an explanation of an Efix for JMS Access Module 13.0.

Spring certainly seemed to put a step in the DevX blogosphere. Star blogger Carrie Ballinger starts us off with a highly popular post on Two Levels of Concurrency Control for Load Utilities in Teradata 13.10, and follows up with a note on the Number of AMP Worker Tasks used by Archive Utility. Gary Ryback explains the new Viewpoint support for Teradata DB authentication strategies, and has an interesting Viewpoint customer success story of how the Capacity Heatmap portlet was used to figure out a system issue. George Coleman has an excellent series on Set SQL; an approach to convert from Flat Logic to Set Logic, followed by Using Derived Tables as a Shortcut to Set SQL, and finally Converting Complex Procedure Logic to Set SQL Using Derived Tables. Our top forum poster, Dieter Noeth, continues his pursuit of the blogging crown with a popular and informative series of posts on "missing" functions; these being DENSE_RANK, followed by CUME_DIST & NTILE, and concluding with PERCENTILE_DISC, PERCENTILE_CONT & MEDIAN. John Graas continues his Data Warehouse Disruption series with Love Those Mobiles!, Big Data Reading, and Big Data Listening. And wrapping up our busy blog recap, Paul Sinclair explains the difference between NO RANGE and UNKNOWN.

Finally, in downloads, we have new releases of Teradata Geospatial, JDBC Driver, ODBC Driver, and .NET Data Provider. And also new versions of SQL Assistant Java Edition and the Teradata Plug-in for Eclipse, Teradata Express for VMware Player, and a new offering, Teradata Warehouse Miner - Express Edition.

That's it for now, look forward to another recap shortly before PARTNERS. Enjoy your summer.