(Craig Mullins) One area that tends to confuse some DB2 developers until they gain experience is how DB2 partitioning works. A common question I get goes something like this: “If a table is in a partitioned table space, say four partitions, for example, then to process the table in batch can I run f
Author: SSWUG Research
CodeSnip: How to Create a DataGrid in ASP.NET with Multiple Radio Buttons Per Row
(Nidal Arabi) Sometimes you may be asked to create a DataGrid in ASP.NET with multiple radio buttons that can be selected by each row. For example, a user may ask for the option to reject, accept or cancel a product from a list of received products. Take a look at Figure 1.
Compliance…Not just for DBAs
Attend “Compliance…Not Just for DBAs”, a teleconference which is packed with important information for not only DBAs, but also Auditors and Compliance and Security Administrators responsible for adherence to regulations in their company. (R)
Challenges of two-factor authentication
(Serdar Yegulalp) Much buzz has circulated lately about “two-factor authentication,” the technology that allegedly provides better security than just relying on a single factor such as a password or an ID card alone. Two-factor authentication (2FA) uses multiple elements, physical and otherwise, to
Achieve XML development metamorphosis with some Butterfly XML IDE magic
(Edmond Woychowsky) Arthur C. Clarke’s third law goes like this, “any significantly advanced technology is indistinguishable from magic,” which an interesting opinion to say the least. This statement does a lot to explain the interesting array of technologies available to us, but it doesn’t explain
Learn the pros and cons of working with SortedLists in VB.NET
(Irina Medvinskaya) SortedLists come in handy when developers need to maintain a collection of objects that is sorted every time an item is added or removed. In this tip, I look at a way of implementing and utilizing SortedLists in VB.NET.
Batch Updates with PL/pgSQL
(David E. Wheeler) The previous article in this series, Practical PL/pgSQL: Managing Ordered Sets, created four functions to simplify the management of ordered collections as many-to-many relationships. The two more complex functions, entry_coll_tag_set() and entry_coll_tag_add(), take an iterative
Virtual Private Database
(Garry Robinson) Column-level VPD policies can be used to either restrict rows containing sensitive column data (the default behaviour) or show NULLs in the secure column (Column masking behaviour). Column level VPD can only apply to tables and views, not synonyms.
Read Inconsistency?
(Alex Nuijten) Riddle me this: Can an object exist in all_objects before it is created? Well no, of course not.
Parsing XML Documents (Sample Chapter)
(Ajay Vohra and Deepak Vohra) An XML document contains structured textual information. We covered the syntactic rules that define the structure of a well-formed XML document in the primer on XML 1.0 in Chapter 1. This chapter is about parsing the structure of a document to extract the content inform