(Roger Jennings) Replacing ADODB with SqlClient’s Command and DataReader objects delivers a significant performance boost.
Other News
Analyzing Money
By Russ Whitney – Working with any OLAP solution can help you better understand the technology, but using data that has personal meaning can help you learn even more about OLAP. Here’s a practice solution that uses data you’ll care about–your personal finances.
Self-Enhancing Stylesheets
by Manfred Knobloch – Developing new stylesheets can be a chore. It would be nice if you could tell your stylesheet to trace which tags from the source document are not yet processed by xsl:template elements. And why not make your stylesheet write an xsl:template match skeleton for each unhandled ta
Discover a Powerful Set of Classes for Manipulating XML Data
Learn how .NET Framework’s classes and associated tools for manipulating XML data can be woven together to form an impressive array of options for constructing XML processing solutions.
Web Services Taking Root in the Enterprise
eWEEK Labs recently conducted a roundtable discussion on Web services. Moderated by Technology Editor Peter Coffee, the roundtable comprised key players in several areas of the Web services space. The discussion centered on where Web services are as a technology, where the industry is in achieving e
Ellison Is Right
By John Taschek – It’s a soap opera, and as such, it’s a tragedy. I’m talking, of course, about Oracle’s hostile takeover bid for PeopleSoft, which came on the heels of PeopleSoft’s bid for J.D. Edwards. Where else this side of afternoon TV can you get CEOs screaming at each other through pre
Create More Efficient Database Code
by Dino Esposito – Take a look under the hood of the SQL Server .NET Data Provider and discover how it can help you improve your ADO.NET code.
Book Excerpt: Database Access with Visual Basic.NET, 3rd Edition
by Jeffrey McManus and Jackie Goldstein – This book provides real-world solutions to the data-access issues VB.NET developers face every day and shares the authors’ secrets for becoming a more effective database programmer using .NET technologies. Chapter 8 explains the use of Visual Studio Database
Effective Indexes for Data Warehouses
By Roger Deng – Creating the right indexes to boost performance is an art. These guidelines will help you master the process.
IBM DB2 Universal Database Version 8.1, Personal and Server Editions
IBM’s DB2 V8.1 for Linux, Unix and Windows provides new levels of information integration. DB2 V8.1 allows access to any information, from any application, from any place in your organization. The trial release supports both 32- and 64-bit versions for AIX, HP, Linux, Solaris and Windows. The code h