(Xinjie Zhang) ADO.NET can be used as a powerful XML middleware. Although coming from ADO, it has been entirely redesigned for a better support for Web applications. A main feature of ADO.NET is its disconnected recordsets, known as DataSet. It acts as a feature-rich in-memory database or data cache
Author: SSWUG Research
T-SQL Enhancements in SQL Server 2005
(Bob Beauchemin, Niels Berglund and Dan Sullivan) Sql server 2005 includes new Transact-SQL (T-SQL) functionality. The enhancements span the range from an alternative mechanism for transaction isolation to declarative support for hierarchical queries. And statement-level recompilation even improves
Errors Generated if TCP/IP DDM Server on AS/400 Not Started
If the TCP/IP DDM Server on the AS/400 is not started, the following data providers cannot connect over TCP/IP: –Microsoft OLE DB Provider for AS/400 –VSAMMicrosoft OLE DB Provider for DB2Microsoft ODBC Driver for DB2
Oracle to Splash ECM Market with ‘Tsunami’
(Clint Boulton) It’s no secret that Oracle has been considering a dip in the enterprise content management well, especially after companies like Microsoft, IBM and EMC made such a splash in the sector over the last year. This week, research group Ovum revealed that the Oracle enterprise content
An Is Null Gotcha
(David Poole) There is a very good reason for having user acceptance testing over and above unit testing and formal testing of you code. As a developer, you will test your code for the things that you expect to be trapped. A professional tester will take the functional requirement specification and
Building Plugins with C# Part 3: Adding LDAP, SQL, and Configuration
(Nathan Good) This is the third article in a four-part series on building plug-ins with C# .NET. The second part in the series covered some XML-related topics, such as using an XML file to store usernames and passwords, and writing a custom XML configuration section handler to parse the application
Microsoft, SQL Server and Performance Management: The Business Scorecards Accelerator, Part 1
(Trey Johnson and Pam Barker) This is the first of a two-part series walking you through the new performance management solution, Microsoft Office Business Scorecards Solution Accelerator. Part 1 focuses on the architecture and construction of scorecards.
DB2 Universal Database for iSeries Administration: The Graphical Way on V5R3
(Hernando Bedoya) This IBM Redbook presents an overview of all V5R3 iSeries Navigator functions to manage and administer DB2 Universal Database (UDB) for iSeries. It serves as a companion guide for the database administrator to use DB2 UDB for iSeries. This redbook includes the latest announced feat
Lab Report: LiteSpeed and UltraBac
(Morris Lewis) For at least 50 years, magnetic tape has been the medium of choice for long-term data storage, and nothing is likely to completely replace tape in the near future. However, increasingly, organizations are backing up databases to a hard disk before copying the file to tape because the
Licensing distributed DB2 Universal Database (DB2) Version 8 servers in a high availability environment
(Paul C. Zikopoulos and Leon Katsnelson) Are you trying to ensure you’re licensing your DB2 servers correctly in a high availability environment? Don’t have the time nor the will to read through the announcement letters, PLETs, or your licensing sheets? This article explains it all in plain English.