Read this META Group evaluation to see how SQL Server 2000 and Windows 2000 Datacenter Server performed on a scalability test run by Unisys and Accenture.

by Ken North – XML, Web services, analytics, and other hot technologies have the leading relational DBMS providers working overtime to remain the best choice for managing all of your data. Here’s a look at what IBM, Microsoft, and Oracle are doing.

By Michael Otey – Knowing what not to do is important because violating these precautions can ruin your ADO.NET application’s performance or compromise the security of your SQL Server system.

By Alexander Chigrik – Should you have problems with Analysis Services, review this troubleshooting checklist to find potential solutions.

To randomly order rows, or to return x number of randomly chosen rows, you can use the RAND function inside the SELECT statement. But the RAND function is resolved only once for the entire query, so every row will get same value. You can use an ORDER BY clause to sort the rows by the result from the

(Jerry Hamilton) Be aware of the options available given your skills and experience. Are you an Informix Database Administrator seeing demishing job opportunities? Maybe it would help to learn another database platform like DB2, Oracle or SQL Server. If you’re an Analyst, who has reviewed a lot of c

Greg Larsen continues his series on date/time data with a discussion on Searching for Particular Date Values and Ranges. Learn how to select records from a database table based on values in a DATETIME, or SMALLDATETIME column.

Article which shows you a simple way to save multiple versions of stored procedure texts.

By Itzik Ben-Gan – This article from SQL Server Magazine presents set-based solutions to identifying trends in sales data.

By Martin LaMonica – Microsoft gained ground on its database rivals in 2002, despite a decline in sales for the market as a whole, according to research published Wednesday by Gartner Dataquest. (R)