Data storage provider Veritas last week announced a joint marketing and technical initiative with Microsoft to deliver tiered data protection solutions to users of Microsoft's SQL Server relational database. Veritas and Microsoft will jointly develop storage management, migration and

From SQL Team – Installing SQL Server on a cluster was much easier than I thought it would be. I hear it's even easier in SQL Server 2000. In it's current form a cluster is all about fault tolerance and doesn't have any load balancing. In essence you create a virtual server (or servers)

By Michael Otey – Microsoft recently released the Microsoft SQL Server 2000 Resource Kit. Like the other Microsoft resource kits, this one includes a book as well as a set of samples and utilities. The resource kit is available separately or as a part of TechNet, but so far it isn't included in

Garth Wells teaches readers how to solve everyday programming problems they will face when working with Transact-SQL.

by Edward Whalen and others – When I picked up this book and began to flip through the pages, I experienced a sense of deja vu, it was like I had read this book before. Upon closer examination, I had, it was the previous edition of this book, Microsoft SQL Server 7.0 Performance Tuning Technical Ref

By Brian Moran – If you don't know about Microsoft's Software Assurance (SA) program, now's the time to start learning. This fall, SA is coming to a SQL Server near you.

This article describes how to use the connection affinity mask option that is available in SQL Server 2000 SP1 or later.

Oftentimes, it becomes necessary to remove obsolete information from a relational database. Fortunately, Structured Query Language provides a flexible DELETE command that can be used to remove some or all of the information stored within a table.

by Alexander Chigrik – In this article, I want to tell you about some useful undocumented extended stored procedures. These extended stored procedures work with SQL Server 7.0, as well as with SQL Server 2000.

The User_Defined_Functions.exe file contains the User-Defined Functions white paper. The User-Defined functions white paper outlines the characteristics of the new user-defined function (UDF) feature that is introduced in Microsoft SQL Server 2000. The white paper also summarizes how you can create