(Ged Mead) Although some of the queries we saw at the end of Part 2 are quite impressive – and light years easier than doing it with Loops and If/Then tests – there are still more improvements to come. Let’s take the situation where you want to run Join queries across two separate data sources. T
Other News
Compression and Decompression of Files using Visual Basic 2005
(Abhishek Singh) Compression is the technique to minimize the size of data (or file) by applying some encoding algorithm. The output of the compression is called compressed or zipped data (or file). Decompression is the reverse of compression to get the source data (or file) back by applying some de
Data Cluster
(Jonathan Lewis) I received an email today containing the following question: For packaged applications, like the Oracle EBS, some indexes tend to develop a high Clustering Factor over time, like the one shown below:
Using SOAP Headers to validate clients
(rog_21) In this brief article I intend to show how you can secure your web service by using SOAP headers. Often times we create a web service that we only want to enable for our own clients or would like to enable only for authorized clients. You can accomplish this by using SOAP headers to authent
An Introduction to Microsoft Silverlight
(Ziran Sun) In the first part of this article series, we introduced you to Silverlight, walked you through installing the client-side runtime, and showed you some examples of what Silverlight can do.
Let Semantics Bring Sophistication to Your Applications
(Rod Coffin) Have you ever been frustrated by the lack of sophistication in some of today’s search applications? I certainly have been. For example, I was recently evaluating a tool, called Green Pepper, for automating testable requirements; when I googled the phrase “Green Pepper,” I received a bun
Wordpad may corrupt your SharePoint (and other ASP.NET app’s) Web.confg
(Damon Armstrong) I was remoting into a SharePoint 2007 (MOSS) box yesterday because I needed to update the configuration on a few of the servers in the farm. Like most production systems, the server did not have Visual Studio, so I was using Notepad to edit the configuration. As you may know, nav
DB2 for z/OS maintenance: It’s time to reevaluate your strategy
(Willie Favero) I have always been troubled by the maintenance strategies some of my friends have chosen for their DB2 for z/OS subsystems. In fact, in some cases, I might almost label their strategies as reckless; they’re just asking for a DB2 problem to occur. I was thinking that maybe I’m not the
Performance Tuning – Implementing Indexes
(Buck Woody) One of the most important knobs and levers you have in tuning a system from the database perspective is in your database’s indexes. The indexes you apply (or don’t apply) can create performance gains far greater than any hardware changes you can make. Because the effect of the indexes i
DB2 and Ruby on Rails, Part 1: Getting started with DB2 and Ruby on Rails
(John Chun, Christine Law, Naomi Ngan and Alex Pitigoi) The emergence of the Ruby language, coupled with the powerful Rails framework, provides a myriad of opportunities for Web solutions development. With the introduction of the IBM_DB adapter and driver, Rails applications can now interact seamles