by Doug Thews – Use the .NET Compact Framework and SQL Server CE 2.0 to give Windows CE and Pocket PC apps access to corporate databases.

This script is actually part of an article written about performing a simple password audit on SQL Server logins when you start to administor a new SQL Environment. The script will scan the sysxlogins table located in the master database for SQL Server logins with no passwords, passwords that are th

(Louis Duc Nguyen) Learn how to create a web page to extract data from a SQL Server database, with SORT and TOTAL functionality.

Get expert advice on distributing text files, Excel spreadsheets, and even Access databases via e-mail using xp_sendmail. It’s not as straightforward as it sounds.

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 Michael Otey – These connection-string examples illustrate the seven most common connection scenarios. (R, $)

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 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.

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.