(Ted J. Wasserman) This tutorial explores the advanced programming skills needed to write applications that interact with DB2 9. Topics include user-defined types (UDTs), data type casting, parameter markers, compound SQL, triggers, distributed units of work, federated databases, and concurrency con
Author: SSWUG Research
Use Table-Valued Functions as Arrays in SQL Server
(Mark J. Miller) The SQL IN statement allows returning a set of records based on a variable (unknown at design time) number of keys. But IN doesn’t allow parameters, which leaves us with either fixed lists or dynamic SQL statements. The problem with fixed lists is they don’t provide the flexibility
Starting a BPEL process instance according to a timed schedule in Oracle BPEL PM
(Lucas Jellema) Process instances in the Oracle BPEL PM can be initiated in a number of ways. Some are passive – the BPEL engine receives a call and as a result starts a new instance of the referenced process – while others are more active – the BPEL engine looks for events that it knows should trig
FIX: In SQL Server 2000, the synchronization process is slow, and the CPU usage is high on the computer that is configured as the Distributor
When you synchronize a subscription to a transactional replication publication in Microsoft SQL Server 2000, the synchronization process is slow. During the synchronization process, the CPU usage is high on the computer that is configured as the Distributor.
New Ranking Functions within SQL Server 2005
(Gregory A. Larsen) With SQL Server 2005, Microsoft introduced a number of new features. These new features make it easier for a DBA or SQL Server developer to code against and to maintain SQL Server databases. In this article I will discuss the new ranking functions provided with SQL Server 2005. T
Configuring the OC4J Server
(Sam Alapati) In this third part of a series that focuses on managing OC4J and configuring J2EE applications, we look at how to configure the OC4HJ server.
Manage Web Users With Custom Profile Providers
(Jason N. Gaylord) With ASP.NET 2.0, you can add authentication, authorization, and profiles to your Web site without writing a single line of code. That’s quite a step forward from the way things used to be. Like most of the new features in ASP.NET 2.0, authentication, authorization, and profiles e
A Tale of a .Net Component (Part III)
(Peter Aitken) This is the third article in a series that covers all the details of developing a .Net component. By following this process from start to finish, you may learn aspects of .NET development that are not provided in more specialized articles.
Understanding Data Warehousing
(Arindam Ghosh) Since the beginning of time reports and information to the masses have been provided. Whether that information was in the form of smoke signals, stone tablets, or hand-written records, information sharing has been around for ages. Today we call this collecting and sharing of informat
.NET Tip: Compressing/Decompressing Your Files
(Eric Smith) One of the many new libraries included with .NET 2.0 allows for compression and decompression of files using the gzip file format. The major downside to this format is that it isn’t compatible with the built-in Compressed Folders format built into Windows XP. However, I was able to open