(Tony Patton) Developers are often faced with scenarios where operations need to be performed asynchronously (i.e., processes are initiated without waiting for the operation to complete). The message queue fills this need by providing a central location or pool where you can place or remove data. An
Author: SSWUG Research
Develop SQL-XQuery Web service translator for DB2 9 with IBM Rational RequisitePro and Rational ClearCase
(Judith Myerson) Gone are the days of storing XML data as a Character Large Object (CLOB) or shredding to relational tables. The problem was that after you decomposed an XML document, stored it and then put it back together, you did not end up with what you started with. Gone are the days of the ina
FIX: You may experience one or more symptoms when you run a ‘CREATE INDEX’ statement on an instance of SQL Server 2000
Consider the following scenario: • You run a CREATE INDEX statement on an instance of Microsoft SQL Server 2000. • At the same time, you run a CREATE INDEX statement on another instance of SQL Server 2000. • Both instances of SQL Server 2000 are running on the same server. • The server has
Data Access Layer For Microsoft Access Databases – Part 2
(Mike McIntyre) This is the second part of a tutorial article which demonstrates how to create a data access layer (DAL) with .NET 2.0, ADO.NET 2.0, Visual Studio 2005, and Visual Basic 2005. To read part one click here.
Reap the Benefits of Web Caching, Part 3: Database Integration
(Ivan Pepelnjak) In part 2 of this series, you learned how to use the Last-Modified HTTP header to improve the responsiveness of your web application. That article also documented ways to calculate the correct modification date and time for dynamic web pages, including adjustments that have to be ma
Generics in VB.Net 2.0
(Saurabh) In my last article “Limitations of ArrayLists in VB.Net”, I focused on issues of type safety and reusability when using ArrayLists.
SQL Server 2005 Integration Services – Part 37 – Derived Column Transformation
(Marcin Policht) Continuing our coverage of SQL Server 2005 Integration Services Data Flow components, we will present Derived Column transformation, which, while serving primarily an auxiliary role, should not be ignored, since it offers considerable flexibility and versatility combined with extrem
MySQL Security Overview
(Leidago) When should you start to worry about MySQL security? When you start to use the MySQL server over an Internet connection. Why? Because that is when your MySQL server is going to be the most vulnerable to all kinds of attacks, such as alterations and denial of service.
The next episode in our KEEPDYNAMIC dialogue continues with Part 2
(Willie Favero) Remember last week I started to discuss the bind keyword KEEPDYNAMIC? In today’s installment, we’ll start discussing the stuff that makes this interesting. The basic introduction to KEEPDYNAMIC is already out of the way so in the next few post I’ll take a look at how KEEPDYNAMIC work
TransformXML – a command line utility to apply XSL transforms
(Andrew Tweddle) TransformXml is a command line utility which applies an XSL transform file to an XML input file to generate an output file.