(James Crowley) As a developer, I find that an incredible amount of my time is spent dealing with databases in some form or another – be it displaying, manipulating or analyzing data; creating client or server applications. The advent of the .NET Framework has brought with it some major changes, and

This chapter teaches you how to increase the availability of a Microsoft SQL Server data center by implementing transactional replication. After reading this chapter, you will be able to configure each component in this high-availability solution. To configure transactional replication using Network

(Baya Pavliashvili) A batch is one or multiple T-SQL statements executed by SQL Server as a single unit. Batches are separated by a GO statement, which marks the end of one batch and beginning of another. This command must appear on a separate line from all other commands. (R)

(Steven Warren) Prior to SQL Server 2000, the only way to back up or export databases from SQL Server to other databases was to use the bulk copy program. We all spent hours configuring scripts to do miraculous things using this cumbersome method. Then, when we finally mastered the art, SQL 7.0 was

This chapter covers Microsoft-specified objectives for the Indexing section of the Database Development SQL Server 2000 exam. (R, pdf)

In a clustered environment, when you change a protocol parameter for a clustered instance of Microsoft SQL Server 2000 or of Microsoft SQL Server 2005 to a value that is not valid, the SQL Server service cannot start. Additionally, you cannot change the protocol parameter back to the original value.

(Dina Fleet Berry) With the use of the Internet as its own user interface, data enters the database via a number of ways: windows application, web application, and web service. It is no longer safe to put the business rules at the application level or expect the rules at the level to be implemented

(Vidya Vrat Agarwal) Microsoft SQL Server 2005 (code named “Yukon”) extends the performance, reliability, availability, programmability, and ease of use of SQL Server 2000. SQL Server 2005 includes several new features that make it an excellent database platform. It also includes many enhancements a

(Jeremy Kadlec) Business and IT teams alike are demanding high-speed SQL Server 2005 installations right out of the gate. Getting the DMBS up and running is not usually the greatest challenge; it’s ensuring that the platform performs as expected. This is no small task when you already have little ti

When you use the Volume Shadow Copy Service (VSS) to back up Microsoft SQL Server 2000 database files or Microsoft SQL Server 2000 Desktop Engine (MSDE) database files, you may receive the following error message: Volume shadow copy creation: Attempt 1. “MSDEWriter” has reported an error 0x8004