(Scott Robinson) How to design and implement efficient data cubes for OLAP use in a data warehouse using SQL Server 2000. (R)

(Narayana Vyas Kondreddi) As the title suggests, this is a book about SQL Server replication, and just about SQL Server replication. Yes, at last, there is a dedicated, comprehensive book, that covers all aspects of SQL Server 2000 transactional and snapshot replication. This book comes from Hil

(Chip Andrews) So you’ve decided to secure your SQL Server infrastructure and you don’t know where to start. This first guide in a two-part series on SQL Server patch deployment will help you track down those pesky servers before getting them properly patched. (R)

(Buck Woody) Oracle enthusiasts love to bash SQL Server, and Buck Woody thinks it’s high time that the debate is taken to a professional form. If it’s to be an argument, he wants to involve the discipline of logic to see which is better: SQL Server or Oracle. Care to see who wins?

(Peter Scheffler) A few years ago, I was presented with an interesting challenge from a prospective customer – design a database application without knowing the eventual database structure.

(Andrew Novick) The first four articles in this series have been about writing trace information to the AppSession, AppSessionTrace and AppSession. I’ve found this a useful technique for developing and using non-trivial stored procedures. If I keep the traces turned on in production, all those row

In Data Transformation Services (DTS), you can extend the capabilities of your DTS package by using Microsoft ActiveX scripts that implement the objects, properties, methods, and collections of the DTS object model. Using ActiveX scripts, you can: –Format and transform the data as it is copied

(Slava Oks) SQLOS’s memory manager consists of several components such as memory nodes, memory clerks, memory caches, and memory objects.

After you apply post-Microsoft SQL Server 2000 Service Pack 3 (SP3) hotfix build versions between 8.00.0859 and 8.00.0875, applications that execute a stored procedure that uses a SET NOCOUNT ON statement and that return one or more result sets following an informational message, a RAISERROR stateme

(Darren Green) One of the benefits of the SQL Server 2000 is that the SQL tasks support mapping of global variables to parameter placeholders within the SQL. This means you can use the global variable as an input parameter for your stored procedure.