(Crysta Anderson) Even DBAs have to prepare for the Christmas rush. We recently spoke to IBM Champion for DB2 Iqbal Goralwalla, who has been very busy working with customers to ensure their DB2 environments are ready for year-end traffic that brings heavier workloads.
Other News
Defining a DDF Location Alias
(Troy Coleman) Recently I introduced the MODIFY DDF command in DB2 10 and explained how it can be used to STOP and START connections to support maintenance windows. MODIFY DDF can also be used to define DDF locations so you can manage subsets of data sharing members dynamically (online) without the
SQL Developer Quick Tip: Accessing SQL History with the Keyboard
(Jeff Smith) When I’m doing my ‘Tips and Tricks’ show, there is at least one trick that is guaranteed to get the audience’s attention:
An update on RDF concepts and some ontologies
(Daniel J Lewis) Resource Description Framework (RDF) is the standard framework for the Semantic Web and a recommended framework for the Linked Data movement. This article details the most recent updates to and implications of the RDF concept specification. It also covers some new ontology specifica
Explain Plan, Autotrace and Diff
(Barry McGillin) A SQL statement can be executed in many different ways, such as full table scans, index scans, nested loops, and hash joins. The query optimizer determines the most efficient way to execute a SQL statement after considering many factors related to the objects referenced and the cond
Passing XML Nodes into Text Box Values and Passing the values from Textbox to XML Nodes
(Vishnu Prasad C) As Microsoft technologies have played a vital major role in the development stage, XML file handling is one of the mindblowing features which makes all our users comfortable. Particularly in business users perspective, XML has its own advantage.
SQL Server 2008 and 2008 R2 Integration Services – Slowly Changing Dimension Transformation – Type 1 Changes
(Marcin Policht) One of the primary objectives of SQL Server 2008 R2 Analysis Services is deriving meaningful information from relational data. This is accomplished by employing online analytical processing (OLAP) and data mining methods, which rely on manipulating multidimensional structures known
PL/SQL Key/Value Pair Utility
(Jason Bennett) KeyValueUtils is a simple (but very useful) Key/Value pair utility that allows you to define sets (collections) of KV pairs for use in PL/SQL applications.
Introduction to Silverlight
(Sheonarayan) In this article, we are going to have a fresh look at “what is Silverlight,how to install it,How will I know if Silverlight runtime is installed on my machine,what is XAML”.
Custom Validation in ASP.NET MVC 3 using DataAnnonationsModelValidator
(Mahesh Sabnis) In this article, I will demonstrate how to implement custom validation rules in ASP.NET MVC3. MVC 3 being an extensible framework, makes it possible for the developer to add user defined specific custom validations using custom data annotations.