(Jayaram Krishnaswamy) If you have ever wanted to create and use variables with global scope with the Microsoft DTS designer, this is the article for you. Two examples are used to illustrate the process, which involve deleting and updating records.

(Klaus Aschenbrenner) Software security is a very important topic, because not a single day passes without the discovery of some new exploit. Windows 2003 Server was the first product Microsoft shipped under the motto “secure by default.” The whole server is locked down by default, and you have to a

When you try to install Microsoft SQL Server 2000 Service Pack 4 (SP4), the installation process may fail, and the following message may be written to the Replsys.out file: Login failed for user ‘User’. Reason: Server is in single user mode. Only one administrator can connect at this time.

(Arthur Fuller) Horizontal partitioning is the process of creating at least two physical files for a database’s tables. The larger a table, the longer it takes to scan. So the general motive behind horizontal partitioning is to move seldom-used data into a second file.

(Aaron C. Newman) The database community has begun to realize its role in a robust information security infrastructure. Traditionally there has been little concern for the security of relational database systems, and for the vast amounts of data they house. In the early days of relational databases,

Consider the following scenario. You format a tape drive in Microsoft Windows Server 2003. You use this tape drive to back up Windows Server 2003 by using the Ntbackup.exe program. Then you try to back up a Microsoft SQL Server 2000 database to the same tape drive. In this scenario, you may receive

(William Pearson) In this article, we will explore features that integrate Analysis Services and MS Office Excel 2003, to provide a vehicle for client reporting and other business intelligence capabilities. The central focus of the article will be a basic overview of the Excel 2003 PivotTable Report

(Andrew Novick) In a recent article I showed how to create a User Aggregate function SQL Server 2005 using the .Net CLR. Recently I got a note from Joe Celko about producing the aggregate with SQL instead of resorting to CLR programming. Joe isn’t enthusiastic about running non-SQL code inside of

In Microsoft SQL Server 2000 Analysis Services Service Pack 3 (SP3), a new registry value controls server behavior when a pre-SQL Server 2000 Analysis Services SP3 client tries to access the server.

(Marcin Policht) We are continuing our overview of different types of enumerators available in the Foreach Loop Container of SQL Server 2005 Integration Services. The ones covered so far provided the ability to iterate over a set of files matching an arbitrary set of criteria (Foreach File Enumerato