10 Oct
Posted by jj as Database, SQL Server
Unisys and Microsoft have dispelled the perception that for high performance ETL, the only alternative is a UNIX-based solution. With SQL Server 2005 Integration Services, Microsoft and Unisys deliver an optimized ETL solution that will support even the most demanding enterprise Business Intelligence (BI) initiatives. They conducted a series of real ETL (Extraction, Transformation and Load) tests with Microsoft SQL Server 2005 Integration Services (SSIS, formerly known as DTS). Performance tests compared throughput, scalability and performance on both 32- and 64-bit processor configurations on a Unisys ES7000. SSIS demonstrated parallelism and the ability to utilize all available CPUs in multiple aggregation, parallel lookup and transformation testing.
Read the rest of this entry »
09 Sep
Posted by jj as SQL Server
Microsoft uses SAP as its primary Enterprise Resource Planning software. The Microsoft Enterprise Application Services Group depends on a variety of SAP systems for online transaction processing, batch processing and analytical reporting.
Read the rest of this entry »