(Marcin Policht) Extraction, transformation, and loading’s primary objective is to facilitate moving data between its source and destination while subjecting it to arbitrary modifications, and has been an integral part of the Microsoft SQL Server product line for a number of years.
Other News
Creating custom project template for Visual Studio with pre-installed NuGet packages
(Kedar Kulkarni) Recently I published an article about creating custom project template in visual studio with additional wizard window. After reading it, one of my colleague asked me what if I want to include all commonly used NuGet packages in custom project template?
Micro Caching in ASP.NET
(Keith) I was recently involved in rewriting the homepage for a major airline company. Performance was critical as the site receives many hundred hits every second just on the homepage alone. It required heavy use of the database due to a high level of personalized content and targeted advertising a
Use A Return Statement When Invoking Callbacks, Especially In A Guard Statement
(Ben Nadel) In a synchronous processing workflow, the Return statement tends to indicates the end of a given function’s execution. In an asynchronous processing workflow, callbacks are more generally used to indicate the desired end of a given function’s execution.
MySQL command line vs. visual editors – reflections
(Shlomi Noach) My previous post drew some attention, and in particular two comments I wish to relate to. I also wish to make a more fine-grained observation on visual editors.
Building Help Files with Sandcastle
(Richard Carr) XML documentation comments allow useful descriptive information to be attached to types and their members. This information is displayed within Visual Studio whilst coding but sometimes it is more useful to produce documentation as help files.
Build integrated solutions for XML transformations with WebSphere Transformation Extender, Part 1: Transform legacy data into XML
(Elisa CY Su, Jervis Lee and Owen Chang) The Extensible Markup Language (XML) format is a common standard for document and message exchange. Learn how to use WebSphere Transformation Extender to easily migrate legacy data to XML. WebSphere Transformation Extender separates data transformation logic
Got LOBs? Get DB2 10 for z/OS (Part 1)
(Robert Catterall) In my previous entry, I provided information pertaining to the amount of data that can be stored in a LOB column of a mainframe DB2 table (LOBs being DB2 data values that can exceed 32 KB in length). I made brief references in that entry to significant enhancements in LOB data man
IBM Optim Performance Manager 5.1, Part 1: Install
(Thuan Bui) IBM Optim Performance Manager is a performance analysis and tuning tool for managing DB2 systems using a web interface. Part 1 of this demo series describes IBM Optim Performance Manager 5.1 architecture and packaging, and how to install the product.
Designing a database for multi-tenancy on the cloud
(Raul F Chong) Learn some considerations that new software as a service (SaaS) vendors need to take into account when developing applications or modifying existing ones to enable them for multi-tenancy on the cloud.