(Sanjeev Sawai) VoiceXML is quickly becoming the standard language used for developing interactive voice response and speech-enabled self-service applications. Applications that were previously deployed only on the Web are now easily made available via the phone, giving customers a consistent, conve
Author: SSWUG Research
Using SQL Server 2005 to document Sarbanes-Oxley compliance
(Tim Chapman) As the DBA for revenue-generating applications, I am frequently invited by my CIO to meetings with Sarbanes-Oxley auditors to discuss the security and integrity of corporate data. In a nutshell, we’re expected to answer any number of questions, via appropriate documentation, about who
Performance Improvement For AJAX
(Manikandan.net) In Web Forms, we use AJAX to invoke server side methods from the client-side (from JavaScript). AJAX internally uses XMLHttpRequest. I have tested a number of AJAX functions implemented in different ways. Also, I have monitored the performance and life cycle of AJAX calls. I have fo
Deploy SOA applications in Apache Geronimo using XMLBeans
(Kunal Mittal) The XMLBeans technology lets you work with an XML structure just as you’d work with a JavaBean. Using a tool like XMLBeans simplifies SOA development by reducing the development and testing time required for your services, thus increasing the agility of your service delivery.
Speeding UPDATEs Using the CASE Statement
(Neil Boyle) One of the keys to SQL Server database performance if keeping your transactions as short as possible. In this article we will look at a couple of tricks using the CASE statement to perform multiple updates on a table in a single operation. By doing this, some transactions can be shorted
Using AWE
Microsoft SQL Server 2005 uses the Microsoft Windows Address Windowing Extensions (AWE) API to support very large amounts of physical memory. SQL Server 2005 can access up to 64 gigabytes (GB) of memory on Microsoft Windows 2000 Server and Microsoft Windows Server 2003.
Working with MySQL’s Transactional Table Types
(Jay Greenspan) In Lesson 1 of this tutorial, you leaned how to approximate transaction-like behavior with MyISAM tables. In this lesson, you’ll see how you can achieve real transactions with each of MySQL’s three transactional table types: BDB, InnoDB, and Gemini. But before I get to specifics surr
Compute Totals and Percentages
(Keshav Chennakeshav) Here is a tip to compute totals and percentages using the GROUPING and ROLLUP functions in summary queries. To get the correct percentage, the WHERE clause in the runtime table (designated with the alias “ts” below) should match the WHERE clause of the query. The output can be
DB2 Label-Based Access Control, a practical guide, Part 1: Understand the basics of LBAC in DB2
(Carmen K. Wong and Stan Musker) Label-Based Access Control (LBAC) is a security feature introduced in the DB2® Viper release. With LBAC, administrators can control read and write access of a user at the table column and row level. This tutorial includes use case scenarios that demostrate how users
Sharing Web Parts across multiple pages
(Damon Armstrong) Most Web Parts implementations allow users to create a single portal page where they can personalize the look, feel, functionality, and experience of their “My Home” page in an application. But what if you want to take Web Parts a step further and allow users to define a personaliz