SQL Server Integration Services (SSIS) is not only a high-end ETL (Extract Transform and Load) tool but also a general purpose data integration utility that goes beyond traditional ETL. Kamal Hathi demonstrates the integration of data from a variety of data sources, including XML and Web Services.

When you stop a full-text search in SQL Server 2000, latch time-out errors may be written to the SQL Server error log, and full-text queries may not be returned. These errors in the SQL Server error log appear similar to the following: 2005-03-08 13:28:52.19 spid135 WARNING: EC 617e9520, 0 waite

(Kirk Haselden) Integration Services is of all things a platform. While some platforms are pretty useless until you actually build something with them, SDKs and APIs like DirectX etc (Yes, definitions of “platform” differ) others are extremely functional out of the box, Windows, Office etc.

(Steven Warren) You can monitor the system performance by using the Performance monitor console and its related counters in Windows 2000. These counters allow you to view or save information about the overall performance of your server. When you install Microsoft SQL Server, additional Performance m

(Jeremy Kadlec) All too often, organizations attempt to resolve performance issues with a quick fix or magic bullet to keep the business moving ahead of the competition. The perception is that there is no time for planning, designing or testing a solution; you have to move from problem identific

(Geert Vanhove) “A known value against which later measurements can be compared” is one of many definitions for SQL Server baselining. In this article I want to share my findings with you on this subject.

(Chip Andrews) Truth be told, most of the SQL Server installations in your enterprise probably fall into one of two categories. Category one is developer machines that have installed SQL Server (i.e., one of the various install types — Desktop Edition, Standard Edition, Enterprise Edition or the ob

(Serdar Yegulalp) A NULL value in SQL Server is one of those things that people claim to understand, but they often write code that doesn’t reflect how NULL values are actually handled. Because of this, it’s all too easy to create queries that don’t behave correctly, even when they might outwardly s

Consider the following scenario. You use Kerberos authentication to connect to a computer that is running Microsoft SQL Server 2000 Analysis Services from your Microsoft ASP.NET application. When you then try to run a statement, you receive the following error message: The operation requested fai

(Arthur Fuller) In almost every small organisation I’ve been with, and, surprisingly, in many medium-size organisations as well, there is no OLAP database. This may be in part because of a lack of human resources.