(Tim Chapman) Database Mail, a new addition to the SQL Server 2005 database engine, is as simple to use as it is useful. Destined to be the replacement for SQL Mail, Database Mail uses a Simple Mail Transfer Protocol (SMTP) server to send e-mails rather than using the MAPI accounts that SQL Mail req
Author: SSWUG Research
Building data access class
(Michael Livshitz) Most recommended way to create web or windows database applications is based on “allocation” of the data access layer (DAL) in a separate layer. There are many ways to create this layer, of course, including the new feature of the .NET 2.0 – the ObjectDataSource. In this article
Build an Ajax application using Google Web Toolkit, Apache Derby, and Eclipse, Part 4: Deployment
(Noel Rappin) In the past three articles in this series, you’ve built a simple but functional Web application using the Google Web Toolkit (GWT). Until now, you’ve been editing and debugging the application using GWT’s hosted mode, which allows you to simulate a Web server environment within your Ja
Running Webforms without Oracle JInitiator
(Marcos Claver) A few weeks ago one of my customers told me that he lost a sales opportunity because the customer who he was trying to sell his software too had problems convincing his system administrator to install JInitiator. And as we all know it’s often quite a challenge to convince a system ad
Compute Numbers That the Sums of the Digits are Divisible by Three
(Frank Zhou) This tip can be used to compute both numbers that are divisible by three, and the sums of all the digits that are divisible by three.
Business Performance Management: The Real Challenges
(Craig Schiff) Articles on the challenges of business performance management (BPM) usually focus on selecting the right product and getting it properly implemented. While it is true those tasks are fraught with risk, the greatest BPM challenges have little to do with technology.
Using DBMS_FLASHBACK in Oracle to set your entire session back in time
(David) Last week I’ve talked to you about using Flashback query, Flashback table and FlashBack database in Oracle 10g to help you improve productivity and perhaps save you time in doing complete or partial database recovery.
Weaving WebSphere: Change Management in the Brave New World
(Joe Pluta) The winds of change, and particularly change management, are howling ever louder as the requirements of multiple languages and multiple platforms complicate what was once a relatively simple world.
Dynamic SQL and Performance
(Craig Mullins) The performance of dynamic SQL is one of the most widely debated DB2 issues. Some shops try to avoid it, but in this day and age of ERP/CRM systems, Java/JDBC programming, and web applications, all of which heavily rely on dynamic SQL, its use is becoming more ubiquitous.
Serving SQL XML through a WebService (SQL2005)
(Russ Quinn) I recently needed to create a feed for a customer from some data held within SQL Server so looked around for the best (and quickest) way to do this. Knowing that I use SQL 2005 and that XML was an intregal part of it, I looked at ways to leverage this.