(Whei-Jen Chen, Chandramouli Chandrasekaran, Don Gneiting, Gustavo Castro, Paul Descovich and Tomohiro Iwahashi) As organizations strive to do more with less, IBM DB2 for Linux, UNIX, and Windows provides various built-in high availability features. DB2 further provides high availability solutions b
Author: SSWUG Research
Docking Controls – Standard and Custom
(Scott Lysle) Visual Studio 2005 includes the Toolstrip container and Toolstrip controls; used together, these controls allow the end user to drag and drop toolstrips to the edges of the screen such that at run time, the user can reposition the toolbars to the top, bottom, left, or right edges of th
Introducing Mediator Classes in PHP 5
(Alejandro Gervasio) The mediator design pattern can help you achieve and maintain synchronization between a group of PHP classes. In this first of a two-part series, you’ll be introduced to the mediator pattern, how it functions, and how it can help you with your application development.
TechTip: SQL and i5/OS Record Format Names
(Kent Milligan) When using SQL to create DB2 for i5/OS tables that will be accessed by non-SQL interfaces, such as RPG native interfaces, you need to consider the record format name generated by DB2. By default, the record format name for an SQL created table is identical to the table (or file) name
An algorithm to find and resolve data differences between MySQL tables
(Xaprb) I’ve been designing an algorithm to resolve data differences between MySQL tables, specifically so I can ‘patch’ a replication slave that has gotten slightly out of sync without completely re-initializing it. I intend to create a tool that can identify which rows are different and bring them
Record Locking in SQL Server
(Kalpesh Bakotiya) In a multi-user environment, there are two models for updating data in a database: optimistic concurrency and pessimistic concurrency.
Reevaluating XSLT 2.0
(Kurt Cagle) I recently wrote a blog about the directions that I saw with XML, and while it has proved to be fairly popular, it has also generated a fair number of comments that really need their own more detailed examination. One of these, and one that I’ve been planning to write for a while anyway
Restricting Data Access Using the Virtual Private Database
The goal of this tutorial is to show the power of using the Virtual Private Database capability to restrict access to certain data to certain users.
Understanding ASP.NET Application Folders
(Sanjit Sil) We can add any number of files and folders within the application without recompiling each and every time a new file is added to the overall solution. ASP.NET2.0 has the capability to automatically precompile ASP.NET application dynamically. In case of ASP.NET 1.0 or ASP.NET 1.1 everyth
Is it query which needs to be optimized?
(Peter Zaitsev) Last few days I had a lot of a lot of questions at MySQL Performance Forum as well as from our customers regarding query optimization… which had one thing in common – It is not query which needed to be optimized.