(Alain Fisher and Suita Gupta) This article introduces the VMware Infrastructure components and walks you through setting up DB2 Enterprise 9 on a 64-bit Linux virtual machine using the VMware ESX Server product
Author: SSWUG Research
IDUG NA Conference
(Susan Visser) In the mail today, I received an invitation to the next IDUG NA Conference that is taking place in San Jose in May. Given the recent announcement of DB2 9 for z/OS, and the close proximity to the lab that creates the product, I’m sure you’ll have a chance to meet many of the developer
Dedicated vs. shared server configuration
(Brian Peasland) What is the difference between dedicated and shared server configuration? Please tell me how to configure shared server configuration. In which situations should we use these configurations? (R)
SQL Escape Sequences
Language features, such as outer joins and scalar function calls, are commonly implemented by database systems. The syntax for these features is often database-specific, even when a standard syntax has been defined. ODBC and JDBC define escape sequences that contain standard syntaxes for the languag
Advanced SAX (Sample Chapter)
(Brett D. McLaughlin and Justin Edelson) What you’ve seen regarding SAX so far is essentially the simplest way to process and parse XML. And while SAX is indeed named the Simple APIfor XML, it offers programmers much more than basic parsing and content handling. There is an array of settings that a
Optimize database snapshots
(Greg Robidoux) In a previous article, SQL Server 2005: When and how to use Database Snapshots, we took a look at the new database snapshot feature which is available only in SQL Server 2005 Enterprise and Developer Editions. Basically, a database snapshot allows you to create a static read-only cop
How to use the SQLIOSim utility to simulate SQL Server activity on a disk subsystem
This article describes the SQLIOSim utility. You can use this utility to perform tests on disk subsystems. These tests simulate read, write, checkpoint, backup, sort, and read-ahead activities for Microsoft SQL Server 2005.
Passing lists to SQL Server 2005 with XML Parameters
(Jon Galloway) I recently needed to write a stored procedure which took a list of ID’s as a parameter. That’s one of those things that seems like it would be really simple, but isn’t. You’d think you could just pass in a comma delimited string of id’s: @ids = ‘3,5,7,8’ and use something like ‘SELECT
Using a TabIndex with a Usercontrol containing .NET controls
(openshac) It’s not uncommon to have a usercontrol which acts as a simple container for a number of “sub controls”. A typical example might be an Address control containing an Address, City and Country textbox. This “Address” usercontrol does not have a TabIndex property by definition. However the u
SQL Server 2005 Integration Services – Part 44 – Bulk Insert Task
(Marcin Policht) In the recent installments of our series dedicated to SQL Server 2005 Integration Services, we have been discussing individual Control Flow tasks, focusing on their unique functionality and characteristics. One of the few remaining items in this category is the Bulk Insert task, whi