(Eli Leiba) Here is a brief comparison between Oracle 9i and SQL Server 2000. Find out why the author thinks Oracle comes out ahead in this comparison. (R)

Just days before it cast Windows NT 4.0 Workstation into the no-support zone, Microsoft issued its fourth service pack for Windows 2000, the operating system that succeeded NT in early 2000. Windows 2000 Service Pack 4 (SP4) is a collection of over 650 fixes and doesn’t add any new functionality, un

By Vyas Kondreddi – This new ebook helps Oracle DBAs learn SQL Server 2000 and get upto speed quickly!

By Sandra Rossi – TruSecure has started monthly briefings to keep its customers in step with evolving IT security threats by sharing feedback from its 30-member, global intelligence reconnaissance team. Noel’s risk predictions include an attack in the next six months of a blended virus utilis

The following script will return the name and the number of rows in every user-defined table in a given database:

by Evangelos Petroutsos – Combine SQL Server’s XML support and .NET XML serialization to simplify your front-end code by moving custom objects rather than DataSets between application layers and into and out of SQL Server.

By Itzik Ben-Gan – When your query needs to find items with certain relationships, you can use relational division, or you can try these new tricks.

You will find articles on this site as well as others advising you to avoid the use of temporary tables to maximize the performance of your queries. I agree with the articles, but would like to add that sometimes you cannot avoid the use of a temporary table.

Q. I want to import Microsoft Word documents into SQL Server and then index the documents so I can use them in relational queries. How can I import and index the documents? A. SQL Server allows you to import Word documents in several ways. Let’s look at the most common methods.

Q. How can I turn an IP address held as strings into binary values? A. With SQL Server 2000, you can use the following function: