(Eric Smith) You often need to compare strings (or other data types), but sometimes a value could be null or DBNull if it’s coming from the database. The built-in C# comparison functions don’t handle nulls properly, so I wrote a couple of functions to take care of this for me.
Other News
ADO.NET vNext Part 2: Using the Object Services Layer
(Thiru Thangarathinam) The first installment of this three-part article series introduced the core concepts of ADO.NET vNext, including the Entity Data Model (EDM), Entity SQL, and the Mapping Provider. It also discussed the steps involved in executing entity SQL queries against the EDM and retrievi
Managing Distributed Transactions with ADO.NET 2.0 using TransactionScope
(Muhammad Mosa) A transaction is a unit of work. You use transactions to ensure the consistency and integrity of a database. If a transaction is successful, all of the data modifications performed during the transaction are committed and made permanent. If an error occurs during a transaction, you c
WebSphere Process Server made easy, Part 2: Installation and configuration
(Addison Goering) This tutorial outlines the procedures and best practices for installing WebSphere Process Server. You’ll also learn about configuration for the business process container. It is the second in a series of three tutorials on WebSphere Process Server. (R)
Master Class Jonathan Lewis Cost Based Optimizer
(Gerwin Hendriksen) A couple of weeks ago I was at a MasterClass from Jonathan Lewis about the Cost Based Optimizer. It was a very interesting two days and I like to give some nice highlights on the masterclass.
Hello World, Part 7: DB2 for Linux, UNIX, and Windows
(Claire Hong and Renata Kupresak) Welcome to the seventh tutorial in the “Hello, World! Series”, which provides high-level overviews of various IBM software products. This tutorial introduces you to some basic features and concepts in DB2 for Linux, UNIX and Windows and shows you how to implement a
Using Directory Iterators and MySQL with Adapter Objects with PHP
(Alejandro Gervasio) If you’re a PHP programmer who’s searching for a comprehensive tutorial on how to create adapter classes with PHP 5, them look no further. Welcome to the final installment of the series “Implementing adapter objects with PHP.” Made up of two parts, this series teaches you how to
Oracle throws weight behind embeddable DBMSs
(Mark Brunelli) Oracle is putting more resources and energy into the embeddable database management system (DBMS) market. (R)
SQL – Using GROUP BY with HAVING
If you need to restrict the number of rows returned in an SQL query in which you are using an aggregate function and a GROUP BY clause, you can use the HAVING clause instead of the WHERE clause.
Meet compliance with improved database security practices
(Kevin Beaver) Whether management at your organization has bought into it or not, information security compliance is here to stay. It seems that every type of organization and every aspect of business is covered one way or another. (R)