Conor O’Mahony, Program Director in the IBM software group, discusses migrating from Oracle Database to IBM DB2 and how Oracle DBAs can use their skills against DB2.
Other News
DB2 10 for z/OS: 23 Things to Think About NOW!
(Julian Stuhler) Whether your business is planning to implement DB2 10 for z/OS in a matter of months or years, there’s no getting away from the amount of preparation work that can and indeed, should be done sooner rather than later.
Execution Plan Changes when the OPTIMIZER_FEATURES_ENABLED Parameter is Changed, But Why?
(Charles Hooper) A question appeared on the OTN Database forums yesterday that has yet to receive an answer. The question was essentially, why did the execution plan change when the OPTIMIZER_FEATURES_ENABLED parameter was adjusted from 11.2.0.2 to 11.1.0.7, and why did the execution performance im
ADF 11g R2 Model Layer Validation Functionality
(Andrejus Baranovskis) There is new functionality available in ADF 11g R2 – ADF Model layer validation. In the most of the cases, we define validation in ADF directly inside ADF BC, on Entity objects. Depending on the use case, not all fields rendered on UI can be based on ADF BC attributes.
WCF Data Service
(Dinesh Sabnani) Let’s learn what is WCF Data Service, How to create and Consume it. This blog is going to cover following topics:
Exporting XML columns from SQL to file in SSIS
(jftl6y_007) I had a requirement to facilitate some testing with an internal customer which involves periodically exporting XML which we store in SQL Server as XML data types. One requirement was to use some column data (e.g. a sequence number, dateTime and identifier) being returned in the query a
Problem with deleting table rows using ctrl+a for row selection
(Frank Nimphius) The following code is commonly shown and documented for how to access the row key of selected table rows in an ADF Faces table configured for multi row selection.
SQL SERVER – Fix: Error: 147 An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference
(Pinal Dave) Everybody was beginner once and I always like to get involved in the questions from beginners. There is a big difference between the question from beginner and question from advanced user.
Simple .NET Database Programming using SQL Azure
(Mahesh Sabnis) Windows Azure provides a high scalable and fault-tolerant environment that lets developers create powerful distributed applications without the overhead to maintain and configure hardware and operating systems.
Html5 Offline Cache Integration with ASP.NET MVC Bundle
(Kazi Manzur Rashid) One of the lesser known and misunderstood feature of Html5 is offline cache, with carefully crafted it can make your application blazingly fast. In this post, I will show you how can you implement offline cache with the new asp.net asset bundle, the same technique can be also ap