(Christopher Ahlberg) Why can a sales VP quickly and easily find the location and availability of a specific hotel on a street in Uzbekistan with Google maps and a travel site, but cannot easily target the right customers with the right offers based on their demographics in his company’s business in
Other News
New ASP.NET Dynamic Data Support
(Scott Guthrie) The ASP.NET 3.5 Extensions CTP we shipped this past weekend contains a bunch of great new features.
Enhance Your AJAX Applications with Visual Cues
(Ivan Pepelnjak) The traditional user interaction in classic web applications was well understood: You click, the browser freezes (apart from the rotating wheel on some edge of the window), and then the new content appears. AJAX technologies (particularly the background HTTP requests and the dynamic
Working with ModalPopup Ajax Control
(Electronic Screw) This article explains using the ModalPopup Extender available in the ASP.NET Ajax Toolkit. ModalPopup Extender comes in handy when you want to display information on the page modally. I have used it in a couple of sites to display: 1. Tip of the day information 2. Login dia
Create and install packages using the DB2 Install Utility
(Hardeep Singh and Karen Devlin) Installing a package that requires DB2 interaction often requires detailed, step-by-step instructions. Any failure on the part of the user can cause unexpected errors and lead to frustration for the user. This article describes a utility that can be used to simplify
NOT IN, NOT EXISTS and MINUS: an aide-memoir
(Andrew Clarke) A colleague asked me whether NOT IN would return the same as MINUS. I said it would depend on whether the results contained nulls. I confess to not being clear as to how the results would be affected by the presence of nulls, but it’s easy enough to knock up a test case.
Debugging PL/SQL Code
(Steven Feuerstein and Bill Pribyl) In this eighth part of a nine-part series on managing PL/SQL code, you will learn some effective debugging strategies. We’ll also begin talking about tuning PL/SQL programs.
Set Functions: The .AllMembers Function
(William Pearson) In this lesson, we will introduce a basic, but highly useful, set function in the MDX toolset, the .AllMembers function. The general purpose of .AllMembers is to return a set composed of all members within a specified dimensional level or hierarchy. The set returned includes all ca
Oracle 11g: ALTER TABLE READ ONLY
One more nice enhancement in Oracle 11g is the change that is made to the ALTER TABLE command. In prior versions, to make table read only we have to grant only SELECT privilege on the table. But table was still available for read and write to creator of the table. With this new enhancement to the ‘A
SQL Server 2005 does not validate all articles in a transactional publication when you run the sp_publication_validation stored procedure to validate the articles
Consider the following scenario. You have a transactional publication in Microsoft SQL Server 2005. Some articles in the transactional publication have the column filtering feature enabled. You run the sp_publication_validation stored procedure to validate the articles in the transactional publicati