Obtain the SQL Server 2000 trial software*—and explore how to build the next generation of scalable Web applications. As a part of the Microsoft .NET Enterprise Servers, SQL Server 2000 offers you scalability for the most demanding environments. SQL Server 2000 dramatically reduces your time to brin

A trigger is a database object that is attached to a table. In many aspects it is similar to a stored procedure. As a matter of fact, triggers are often referred to as a "special kind of stored procedure." The main difference between a trigger and a stored procedure is that the former is att

If you work with either Microsoft SQL Server™ 7.0 or 2000 , we think we can make a difference to your development timescales. Our SSCodeGen software quickly generates code from your database definitions. It is intended to be a no frills, developers toolbox, providing a quick, easy to understand mean

Here is a list of Performance Tuning Tips for Creating Visual Basic Applications Using SQL Server.

By Brian Knight – Since its introduction in SQL Server 7.0, Data Transformation Services (DTS) has helped many SQL Server professionals migrate data from OLE DB-compliant data sources to any compliant destination. But in SQL Server 2000, DTS has really grown up. If you've used DTS in SQL Server

If you are running SQL Server 6.5, don't make the most common mistake made by DBAs, and that is to accept the default Memory setting, which is either 8MB or 16MB, depending on how much RAM the physical server has. This number tells SQL Server how much RAM is can use out of the available RAM on N

by Brad M. McGehee – If you have read many of the articles I have written on this website, you will have learned in the past that I have used SQL Server log shipping as the main way to help ensure high availability of my company's SQL Servers. While log shipping has many benefits, there are seve

Richard Waymire tells readers how to append extra characters to a fixed-character column, how to troubleshoot fluctuations in backup tape speed, and more.

By Wylie Wong Staff Writer, CNET News.com<br> Microsoft filled a hole in its software portfolio Monday by acquiring NCompass Labs, maker of software that manages Web content, for about $36 million.<br> <br> Microsoft plans to sell NCompass software as a stand-alone product as part of its famil

Microsoft plans to reveal more specifics about the Microsoft Operations Manager at NetWorld Interop in Las Vegas May 7. Cliff Reeves, Microsoft's new vice president of marketing, Windows.Net Server Product Management Group, will talk about the next steps in Microsoft's management strategy