(Carlos Sierra) SQLTXPLAIN is easy to install. Yes, unless you hit a rock! So, if you are trying to install SQLT and you do not see the message that reads “SQCREATE completed. Installation completed successfully.” then something went bad.
Author: SSWUG Research
Script writing rules for Oracle Hyperion Financial Management
(Mike Arnoldy) For most accountants, VB script rules are scary. This is because they don’t feel comfortable going into the application and changing rules. But with some basic script writing rules, you can help accountants avoid scripts altogether.
How to figure out disk network latency using cached blocks
(Bobby Durrett) I was working on some disk performance problems and came across a simple way to test the latency or delay built into the networks that connect my database servers to their disk storage.
Fresche Legacy Discusses Three IBM i Modernization Cases
(Alex Woodie) The reasons why organizations undertake IBM i application modernization initiatives are as varied as organizations themselves. Sometimes, it’s people-driven, while other times, the technology itself needs a refresh. With 12 years in the modernization business, the folks at Fresche Lega
Data Perspectives: General Guidelines for LOAD, REORG and REBUILD Utilities
(Craig S. Mullins) The LOAD, REORG and REBUILD utilities all move data around. As such, there are some general recommendations that apply to most of these utilities. Let’s examine a few of them.
SSWUGtv: Stephen talks about Environment Selection
Video Programming for IT Professionals
Case Statement Functionality in SQL Server Integration Services Derived Column Transformation
(Dallas Snider) When selecting data from a database using T-SQL, one can use CASE statements to derive new columns based on data in the database. However, when reading data from files in SQL Server Integration Services (SSIS) there isn’t a CASE statement readily available when new columns need to be
Bind Object With Functions in JavaScript
(Faisal(mfrony)) This is a very simple tip to show how can we increase the power of Object Oriented JavaScript with the help of closure. I assume that everyone who reads the tip has a basic idea about Closure.
Restricting database connections using the CONNECT_PROC database configuration parameter in DB2 for Linux, Unix, and Windows
(Mihai Iacob and Walid Rjaibi) System administrators are responsible for, among other things, protecting a database against unauthorized access or misuse by authorized database users (for example, inappropriate access to sensitive information within a database). A common requirement to mitigate such
Experimenting with MySQL 5.7
(morgan tocker) I was playing around with MySQL 5.7 this weekend and before having read the changelog, I managed to spot these two little gems.