(Jeff Jonas) Born out of IBM’s acquisition of security startup company Systems Research and Development last January, the IBM DB2 Anonymous Resolution is an application that can look – somewhat – into encrypted data without first deciphering the contents.
Author: SSWUG Research
Why you want to be restrictive with shrink of database files
(Tibor Karaszi) Introduced in SQL Server 7.0 was the ability automatically grow and to shrink the physical size of database data and transaction log files. Auto grow of files doesn’t happen before the file is full, it happens when new space is needed (like when an insert is performed), so the user w
A Numbers Game to Test Your SQL Skills
(Alex Kozak) Programming is not only remembering Java classes or the numerous utilities that appear almost every day. It is also the ideas in Donald E. Knuth’s “The Art of Computer Programming” and Dr. Ted Codd’s SQL, fundamental principles from which .NET libraries and Java classes are derived. Whi
More on your DB2 V8 upgrade and binding packages
(Willie Favero) I know, not more stuff about bind. Sorry about that but I keep thinking of stuff I forgot to mention in previous posts. This post will be real short though so it will be a very quick read.
IBM Launches System i Package for Oracle Users
(Jeffrey Burt) IBM is looking to give smaller businesses running Oracle’s ERP applications an alternative to Windows-based offerings on Intel-powered servers with the latest in a series of System i packages aimed at the small and midtier space.
Separate data and formatting with microformats
(Jack D. Herrington) Every once in a long while, I read about an idea that is a stroke of brilliance, and I think to myself, “I wish I had thought of that, it’s genius!” Microformats are just that kind of idea. You see, for a while now, people have tried to extract structured data from the unstructu
Using XML in Visual Basic 2005 (Sample Chapter)
(Bill Evjen, Billy Hollis, Rockford Lhotka, Tim McCarthy, Rama Ramachandran, Kent Sharkey and Bill Sheldon) In this chapter, we’ll look at how you can generate and manipulate Extensible Markup Language (XML) using Visual Basic 2005. However, using XML in Visual Basic is a vast area to cover (more t
XTree
(Marc Clifton) Whenever I use a TreeView, I get frustrated with the amount of application specific coding that I have to do. I’ve been mulling about an XML-based template that defines the master tree: –defining node "types", –specifying the root node type, –given a node type, what are the
Compile All Dependent Objects
(Hector Gabriel Ulloa Ligarius) This code is an updated version of a previously published script which compiled dependent objects. This version includes all dependent objects.
Defining Keys
(James P. O’Brien) We all know that keys are essential to relational structures. It is crucial that we be able to differentiate between one instance and another.