外电消息,微软公司近日发布了SQL Server 2005 SP2,对它的数据管理和分析平台进行了成功的升级。 微软公司还宣布扩展了虚拟化的使用权利,能够使用户在服务器中获得SQL Server 2005企业版完全许可的无限制的虚拟要求。 客户在使用虚拟化技术时需要最大的灵活性,无论目(2007-03-01)
Throughout our coverage of SQL Server 2005 Integration Services, we have been primarily concerned with newly introduced and improved features, spending considerably less time discussing its performance advantages over Data Transformation Services. H(2007-02-13)
In the previous installment of our series covering SQL Server 2005 Integration Services, we reviewed the innovative design of this technology and its impact on performance. Within the context of the dual architecture (divided into Control and Data F(2007-02-13)
After concluding a broad overview of various aspects of SQL Server 2005 Integration Services, ranging from its innovative architecture, through main package design principles, along with debugging and deployment techniques, to security and performan(2007-02-13)
Continuing the overview of Data Flow components in SQL Server 2005 Integration Services, which we initiated in the previous installment of this series, we will focus now on the Lookup transformation. Its basic purpose is to combine data from two sou(2007-02-13)
In the recent articles of our series dedicated to SQL Server 2005 Integration Services, we have been covering the most popular Data Flow components. The latest article focused on Lookup Transformation, which combines records from two sources based o(2007-02-13)
Continuing the topic of data cleansing through applying approximate match algorithms, which we started in the most recent article of our series dedicated to SQL Server 2005 Integration Services, we will now present another Data Flow task in this cat(2007-02-13)
As we have demonstrated in the recent installments of our series, in addition to handling standard tasks associated with data processing (available also in legacy Data Transformation Services), SQL Server 2005 Integration Services offers some new, u(2007-02-13)
Continuing our coverage of SQL Server 2005 Integration Services Data Flow components, we will present Derived Column transformation, which, while serving primarily an auxiliary role, should not be ignored, since it offers considerable flexibility an(2007-02-13)
Extensive ETL (Extraction, Transformation, and Loading) capabilities that SQL Server 2005 Integration Services are based on, deliver such essential functionality as the combination and cleanup of data originating from heterogeneous sources or schedu(2007-02-13)
Following presentation of the most popular Data Flow transformations in SQL Server 2005 Integration Services, we are revisiting the topic of Control Flow tasks, in order to make our coverage more complete. Among the most common tasks that have not y(2007-02-13)
In this installment of our series dedicated to SQL Server 2005 Integration Services, we will review a Web Service Control Flow task that exposes an infinite range of easily deployable features by leveraging capabilities present in the .NET Framework(2007-02-13)
The importance of XML-based technologies is steadily increasing and this trend is reflected by a variety of new features in this category introduced in SQL Server 2005 Integration Services. One of the most prominent ones is the XML Control Flow task(2007-02-13)
In the previous article of our series dedicated to SQL Server 2005 Integration Services, we started discussing various types of actions that can be performed using XML Control Flow task, covering its Validate and XSLT options. We will continue this(2007-02-13)