(Willie Favero) Back on March 23, 2007, before DB2 9 officially went GA, I had a short post that discussed CLONE tables in DB2 9 for z/OS. I didn’t want to go in to a lot of detail at that time because DB2 9 wasn’t available yet. However, now that it has been out for a few months, I would […]
Author: SSWUG Research
When Information Flows Better, Organizations Work Better
(Richard Blahunka) Improving the flow of information and knowledge within and organization doesn’t necessarily produce immediate, dramatic and observable changes; rather, the business just operates better in many subtle ways over time.
Reducing Database Size by Using Vardecimal Storage Format
(Sunil Agarwal and Hermann Daeubler) Learn about the new storage format for storing decimal and numeric data in SQL Server 2005 SP2. Details include when and how to enable vardecimal storage format, restrictions, space savings, and its impact on the performance of your workload.
Using the javax.xml.bind annotations to convert Java objects to XML and XSD
(Jeroen van Wilgenburg) Did you know that when you put the @XmlRootElement annotation on any class you can have an XML representation of that class?
MySQL – to use or not to use
(Peter Zaitsev) Reading this slashdot article today and two CIO magazine articles linked from it.
Prefix v/s Non-Prefix Index ! Which is better ?
(Vivek Sharma) There’s a lot of debate about the usage of Prefixed and Non Prefixed Local Indexes. I have come across a misconception many dba’s have about these indexes when it comes to performance.
Interesting parameter SQL_ATTR_REPLACE_QUOTED_LITERALS
(Philip Nelson) When you start digging into the internals of anything you come up with some strange findings. Here is one I came across recently. I discovered this through my work with the DB2 adapter / driver for Ruby on Rails, and am indebted to Alex Pitigoi and Antonio Cangiano in the IBM labs fo
Using PDO Objects in PHP 5
(Alejandro Gervasio) The PDO library is a powerful addition to PHP. It shines when you need to build applications capable of talking to different database systems. It also has other very useful capabilities. This article, the first in a three-part series, will introduce you to this versatile library
Microsoft’s Lineup of SQL Server Related Webcasts for June 2007
Ten new webcasts are scheduled for June, covering such topics as The Next Release of Microsoft SQL Server, Visual Basic and SQL Server 2005 and more.
Step 1 in Multithreaded XML Transformations (and All Other Programs)
(Todd Lauinger) During the past 20 years I have had the privilege of working with well over 1,000 different software developers. Some of the best developers in the industry mentored me when I began my career. They taught me software development from the ground up, beginning with how to run and enhan