(Craig S. Mullins) Optimal database performance is perhaps the biggest challenge managers and administrators face as they work to ensure delivery of BI to data warehouse (DW) users. No one likes to wait for answers. Squeezing every last bit of performance out of the hardware and software to make tho
Other News
Materialized Views
Materialized views (MVs), also known as snapshots, have been around for quite some time now. MVs store the result of a query in a segment and can return that result to the user when the query is submitted, eliminating the need to re-execute the query—an advantage when the query is issued several tim
MySQL to DB2 UDB Conversion Guide
(Whei-Jen Chen) DB2 Universal Database (DB2 UDB) has long been known for its technology leadership. This IBM Redbook is an informative guide that describes how to migrate the database system from MySQL to DB2 UDB Version 8.1 on Linux and how to convert applications to use DB2 UDB instead of MySQL.
Bulk Export Task
(Darren Green) The DTS Bulk Export Task was originally conceived in response to a problem with the OLE-DB provider for text files. For more details see DataPump truncates delimited fields to 255 characters. Whilst this problem can be fixed quite easily the Bulk Export Task still offers some benefits
Building Wiki Web Sites with ASP.NET and SQL Server
(Hector J. Correa) This article describes some of the advantages that Wiki Web sites provide and how you can use ASP.NET and SQL Server to create your own Wiki. You’ll learn how to write powerful parsers using the .NET regular expressions class and you’ll discover how to add sophisticated search fun
DB2 V8 Application Development cert prep, Part 7 of 7: User-defined routines
(Drew Bradstock) In this tutorial, you’ll learn about using user-defined routines with the DB2 Universal Database. You’ll see how you can utilize programming logic within DB2 to simplify and speed up your applications. This is the last tutorial in a series of seven that you can use to help prepare f
SQL Server Auditing and Notification
(Jeffrey Yao) There are lots of articles about how to do auditing, but there are few discussions about how to use the auditing results in a real time environment, for example, an employee salary table has a delete operation during non-working hours, a responsible DBA should be notified for this unus
Efficient Techniques for Modifying Large XML Files
(Dare Obasanjo) As XML has become popular as a representation format for large sources of information, developers have begun to have problems with editing large XML files. This is especially true for applications that process large log files and need to constantly append information to these files.
Unleashing the Power of Data
(Howard Goldberg) Ever since the dot.com bust, IT departments have taken some blame for bloated budgets, missed delivery dates, and questionable returns. Leave it to Merrill Lynch to demonstrate how to get IT investments right. After developing a flexible, extensible data warehousing model, Merrill
Managing content in an employee workplace, Part 1: Handle increasing volumes of content
(Sharon Lymer, Tinny Ng and David Stokes) Businesses today might not be buried in paper, but they are inundated with all sorts of digital content, from many different sources and in different formats. Employees struggle with managing the content, finding information, and overcoming technological cha