From SQLTeam.com – This article was submitted by Sujoy Paul. He writes “The plethora of mission critical databases in most companies has made it imperative to harness the valuable data by integrating across various database vendors and on different platforms. The seamless integration of the complexi

By Michael Otey – These connection-string examples illustrate the seven most common connection scenarios. (R, $)

by MAK [Muthusamy Anantha Kumar] – DBAs are always running out of hard disk space when handling large databases such as data-warehouse databases and other VLDB. Backing up such databases to disk occupies more disk space, since Microsoft SQL Server does not have compression built into the backup proc

By Alexander Chigrik – SQL Server ships with number of stored procedures, which can be used for managing the database and displaying information about databases and users. These stored procedures are called system stored procedures. The system stored procedure’s name started with the prefix sp_ to d

By Lisa Vaas – Microsoft Corp. plans to whet the appetite of small and midsize businesses for a major update of its SQL Server database—code-named Yukon—with a liberal helping of Yukon-ready applications.

I want to schedule a Microsoft Visual Basic® 6.0 executable (.exe) program by using the SQLAgentCMDExec account to create a job through SQL Server 7.0 Enterprise Manager. The .exe program should use universal naming convention (UNC) paths to create a file on a shared directory on the SQL Server 7.0

Microsoft has put a price tag of $599 on the Standard Edition of its Windows Small Business Server 2003 and at the same time has hiked the price of client access licenses for both upcoming 2003 editions of its small-business server software from $60 to $99.