(Niall Litchfield) Just over 9 years ago now, before usenet died , I posted a list of common myths regarding the Oracle RDBMS. You can find that list and the ensuing discussion here. Number 2 in my list was
Other News
Load plans – getting up and running
(David Allan) To get up and running with load plans there are a few things you’ll need to do in order to execute them. One is to setup your agent, if you haven’t got one, there is a useful ODI 11g OBE below that explains how to configure a standalone agent;
JavaScript Delete() Only Affects The Referenced Object Regardless Of Prototype Chain
(Ben Nadel) Yesterday, I blogged about extending the window (global) object in JavaScript. In that post, I used the delete() function (or keyword if you like) to alter various parts of the resulting prototype chain in order to create a dynamic runtime environment.
Grouping Sets in SQL Server 2008
(Shirsendu Nandi) In this article I will describe grouping sets in SQL Server 2008 and the advantage of grouping sets compared to a simple Group by clause.
IBM Cognos Proven Practices: IBM Cognos Express SharePoint Configuration
(Haytham Yassine and Jane Li) This document demonstrates step by step how to enable IBM Cognos Express integration with the Microsoft SharePoint portal.
Capturing and Alerting on SQL Server Configuration Changes
(Robert Pearl) Once a SQL Server is initially configured, we would love nothing but to “set it, and forget it”. However, in the real world, especially with multiple SQL Server environments to manage, we need to keep track of any changes to the configuration, which could impact the environment.
Index Maintenance
Index Maintenance Yesterday I talked about SQL Server Indexes and how important it is to keep them from becoming fragmented in your database. Defragmenting clustered indexes cause all the data to be grouped contiguously on the disk. Defragmenting non-clustered indexes cause those indexes to also be located contiguously on the disk. So, in order to defragment both the data and […]
Backup and Restore in SharePoint 2010 using PowerShell
(K. G. Sreeju Nair) It is essential to have proper backup/restore strategy in place for your SharePoint farms. SharePoint 2010 provides three types of tools for backup/restore for your server farm.
Simple Object Access Protocol (SOAP) Tutorial
SOAP has gained status as a common messaging protocol in Web services and SOA projects. This SOAP tutorial provides insight as to what SOAP standard is and when to use it. SOAP basics, how it compares to REST, SOAP attachments and how SOAP functions with WSDL will be covered.
ETL and Publishing
(Rick Jelliffe) I have for a few years been trying to come up with a good definition of publishing workflows: as an architectural pattern. The two key distinctive features, I think, are that publishing workflows are one-way flows rather than two-way flows (e.g., database/middleware CRUD and triggers