By Mitch Wagner – Protegrity introduced Secure.Data F3 for Microsoft SQL Server 2000, combining security software with cryptographic hardware from nCipher.

I have seen information about how sort order affects performance in SQL Server 6.5, but I can not find similar information about sort-order performance in SQL Server 2000 or SQL Server 7.0. I am trying to decide if using binary sort makes sense for my SQL Server 2000 application. What is the perform

By Brad McGehee – What’s is really like to experience a SQL Server cluster failover on your most important production server?

Join author Bill Pearson as he expands our cube building skills to create an integrated Financial Reporting Cube. This two-part lesson will present hands-on practice in building core cube structures from multiple data tables and developing the initial design to focus on the production of financial s

You can import an XML file into SQL Server in several ways. Here are three approaches:

By Greg Robidoux – This document analyzes the various options available for your backup and recovery process with SQL Server 2000. The next part of the series will present best practices and tips.

Brian Moran talks more about his conversation with escalation engineer Bob Ward and the thoughts he shared about three common problems that many database customers bring to PSS.

by Morris Lewis – Find out about SQL Server security in this chapter except from SQL Server Security Distilled from Curlingstone Publishing. Find out more about this book from Amazon.com.

SQL Server 2000’s Query Analyzer (QA) is greatly enhanced over SQL Server 7.0’s QA and specifically offers an enhancement, QA templates, that can increase your productivity in developing code. This article from Gregory Larsen shows you how to use and write your own Query Analyzer templates.

By Erika Morphy – Ultimately, the CIO’s selection of a database system is driven by the needs of the applications it must support, along with a complex matrix of other issues.