MICROSOFT® SQL SERVER™ 2000 ADMINISTRATOR’S POCKET CONSULTANT is the ideal concise, immediate reference you’ll want with you at all times as you deal with the details of Microsoft SQL Server 2000 database administration. Whether you handle administration for 50 users or 5000, this hands-on, fast-answers guide focuses on what you need to do to get the job done quickly.
With extensive easy-to-read tables, lists, and step-by-step instructions, it’s the portable, readable guide that will consistently save you time and minimize system downtime by giving you the right information right now.
This hands-on guide gives you the fast answers you need to:
- Grasp the fundamentals. Understand the SQL Server 2000 architecture; learn administration tools, techniques, and concepts; and discover how to modify configuration settings to optimize memory usage, take advantage of parallel processors, and more.
- Complete core tasks. Perform basic tasks to create and manage databases, servers, and server groups; and create logons, configure logon permissions, assign roles, and conduct other essential security measures.
- Administer databases. Manage tables, indexes, and views; query and manipulate data; import and export data; and integrate SQL Server data with other data sources.
- Control distributed data. Administer linked servers and distributed transactions, configure data merging and replication, and supervise data publication and subscription.
- Optimize and maintain databases. Profile and monitor SQL Server, conduct data backup and recovery, and take charge of automation and maintenance.
William R. Stanek has 20 years of hands-on experience with advanced programming and development. He is a leading technology expert and an award-winning author. Over the years, his practical advice has helped millions of programmers, developers and network engineers all over the world. He has written more than two dozen computer books. Current or forthcoming books include Microsoft Windows® XP Professional Administrator's Pocket Consultant, Microsoft Windows 2000 Administrator's Pocket Consultant, Second Edition, and Microsoft Windows Server™ 2003 and IIS 6.0 Administrator's Pocket Consultant.