By Brian Kotek – One of the most immediate and powerful benefits of using ColdFusion is that you can use variables in your Web pages. You reference ColdFusion variables using the format #VariableScope.Variable.Name#. Although a scope is not required for many variables, it is highly recommended so th

Book by Rick Dobson – Learn how to develop multiuser databases—and extend your solutions to SQL Server™ and the Web—with code and instruction from an Access 2002 expert. Whether you’re extending an existing database or developing a sophisticated custom solution, this detailed developer’s guid

OmniAudit allows you to automatically and transparently track changes to any column of any table in your Microsoft SQL Server 7.0 or 2000 databases. Not only capture before and after values for each changed column, but also identify the user making the change, the date and time th

By Erich Luening and David Becker – The Microsoft Network Security Hotfix Checker, or Hfnetchk tool, made available on Wednesday, allows business users of the company's software to assess the status of security patches for the Windows NT 4.0 and Windows 2000 operating systems, as well as fixes f

by Mary V. Hooke – In this article, I'll discuss some of the things you can do to improve your SQL Server database's performance. I'll focus on SQL Server 2000's ability to create indexes on views, as well as how to configure your indexes properly using the Index Tuning Wizard (ITW).

How can I configure SQL Server merge replication to work in only one direction?By default, with merge replication you pass data in both directions: changes at a publisher are sent to a subscriber, and changes at a subscriber are sent back to a publisher. In some cases, you might want to use

By Jeffrey Burt – Microsoft Corp. today released the second demo of an XML query tool. Eventually, XQuery will be incorporated throughout Microsoft's products, from its SQL Server database tools to the company's .Net frameworks, said Mark Fussell, lead program manager for XML technolo

Learn about the many features of SQL Server 2000 Desktop Engine (MSDE 2000), a data engine built and based on core SQL Server technology. The common technology base shared between SQL Server and MSDE 2000 enables developers to build applications that can easily scale seamlessly from laptops to multi

By Andrew Starling – Although Macromedia Dreamweaver UltraDev can take you a long way with ASP, if you want to use advanced SQL in your Select statements you'll need to write it yourself. Here are some real- world examples including Iif and Case expressions. And since hand-coding inevitably lead

Designed to simplify the Web application building process, WebApp Studio is equipped with easy-to-use Internet development tools and wizards that automatically generate HTML, WML, and server side scripts. WebApp Server utilizes n-tier architecture and makes creating applications that run in Web brow