About this product: If specialization is for insects, those of us who have only two legs are bound to need reminders when we sit down to perform a specialized task. For those times in which the specialized task at hand involves the latest version of Microsoft's high-end database management system (DBMS), Microsoft SQL Server 2000 Administrator's Pocket Consultant will provide how-to answers on the double-quick. This small, inch-thick volume fits nicely into a briefcase, and opens flat for easy reference. It makes little attempt to explain how SQL Server works, assuming instead that the reader knows what he or she needs. For example, a quick scan of the index for "Logins, Assigning Roles for Multiple" yields a reference to a page that explains exactly what to do, step by step.
Procedures are a large part of the appeal of this book; value tables and Transact-SQL syntax documentation contribute the rest. A typical value table lists all standard database roles, along with commentary on what sort of user is appropriate for each role. Transact-SQL documentation includes generic "all available options" statements of syntax, followed by usage examples. Deeper explanations of what each option does would make the syntax documentation stronger, but what's here is certainly enough to jog readers' memories and point them to heavier reference material, if they need it. Keep this book handy if your job requires you to hop from DBMS to DBMS. --David Wall
Topics covered:
Installing and configuring Microsoft SQL Server 2000
About this product: Teach yourself how to use SQL Server 2000 Data Transformation Services (DTS) and begin writing your own data movement applications one step at a time. This practical, hands-on tutorial expertly guides you through the development of a DTS application that extracts and transforms data from a database into a data warehouse. Work at your own pace through the easy-to-follow lessons and hands-on exercises to master essential techniques. And accelerate your productivity by working with instructive code examples and best practices for SQL Server 2000 DTS.Discover how to: Create simple data movement packages with the DTS Import/Export Wizard Create a complex data movement application with the DTS Designer that configures pre-built DTS tasks Exploit the flexibility of the Data Driven Query (DDQ) task without sacrificing performance Incorporate execution logic, flow control, branching, transaction control, and parallel execution into DTS packages and tasks Dynamically configure DTS packages and tasks at run time Save DTS packages in SQL Server, Meta Data Services, Structured Storage, and Microsoft Visual Basic(r) file formats Extract and transform heterogeneous data using ActiveX(r) Scripts Integrate customized logging, error handling, and batch control into your application Deploy and operate a data movement application About DTS in SQL Server 2000 Microsoft SQL Server 2000 Data Transformation Services (DTS) provides a set of graphical tools and programmable objects to extract, transform, and consolidate data from disparate sources into single or multiple destinations. By using DTS tools, you can create custom data movement solutions to support decision-making, improve system performance, upgrade existing systems, and more.CD features: Practice files for all the book s procedures
About this product: Ensuring 24/7 database availability is crucial to your company’s success. Discover the best ways to help keep your critical, Microsoft SQL Server 2000–based systems up and running—and secure—with this in-depth guide, straight from the source.
About this product: Item #: Q36390. Continuous protection of SQL databases eliminates the daily backup window for SQL server and enables recovery of database transactions that have been made right up to the time of the hardware or software failure. Additionally, flexible recovery options allow IT administrators to restore SQL databases to destinations other than where they originated, directing a copy of the actual data streams being sent to media by a SQL database to a local directory for later use. The SQL Server 2005 snapshots are integrated into the Backup Exec catalog for a consolidated look at all data copies available for recovery in seconds. This agent provides SQL Server 7.0, SQL Server 2000, and SQL Server 2005 users with granular protection on 32- and 64-bit systems down to the individual database or file group.BASIC MAINTENANCE SERVICESEvery computing environment requires reliable technical support and timely version upgrades and content updates. Symantec Basic Maintenance is an ongoing investment in Symantec software technologies and customer's business. This package is designed to help keep non-essential systems current with the latest Symantec version upgrades and content updates. Product Description: Symantec Backup Exec for Windows Servers Agent for Microsoft SQL Server - ( v. 12 ) - complete package Category: Networking applications Subcategory: Network - network backup Version: 12 License Type: Complete package Bundled Support: 1 Year Basic Maintenance License Qty: 1 server License Pricing: Standard Licensing Program: Symantec Buying Programs : Business Pack Language(s): Multi Platform: Windows Distribution Media: CD-ROM Package Type: Retail OS Required: Microsoft Windows Server 2003, Microsoft Windows 2000 Server SP4, Microsoft Windows XP SP2, Microsoft Windows XP Professional x64 Edition, Microsoft Windows Small Business Server 2003 SP1, Microsoft Windows Small Business Server 2000 SP4, Microsoft Windows Storage Server 2003
About this product: Learn how to deliver exceptional performance and scalability to your business information systems - and prepare for MCP Exam 70-228 - with this official Microsoft study guide. Exam 70-228 is an elective for MCSE/MCSA certification and a core exam on the MCDBA track. Build your expertise installing, configuring, and troubleshooting SQL Server 2000 by working at your own pace through the books lessons and hands-on exercises. The second edition of this popular training kit now features a testing tool to measure what you know and where to focus your studies - before taking the actual exam. Topics include installing or upgrading to SQL Server 2000, configuring database options, automating data transfer and manipulation with Data Transformation Services (DTS) packages, using SQL Server replication services, managing security features, monitoring and fine-tuning system performance, and performing backups and restorations. You also get a CD-ROM loaded with practice exercises and an easy-search electronic version of the study guide.
About this product: A solid, dependable binder at a great value. This affordably priced general use binder resists fingerprints. Give your reference binder a sharper looking cover using our basic round ring binder. Round ring mechanism with open and close triggers for easy access to documents. Two inside pockets offer extra storage to hold loose papers.
About this product: Item #: T33654. This is a Special Order Item. Please allow up to 7 business days for product to ship. BakBone NetVault Microsoft SQL Server Workgroup module allows NetVault to back up a Microsoft SQL Server Workgroup database hosted on a Windows client.
BOOK
