The Microsoft BizTalk Server 2004 Configuration Framework Wizard changes the Parallelism setting for the instance of Microsoft SQL Server 2000 that houses the BizTalk Server 2004 databases. This behavior occurs if this instance of SQL Server has multiple processors available. By default, Use all ava

(Brad M. McGehee) What do you see as the major trends affecting the SQL Server market? Here are Simon’s thoughts on what’s coming up for SQL Server.

(Marcin Policht) One of the SQL Server 2005 Beta 2 features that has undergone considerable architectural, functional, and interface changes, compared with its earlier versions, deals with extraction, transformation, and loading (also known as simply ETL) of data. (In other words, allowing you to mo

(Don Kiely) It’s an increasingly hostile world for your databases and client applications. Every day, attackers develop clever new attacks to compromise your valuable data. Fortunately, SQL Server 2005 offers strong new security features that directly address principles such as defense in depth and

When you try to install Microsoft SQL Server 2000 hotfix build 8.00.977, the installation may fail and the following messages are written to the Replsys.out file: [DBNETLIB]Specified SQL server not found. [DBNETLIB]ConnectionOpen (Connect()).

(Robert Dorr) This articles explores how the reporting tool in SQL Server 2000 Service Pack 4 significantly reduces the time it takes to identify and determine the underlying causes of stalled and stuck I/O operations.

(Jennifer Lawinski) Database developers working with SQL Server 2000 or the soon-to-be-released Yukon might find a useful tool in Microsoft’s recently released Visual FoxPro 9.0 database and desktop FoxPro now supports a lot of the SQL data types that it didn’t support before. (R)

(Douglas Reilly) Hilary Cotter is the first Database Geek of the Week who lives in my neck of the woods, in Central N.J. I met him at one of the user group-related events—a dinner gathering of geeks, as I recall—and was recently reacquainted with him when he spoke in the class just before mine at th

(Ashvini Sharma) The Data Flow task (internally and in the object model also called the ‘Pipeline’) logs some pretty interesting information that describe the internal scheduler.

In Microsoft SQL Server 2000, you may receive error message 701, error message 802, and error message 17803 when many hashed buffers are available. These error messages are out-of-memory errors. Typically, this problem occurs on computers that are based on the 64-bit architecture that have a larger