(Chris C. Gruber) Integrate your ODF and Microsoft Office 2007 documents into your enterprise and Internet applications more easily than ever before with IBM DB2 9. Review older methods of data interchange with MS Office documents, and learn how MS Office 2007 offers better data interchange. This ar
Other News
Update statistics and getting configuration parameters in DB2 LUW using db2look
In one of our previous blog post, we covered how we can use db2look utility to generate DDL. Today we will see one more use of db2look utility to obtain the database level parameters and registry variables and generate SQL to update the statistics.
New Parameters in 11g (Part 3)
(Howard Rogers) This one’s a bit of a snooze, I’m afraid. It’s only of use in a RAC, it controls the number of GTXn background processes each instance in a RAC is allowed to run, it defaults to a value of 1, and you don’t muck around with it unless you’re doing distributed transactions. It’s default
Data transformation in SOA using WebSphere Transformation Extender (TX)
(Boris Lublinsky) SOA implementation requires the creation of a significant amount of transformation code to align varied proprietary data models with the enterprise data model used by the service interfaces. In this article, learn current approaches to providing SOA data transformation and how the
Invisible indexes in 11G
(yas) 11G has a new feature called Invisible Indexes. An invisible index is invisible to the optimizer as default. Using this feature we can test a new index without effecting the execution plans of the existing sql statements or we can test the effect of dropping an index without dropping it.
DB2 9 and Microsoft Excel 2007: Part 4: Creating a Pivot Table…
(Paul Zikopoulos) In my previous article called DB2 9 and Microsoft Excel 2007: Getting the Data DB2 9, I showed you how easy it is to get data from an IBM DB2 9 data server into your Excel 2007 worksheets. I also showed you some of the neat Excel 2007 capabilities to ‘dress-up’ your data. In this a
Implementing Observer in ASP.NET
(Brian Mains) The observer pattern is a design pattern, largely popularized by the Gang of Four, which allows objects to receive notifications from another object. Imagine a newsletter signup page, where you can signup for various newsletters that are broadcasted by email. There needs to be the abil
The full-text crawl takes a long time to finish when you create a full-text index on a column that has the varchar data type in SQL Server 2005
Consider the following scenario. In Microsoft SQL Server 2005, a table has a primary key constraint. The primary key constraint contains a column that has the varchar data type. You create a full-text index on the column. In this scenario, the full-text crawl takes a long time to finish. Additionall
A First Look at Visual Studio 2008 Shell
(Josh Fitzgerald) The 2007 TechEd conference had some big announcements concerning Visual Studio. The first announcement introduced the official name of the next version of Visual Studio. Long known as Orcas, the next version has been officially named Visual Studio 2008. The second announcement that
Reduce the Contention on tempdb with Trace Flag 1118: Take 2
(Linchi Shea) My earlier attempt to see what’s going on with trace flag 1118 on SQL Server 2005 SP2 (9.00.3042) didn’t take me too far because the results were not conclusive. I was motivated by seemingly conflicting suggestions from KB article Q936185 and whitepaper Working with tempdb in SQL Serve