(Justin Whitney) Part 1 covered installing and configuring your free download of DB2 9 Express-C and populating your AJAXDEMO database. Now you will learn how to create a Web Service in Visual Studio 2005 using the DB2 9 Add-ins to interact with those services using asynchronous JavaScript.
Author: SSWUG Research
An Instance of SQL Server 2000 Performance Tuning
(Sunil Madan) This article is about altering a table and adding NOT NULL columns into it. The table being altered contains MILLIONS of records. One straight forward approach could be: Step 1: Alter Table — Add Nullable Column. Step 2: Update Newly Added Column. Step 3: Alter Table — Modify New
XForms tip: Accepting XForms data in Java
(Nicholas Chase) Much has been made about the ability of XForms to provide interactivity, and to submit information in XML. But none of that will do you any good unless you have a way to analyze the data once you send it to the server. This tip shows you how to access the submitted XML data using a
Getting Started with SQL Server Integration Services
(Mike Gunderloy) You’ve no doubt heard of SQL Server Integration Services (SSIS) by now, and probably even know that it’s the SQL Server 2005 replacement for the older Data Transformation Services. Microsoft calls SSIS “a platform for building high performance data integration solutions, including e
Reporting Services – Getting the Matrix to Display Two Subtotals for the Same Group
(Elizabeth Vitt) This week I am switching gears to talk about a cool design technique for the Reporting Services matrix.
Using Microsoft’s SOAP Toolkit for remote object access
(Rick Strahl) Web Services and XML Messaging are gaining ever more attention and at the core of this movement is the Simple Object Access Protocol (SOAP), which promises to bring a standard interface to calling server side code. In this article Rick discusses what SOAP is how it works and how to use
Introducing WSGI: Python’s Secret Web Weapon, Part Two
(James Gardner) In Part I we discussed how the Web Server Gateway Interface (WSGI) is helping to unify the Python web-framework world by providing a standard API through which different web applications can operate with different servers. We also looked at the HTTP protocol and how to write and depl
Access application data using WebSphere Information Integrator and WebSphere DataStage
(Jacques Labrie) Discover an alternate methodology for accessing application data sources in IBM WebSphere Information Integrator using the WebSphere DataStage product as the connection vehicle to SAP. Application data sources can also be accessed by WebSphere Information Integrator using the WebSph
Oracle RAC Administration – Part 6: Administering the Database Instances and Cluster Databases
(Tarry Singh) Oracle has finally released its Oracle 10G Release 2 database for Solaris 10. I have been waiting for it for quite some time and I hope that they were able to fix the clusterware problems, which had had some issues. Anyway, I will test it on my ESX box, which has three ready baked Sola
Shedding Some Light on LAMP
(Russell Kay) In the jargon-laden world of IT, new terms are created as shorthand ways of referencing or discussing otherwise cumbersome phrases. One addition to the lexicon that has gained increased popularity and use is “LAMP,” which refers to a collection of free, largely open source software th