(Destin Joy) When we add a Web Part from the List and Libraries category this list basically shows every List and Document Library we have on the SharePoint site. Actually behind the scenes the Data View Web Part is being used to display the List or Document Library data. In the following screen I a
Other News
Troubleshoot query performance in DB2 for Linux, UNIX, and Windows
(Samir Kapoor, Ani Patel and Tao Wang) Beginning with IBM DB2 for Linux, UNIX, and Windows V9.7 Fix Pack 1, the DB2 database manager has two new features for advanced query tuning: section explain and section actuals. This article walks you through detailed examples illustrating how to use these fe
Building a SQL Server DBA Department
(Jeremy Kadlec) In a recent tip, a DBA explained that he has SQL Server Agent Jobs created without his knowledge on a regular basis. He indicated that setting up proper security and a change management process would be the solution to this issue. Is that really all it takes to “tame” a SQL Server
Should I Use Composition or Inheritance?
Should I Use Composition or Inheritance? This is a topic with almost as much tension as database normalization. Many people lean toward composition over inheritance. Here is an example of the difference. Class Car extends Engine { var doors; } This design assumes you can’t have a car without an engine, inheriting from the engine class. Another way to handle […]
Find the needle in the haystack that is semantic web
(Brian Bentzen) Spending time at the IKS Paris Workshop this week, what strikes me first and foremost is the sheer distance; the distance between the skilled state-of-the-art developers and vendors, working with semantic web and the absent practitioner.
Optimize your Tablespaces and Bufferpools-1: Tablespace Design design
(samkumar) Well so getting back to db2… In this post I will discussing little bit on the physical database design…
Avoiding Duplicate Records in MySQL
(Alejandro Gervasio) In this MySQL database tutorial, you will be learning how to avoid duplicate records using “Primary Key” and the “Insert Ignore” SQL statement.
Using SQL UNPIVOT to prepare data for dynamic ADF Faces User Interfaces
(Lucas Jellema) The UNPIVOT operator was introduced in Oracle Database 11g – see for example: http://technology.amis.nl/blog/2421/the-oracle-11g-unpivot-operator-turning-columns-into-rows. In Oracle, the UNPIVOT operation is the process of turning Columns to Rows. Put simply, by applying the UNPIVOT
CFAbort And OnRequestEnd() Behavior In ColdFusion 8 And ColdFusion 9
(Ben Nadel) A couple of months ago, I blogged about changes in ColdFusion 9 that allowed the onRequestEnd() event handler to be called after a CFLocation tag. In the comments to that post, David Boyer brought it to my attention that, as of ColdFusion 9, the CFAbort tag worked the same – that is, tha
HierarchyId DataType in SQL Server 2008 – Get Level and String Path
(Paresh Prajapati) In previous post I have published of the overview of HierarchyId data type. In this post I am writing about details and the methods with hierarchy with HierarchyId data type.