(Arup Nanda) New features for more efficiently managing materialized views, Query Rewrite, Transportable Tablespace, and table partitions make your data warehouse an even more powerful, and less resource-intensive, asset.
Other News
How to Failover in HADR
(Chris Eaton) In my last post I talked about the synchronization modes in DB2 HADR. Now let’s talk about failing over. As I have mentioned previously the two primary goals for HADR are fastest failover possible and easy to use. This remains the case for failover as well. To achieve the fastest failo
Harnessing the Power of SQL Server Using Stored Procedures
(Grant Szabo) I’ve been developing ColdFusion applications since the early days of version 1.5. While a lot has changed for the better with the product since then, not a lot has changed – unfortunately – in terms of the lousy quality of the CFML code that I’m often asked to review or fix.
Using the Excel XML Toolbox for Microsoft Office Excel 2003
(Chris Kunicki and Charles Maxson) The Excel XML Toolbox for Microsoft Office Excel 2003 provides a number of useful tools for working with XML in Excel 2003. This article walks through a few major features of the toolbox and discusses their benefits.
Cryptography and .NET – Part 4 (Hash Values)
(Bipin Joshi) In previous parts of this series (Part 1, Part 2 and Part 3) we saw various techniques of encrypting the data. In this part we are going to learn how to ensure that data coming to you has not been tampered with during the transfer. The technique that we will be using is hash. Hash valu
XSL Transformation with Perl
(Harish Kamath) Perl may not be as well known as some of the other languages, but it boasts a powerful library of packages and modules that everyone can use to work with XML. In this article, Harish Kamath explains how to get started with the “XML::XSLT” package that allows you to transform XML docu
Query to Find Second Saturday
(Chacravarthi Ramasami) This tip was submitted for use with Oracle8i. This query gives the second saturday of each month for the present year.
SQL Server 2005 – SQL Server Integration Services – Part 5
(Marcin Policht) In the previous article of this series, we started reviewing two new types of containers introduced in the SQL Server 2005 Integration Services – For Loop and Foreach Loop. We also provided a simple example illustrating the use of Foreach File enumerator. We will continue our re
Writing Secure Code with Visual Studio
Rick Samona shows enhancements to Visual Studio 2005 that help make applications more secure. Learn fundamental design principles for building secure apps. See how FxCop and Code Access Security help create more secure managed code apps, while PREfast and the /GS switch help secure native code apps.
IBM DB2 Content Manager document routing, Part 1: A guided tour to process modeling
(Alan Yaung and Allan Tham) This first article in a series of three articles will introduce you to IBM DB2 Content Manager document routing and walk you through process modeling. The series uses a claim process case study for examples to show the reader implementation and usage of APIs. Also pro