(Xianzhong Zhu) Nowadays, AJAX has become one of the coolest features for building interactive browser-based client applications. The famous Google Maps show a distinct advantage over traditional map service systems in availability and response speed. In this article I will show you how to build an
Author: SSWUG Research
XML Firewalls: Taking the Holistic Approach to Security
SOA has been the buzzword for long enough for it to cease to be a buzzword and become a mandatory part of any organisation’s strategy. While SOA offers a great deal, it is not a technology, rather an underlying framework, and Web services is the principal SOA platform to be used by businesses to aut
Jump start WebSphere MQ development on Linux
(Sami Salkosuo) This article shows you how to get started installing and configuring WebSphere MQ on Linux and developing Java applications for the MQ environment, using sample applications for sending messages to and receiving messages from a queue.
Sun Beefs Up NetBeans
(Darryl K. Taft) Sun Microsystems and the NetBeans community will announce the availability of the NetBeans 6.0 Integrated Development Environment Preview release at the company’s NetBeans Day prelude to its annual JavaOne conference.
MySQL Optimizer and Prepared Statements
(Sergey Petrunia) Performance-wise, the idea of Prepared Statements is that the server does certain pre-processing on PREPARE command, and then those steps are omitted when the statement is executed. If the statement is executed several times, we get an economy of cost_of_prepare_preprocessing *
Put SQL Server’s EXISTS construct to good use
(Tim Chapman) One thing I have noticed over the years is how seldom developers use SQL Server’s very useful EXISTS construct. You can use EXISTS in a variety of situations — some of which I will explore in this article.
Oracle Capacity Planning
(JP Vijaykumar) 02:00 AM Boss: Reclaim every byte of free space from other tablespaces in the database/ server that are not 100% full and allocate to EMP_TBSP01 tablespace, which is 100% full.
Oracle Database Fundamentals
(Mamun Zaman) In this article we will mainly focus on basic database development using Oracle. We will learn how to create new tables, alter them, insert data into the database, update data, retrieve data, delete data and drop tables. We have lots to do, so let’s get started.
Another use for INSERT ALL syntax
(Andrew Clarke) Over on the Pythian blog Babette Turner-Underwood discusses Oracle’s multitable insert syntax. She’s been using in on a data conversion project. The advantage of INSERT ALL is that it allows us to insert several different VALUES clauses in a single statement.
Online restore and filegroups
(Tibor Karaszi) Is data available for a partitioned table if one of the partitions isn’t available? Instead of reading BOL, I wanted to test this.