By Matt Harper – Here is a simple SQL Server stored procedure that zips files from a source and destination directory that you pass when calling the procedure. It uses the DOS-based wzzip.exe to zip files specified into a zip file named the current date and time, e.g., 200303030809.zip.

This article deals with one specific type of performance issue that applications may experience with Microsoft SQL Server — slow performance of a large number of concurrent ad hoc queries.

by Roger Jennings – Replace disconnected recordsets with XML updategrams for secure Internet and wireless transactions.

By Paul Krill – The SmartDBA tools have a single look and feel across different platforms, thus eliminating the need to employ experts for each database, according to BMC.

A lot of people are confused about the differences between MSDE 2000 and SQL Server 2000, especially about how MSDE differs from SQL Server 2000 Personal Edition. Michael Otey counts seven important ways that MSDE differs from SQL Server 2000.

Many people don’t realize that a new version of SQL Server 2000 Books Online (BOL) ships with SP3. Here Brian Moran talks about some of the crucial changes that the updates in BOL include.

Get a first look at major feature enhancements currently in development for the next version of SQL Server, code-named “Yukon.”

See cube design techniques used to solve useful business questions and a performance study of Distinct Counts using Microsoft Analysis Services 2000 and a Unisys ES7000 server.

(Eli Leiba) The following procedure gets a tablename, column and integer (N) as parameters and finds the Nth largest value of a column in a specific table. For example, running it with “products,” “UnitPrice,” and “13,” retrieves the 13th largest value of the UnitPrice column from the products table

by Randy Dyess – Tracking stored procedure versions is not easy with SQL Server. In this article, learn how the author wrote his own SP versioning system.