(Soyuj Kumar Sahoo) We all know how great T-SQL is for database code, but writing procedural code in T-SQL has always been difficult. It seems impossible when we need a stored procedure or two, requiring some array-operations, text-parsing or complex math operations. However, it is quite easy if o
Author: SSWUG Research
Implementation of Foreign Keys for the PBXT storage engine
(Paul McCullagh) I have just committed the initial implementation of foreign keys for the PrimeBase XT storage engine, whew! The implementation is similar to that of InnoDB and supports the RESTRICT, CASCADE and SET NULL options.
Experiences with Oracle 10g Solutions on Linux for IBM System z
(Lydia Parziale, Kathryn Arrell, Dennis Dutcavich, Terry Elliott, Bruce Frank and Erik Kane) This IBM Redbook describe experiences gained while installing and testing several Oracle solutions, such as: –Single Instance of Oracle Database 10gR2 –Including sharing ORACLE_HOME and Cloning Oracl
A performance comparison of DB2 9 pureXML and CLOB or shredded XML storage
(Matthias Nicola and Vitor Rodrigues) Like other databases, the DB2 V8 XML Extender offers two storage and access models for XML: XML documents can be stored intact as unparsed text in CLOB columns, or they can be mapped and shredded to a set of relational tables. Both options have known performance
Using IPC channels and .NET Framework 2.0 to communicate between processes
(Zach Smith) Interprocess communication, or “IPC”, allows one process to communicate with another process that is running on the same computer. Since the calls don’t have to travel over the network, IPC calls have much less overhead and are typically faster than calls that do travel over the network
XSL transformation of Spreadsheet ML to HTML (with Paging) – Part 2
(Muthu Kumar Arjunan) This article explains how to “Page” an HTML table generated from Spreadsheet ML document, using XSL transformation & XMLHttp & Java Script.
Lesson 8 Using Service Broker
Service-oriented architecture (SOA) has become an important concept in the design of large-scale distributed applications. Central to SOA is the ability of services to communicate using a reliable message-based mechanism. Microsoft SQL Server 2005 Service Broker is a message-based platform for build
Managing MySQL on Solaris 10: Part 1: Introduction
(Frank Mash) From time to time I receive requests from friends who are interested in learning more about managing MySQL on Solaris 10. To help them (and myself), I am planning to write about the internals of both MySQL and Solaris.
Oracle Streams Configuration: Change Data Capture
(Lewis Cunningham) I have been playing with Oracle Streams again lately. My goal is to capture changes in 10g and send them to a 9i database.
SelectViews: Compliance, SQL Server on Vista, the SSWUGdex and more.
Video Programming for IT Professionals