IBM Computer, Laptops and Servers

Errata Description Chapter (PDF) Table of Contents (PDF) Index (PDF) Author Information Complete. Authoritative. Practical. The only SQL Server book you need. Mastering SQL Server 2000 is the one indispensable resource for anyone working with the latest version of SQL Server. Whether you build or administer SQL Server databases or write applications that communicate with them, you'll find the background knowledge and the practical instruction you need to accomplish any task, from the most basic to the most advanced.

Create an unlimited number of Microsoft SQL Server 2000 (MSDE) databases, access direct from your web site application or remotely via Enterprise Manager or ODBC compatible software. Full 'sa' access permitting any level of customisation. Access database are also supported. close window × reg.co.uk

: In IT parlance, this is a set or group of}macros}in a Word document or Excel spreadsheet, etc. DOS (Disk Operating System): This}operating system, which predates Windows, involves the writing of commands for all operations that the user wants to carry out. MSDE (Microsoft Desktop Engine): A}server}for storing data, which is compatible with SQL Server 2000.

Candidates who want to become an MCDBA must take a total of 4 exams. One exam covers administering SQL Server (either version 7 or 2000), one exam covers how to design a SQL Server database architecture, one exam covers administering Microsoft Server. The last exam must be taken from a list of electives. For rmation on the exams and requirements, click on the Exam Chart and Sybex Products link.

Get all the benefits of Microsoft SQL Server 7 with none of the headaches. in wizards, the Enterprise Manager, and the Query Analyzer. use stored procedures, save time by automating common tasks with Jobs and Alerts, import and export data to and from an SQL Server database, and keep your data secure and backed up with the tips, tricks, and techniques you'll discover inside Microsoft SQL Server 7 For Dummies. have SQL Server tools, too, including programs for automatically building multitier applications, creating SQL Server objects, friendly Visual Basic code.