Cluster Administrator provides a method to rename cluster resources. To do this, right-click the resource in Cluster Administrator and click Rename. However, if you rename the SQL Server Network Name resource, a variety of situations could occur, the most critical being that the SQL Server virtual s

(Itzik Ben-Gan) T-SQL query can use any of three clauses—ON, WHERE, and HAVING—for specifying logical expressions that SQL Server uses as filters. The three filters play different roles, but sometimes it can be difficult to know which clause you should specify a logical expression in. Most T-SQL

SQL Server supports connections to other OLE DB data sources on a persistent or an ad hoc basis. The persistent connection is known as a linked server; an ad hoc connection that is made for the sake of a single query is known as a distributed query. Microsoft Excel workbooks are one type of OLE D

(Darren Fuller) In this first article of a 4 part series, Darren Fuller discusses the need for database change management and problems with current approaches. Future articles in the series will examine an automated methodology, the requirements to implement such an approach and describe the benefit

(Muthusamy Anantha Kumar) In a large IT department, it can be difficult to locate where new SQL Server installations were made and how many of those SQL Servers were patched, etc. This article explains how to scan the entire network for a range of IP addresses to find which boxes have SQL Server

In Analysis Services a Member’s Unique Name may be different depending on the setting of the MDX Unique Name Style connection string property of the Microsoft OLE DB Provider for OLAP 8.0. This article describes the different formats of the Member’s Unique Name and when you would want to control the

(William Pearson) In this article, our exploration of chart reports will move into an examination of the line chart. Line charts are another popular chart type, and are likely to be familiar to the majority of us, if not in the context of report authoring, then at least as an information consumer.

When editing the properties of an indexed view article that is part of a transactional publication, changes made to the Replace INSERT commands with this stored procedure call, Replace UPDATE commands with this stored procedure call, and Replace DELETE commands with this stored procedure call check

(Leo Peysakhovich) When I begin to design a new database for a client, one of the dilemmas facing me is how to construct lookup tables. When we say that a table is a lookup table for another main table, we mean that the lookup table contains values that will be used as the content of a column lo

(Akeel I Din) The Structured Query Language, SQL is a query language which is used with relational databases. This chapter starts by describing some of the terms used in data processing and how they relate to SQL. The later part of this chapter describes relational databases and how SQL is used to q