(Qing Fa Wang and Zhi Ping Yang) In this article you will learn how to integrate Microsoft Excel and XML documents using a WebSphere Information Integrator federated system. We begin with a discussion of the basic concepts of a WebSphere Information Integrator federated system, and then explain how
Author: SSWUG Research
XML data type tips in SQL Server 2005
(Howard Richards) This article outlines some techniques for using the new XML data type provided in SQL 2005, when creating VS2005 applications. The examples here are written in VB.NET but there is a C# version of the source.
SQL Server backup encryption for improved security
(Greg Robidoux) With the growing need to keep data secure, by all means, don’t overlook securing your database backup files. With native SQL Server backups, the data in the backup file is stored in plain text and can be easily read just by using a text editor. Depending on the data types used in you
LDAP Access Control for ASP.NET
(Wojtek Piaseczny) This is an example of how to build an ASP.Net LDAP authentication application using ADAM.
Query XML data that contains namespaces
(Cynthia M. Saracco) The widespread use of namespaces in XML messages and documents impacts how application developers must write their queries. Unfortunately, the relationship between namespaces and popular query languages (such as SQL/XML and XQuery) is often poorly understood. This article walks
News: Don’t Embed That Database!
(Bradley Jones) This week, Microsoft announced that Microsoft SQL Server 2005 Compact Edition (previously referred to as SQL Server 2005 “Everywhere Edition”) was being made available as a release candidate (RC). A release candidate is generally considered a version that is final with the exception
Introducing Ajax
(Edmond Woychowsky) A little more than a year ago, an article by Jesse James Garrett was published describing an advanced web development technique that, even though individual components of it have existed for years, few web developers had ever stumbled across. I can guess the reason for this lack
SQL Server 2005 Integration Services – Part 36 – Term Extraction and Term Lookup
(Marcin Policht) As we have demonstrated in the recent installments of our series, in addition to handling standard tasks associated with data processing (available also in legacy Data Transformation Services), SQL Server 2005 Integration Services offers some new, unconventional capabilities. Fuzzy
Developer Resources for Office 2007 RTM
(Jensen Harris) Now that we’ve released Office 2007 to manufacturing, developers can get started modifying their solutions so that they’re ready to test with the released version of Office.
Expanding an Error Logger with the Chain of Responsibility Pattern
(Alejandro Gervasio) Do you want to know how to build an error logging system using the chain of responsibility schema with PHP? If your answer is a loud yes, then in this group of articles you’ll find what you’ve been looking for! Welcome to the concluding part of the series “Understanding the chai