(Jason Apergis) On the K2 Underground I have seen two very common requests for InfoPath but simple could use a little instruction on – changing XML Fields and archiving the XML.

(Bryan Avery) I will take you through how to deploy your own Custom Data Process Extension for SQL Server Reporting Servers 2005, both on the server and for use within your development environment.

(Richard Foote) In Part I, we saw how with Reverse Key Indexes, Oracle will basically take the indexed value, reverse it and then index the reversed value. As a result, data that would ordinarily be logically sorted within an index structure will now be randomly distributed. This therefore negates t

(Lewis Cunningham) In my mini-tips I try to answer FAQs that I get either here on the blog or via email. I get the below question a lot. I recently received this email from a reader: So if I have an anonymous block that populates a table, how do I convert the block to a procedure, so I can sched

(Helmut K. C. Tessarek) This article shows you step by step how to compile and configure mod_auth(nz)_ibmdb2 (an Apache authentication module) using IBM DB2 Universal Database (UDB) as the database for storing user and group information. It explains the creation and use of the User Defined Functions

(Drew Block) When working with BizTalk, one of the most straightforward tasks can be creating the data transformation using the BizTalk Mapper. But what about those times when your needs simply don’t fit within the boundaries of the Mapper?

(Ged Mead) If you regularly read my blog you’ll know that I like to flag up those silly little Gotchas that are minor in themselves, but massively frustrating when you come upon them and can’t see the cause or the way through. I was working on a project last night and got stuck on something that ha

(Allen White) While doing some research on SMO I found a couple of very handy features of the WMI accessibility features of SMO. I’m playing with PowerShell because it’s easy to browse the SMO objects in that environment, but here are a couple of tips I found useful.

(Martin Hubel) In the past when a lock time occurred, there was no easy way to diagnose it. Now, in DB2 9.5 and DB2 9.1 FP4 there is a new registry variable called DB2_CAPTURE_LOCKTIMEOUT to capture detailed lock timeout information.

(Buck Woody) I’m continuing my series on the concepts behind SQL Security. In the previous entries I’ve explain SQL Server logins and database logons, and I’ve given you the basics on object and statement permissions.