(Marcin Policht) In a recent article dedicated to Integration Services on this forum, we started exploring their ability to interact with other Business Intelligence-related features of the SQL Server 2008 R2 product line, focusing in particular on Analysis Services.
Other News
Setting up Exalogic using IB with SDP enabled Data Sources to Exadata
(Pas Apicella) Got the opportunity to setup a 1/2 RACK EL (Exalogic) with a 1/2 RACK ED (Exadata). My role was to setup the EL RACK and configure WebLogic and Coherence and also TCP/SDP GridLink Data Sources. Here I will document the process of how we setup our GridLink Data Sources to use SDP enabl
Undo, Redo, and new SSIS Toolbox Features
(Carla Sabotta) In SQL Server “Denali”, you can undo and redo up to 20 actions in the SSIS Designer.
OWB 11gR2 – Creating Interval Partitions
(David Allan) Designing partitioned tables in OWB is done in the table editor in the partitioned tab, the partitions tab let’s you design and deploy complex partitioning strategies. Here we will see how to define an interval partition (see an example in the Oracle Database VLDB and Partitioning docu
From XML to Form to Diagram with Sapphire
(Konstantin Komissarchik) Many of the systems that developers and administrators interact with on the daily basis are configured via a menagerie of XML files. Even armed with a schema and a good XML editor, users have a hard time editing these files by hand.
Remove duplicate rows with Oracle SQL ROW_NUMBER – intelligent and efficient data cleansing
(Lucas Jellema) I am quite sure I have addressed this before. But I could not find it readily and I needed it today. So here it goes:
jQuery Plugin: triggerHandlers() – To Trigger Handlers On All Selected Elements
(Ben Nadel) jQuery has a core method called trigger(). This method will trigger the given event on the selected elements and then propagate the event up the DOM before activating the default behavior (assuming it wasn’t explicitly prevented somewhere in the bubbling phase).
Parallel Programming Using New TPL Library in .Net 4.0
(Amit) There days nearly all computers are assembled with multicore processors. Now the time is different from when you had simple single-core processors processing a single instruction at a time of your program. If you are creating an application that has to be installed on a multicore CPU machine,
C# Practice Makes Perfect
(Mark Bowytz) For years, nobody cared that the legacy image-syncing application consumed as much bandwidth and processing time as it did.
The Past, Present and Future of Parallelizing .NET Applications
(Stephen Toub) Direct thread manipulation has historically been the way developers attempted to achieve responsive client applications, parallelized algorithms and scalable servers. Yet such techniques have also been the way developers historically achieved deadlocks, livelocks, lock convoys, two-st