|
|
-
|
|
With the 2008 release, SQL Server Integration Services (SSIS) continues its advance in the enterprise data integration arena. Integration Services offers an entire architecture that combines the required elements for building solutions that provide high sc...
|
|
-
|
|
As SQL Server matures with time, the diagnostics tools available to administrators to troubleshoot problems when they arise have also matured. SQL Server 2000 had very limited diagnostic tools when compared with SQL Server 2005. SQL Trace and SQL Server Pr...
|
|
-
|
|
In this paper we’ll walk through an introduction to Windows PowerShell and its key elements. We’ll then look at the special PowerShell executable program provided with SQL Server 2008, sqlps.exe. Sqlps.exe incorporated a set of cmdlets specific...
|
|
-
|
|
This article is intended to help you get over the initial barrier of learning how to query XML in SQL Server, so that you can create database unit tests on SQL-XML stored procedures. You can create feature tests much more easily after you have working know...
|
|
-
|
|
This paper explores Policy-Based Management, a new management feature introduced in SQL Server 2008. Policy-Based Management allows DBAs to define a set of policies that can control many different aspects of SQL Server. Policies can be applied to a single ...
|
|
-
|
|
SQL Server 2008 introduces the Management Data Warehouse (MDW) to SQL Server Management Studio for streamlined performance troubleshooting. MDW is a set of components that enable a database developer or administrator to quickly track down problems that cou...
|
|
-
|
|
SQL Server Integration Services is a high-performance enterprise-level Extract, Transform and Load (ETL) platform for a wide variety of business intelligence and data warehousing projects. Although Microsoft included Data Transformation Services (DTS) with...
|
|
-
|
|
Data mining was once a very expensive technology that was used by small elite teams in head offices of a few very large companies. Now that data mining algorithms have become a commodity, anyone can employ data mining algorithms at a very low cost. For exa...
|
|
-
|
|
Data Quality Manager (DQM) is a commercial data integration application that provides Data Profiling, Data Cleansing and Matching, and Management Dashboard functionalities. It lets the user conduct data investigations and profiling, and measure gaps agains...
|
|
-
|
|
Calling the Web service is a powerful way to transfer data to or from SharePoint, whether or not you have extensive rights in your SharePoint environment, because it does not alter the SharePoint server itself in any way. The Web service also uses the Batc...
|
|