(scott) Relational databases like SQL Server use indexes to find data quickly when a query is processed. Creating and removing indexes from a database schema will rarely result in changes to an application’s code; indexes operate ‘behind the scenes’ in support of the database engine. However, creati

(Jeffrey Juday) If you’re familiar with SQL Server 2005 Integration Services (SSIS) you’re probably aware that SSIS includes vast improvements over SQL Server 2000 Data Transformation Services (DTS). Among these improvements is extensive .NET support, which comes in many forms. For example, the

(James Curran) This articles shows how to retrieve a list of PCs on the local network which are running MS SQL Server, and gets information about the instances, such as server name, instance name, version, and databases.

(Mel Shum) As a DBA, one of your many tasks is to manage your SQL Server databases’ ever-expanding storage requirements. How often do you find yourself adding more disk, trying to accurately size a database, or wishing you could more efficiently use your existing disk capacity? Storing database

(Scott Lowe) SQL Server 2005 has finally hit the market and brought with it significant new features and changes from previous versions. This document explains the various editions of SQL Server 2005 and provides you with an overview of the new management console.

(Jason Blumberg) Successful universities are ultimately driven by student enrollment rates. Moreover, the valuable information locked inside enrollment data holds the key to successful marketing tactics and improved revenue. Recognizing this, Capella University’s executive management team launched a

(Serdar Yegulalp) The larger the SQL Server backup set, the more likely you are to have some kind of error. This isn’t to say that errors are inevitable, but they are more likely to occur during a large backup (1 GB or more). Since restore operations for big backup sets are not trivial (and take a l

(Jagadish Chaterjee) This article explains how to develop .NET based components and access them using Microsoft SQL Server 2000.

In Microsoft SQL Server Management Studio, you receive the following error message when you try to open Microsoft SQL Server 2000 Data Transformation Services (DTS) packages: SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, “SQL Server 2

(Muthusamy Anantha Kumar) Part I of this article provided general guidelines on how to backup a SQL Server 2000 Analytical database manually. Part 2 examines how to automate this backup process of Analytical databases from various servers.