(Matt Nicholson) For the end user, the changes that will come with 2007 Microsoft Office System may seem limited to a bright new user interface and some useful new features. However, this new version offers the potential to transform the working life of anyone involved in implementing a project or f
Author: SSWUG Research
Survival of the Prepared: Addressing Disaster Recovery
(Craig Carpenter) It happens. Hurricanes, floods, earthquakes and fires – the so-called “acts of God” that shatter lives and devastate businesses. Their man-made cousins – fire, power failures or worse yet, terrorism – are no less destructive. Together these unanticipated events pose risks to busine
Develop an automated build engine using WebSphere Integration Developer
(David Leigh, Ashwin Manekar, Chad Smith and Jonas Richard) This article describes how to construct an automated build engine solution for applications developed using WebSphere Integration Developer and maintained using Rational ClearCase as the Software Configuration Management system (SCM). It ex
SqlCommandBuilder.DeriveParameters – Get Parameter Information for a Stored Procedure
(David Hayden) Last night I was updating a DatabaseHelper Library that I use for small .NET consulting projects. It shares the same interface as Enterprise Library 2.0 DAAB, but without all the bulk. It is a “same taste, less filling” kind of library optimized for Sql Server Database Access that can
Enumerating local 64 bit and 32 bit instances of SQL Server
(James Moore) When checking for local instances of SQL Server its normally best enumerate the value of the registry key HKLMSoftwareMicrosoftMicrosoft SQL Server and then look at the value on installed instances.
DB2 9 pureXML Guide
(Whei-Jen Chen, Art Sammartino, Domromir Goutev, Felicity Hendricks, Ippei Komi, Ming-Pang Wei and Rav Ahuja) IBM DB2 9 for Linux, UNIX and Windows marks a new stage in the evolution of data servers. IBM has continually led the data management industry with the release of innovative technology. DB2
Guide to MySQL 5.1 Partitioning
Partitioning is a physical database design technique that many data modelers and DBAs are quite familiar with. Partitioning allows large objects within a database to be split into small, more manageable pieces. There are a number of benefits that come with partitioning, but the two main advantages a
Working with Strings of XML and XSL
(Aaron Dunnington) Recently, there have been a few posts on the .NET XML Forums concerning the usage of XML and XSL strings rather than streams.
SQL Server Integration Services programming basics
(Serdar Yegulalp) If you’ve ever moved data into or out of SQL Server, chances are you’ve done it through Microsoft’s DTS or Microsoft’s Data Transformation Services tools. DTS is an ETL tool (short for extraction, transforming and loading), which allows database administrators to create sets of ste
Getting Started with AJAX and the XMLHttpRequest Object
(Joshua Eichorn) The foundation that makes AJAX possible is the communication layer with the server. The most complete option for performing this communication is the JavaScript XMLHttpRequest object. If XMLHttpRequest is not suitable to you, hidden IFrames and cookies can also be used. We will exam