Krislyn
Home

Learning
Unix.com

Learning
Oracle.com

Learning
Java.net

Learning
C.net

Learning
VB.net

Learning
SAP.com


Free
Computer
Publications


eTechZone
Exam
Blaster

Subversion
hosting and
on-demand
source code
management

LearningSQLServer.com logo

Application Developers
Database Administrators | Certification Exam Guides

Database Administrators

Microsoft SQL Server 2005: Changing the Paradigm
By: Robert Beatty
Will prepare database administrators for upcoming changes in SQL Server 2005. Obtain the skills necessary to run SQL Server 2005 from the experts at Microsoft Gold Partner. Get a head-start to understanding the new concepts and features of SQL Server 2005 from the database administrator's perspective, including:
  • SQL Server 2005 Architecture
  • Tool Sets
  • Scalability, Reliability and High Availability Chapter
  • Performance Tuning
  • Replication
  • .NET CLR Integration
  • DTS and Business Intelligence

SQL Server 2000 for Experienced DBAs
By: Brian Knight
Configure and manage SQL Server 2000 for peak performance and high availability using the undocumented administrative and troubleshooting techniques offered inside this focused reference. SQL Server expert Brian Knight gives you details on system and platform architecture, settings, security, file management, replication, automation, backups, clustering, and restoration. The book also explains how to maximize built-in administrative tools, develop maintenance plans to prevent downtime, and optimize overall system performance. Concise and practical, this essential resource will save you hundreds of hours of troubleshooting time.

Essential Skills for Database Professionals

  • Manage SQL Server using best practices
  • Implement security measures and enable C2-level auditing
  • Automate tasks using T-SQL stored procedures, Query Analyzer, and Multi Server Administration
  • Monitor SQL Server by setting trace flags, creating alerts, enabling the black box, and more
  • Plan for disaster recovery by using full, differential, and transaction log backups
  • Replicate SQL Server data
  • Scale SQL Server using linked servers, distributed partition views, and indexed views
  • Prevent downtime with failover clustering and other high availability solutions
  • Optimize Windows 2000 networks for SQL Server

SQL Server 7 Backup and Recovery
By: Anil Desai
Provides real-world information for database administrators to develop, manage, plan and implement a data protection solution. Coves advanced tools and technologies for increasing uptime and performance, including clustering, replication, stand-by servers and advanced backup and recovery. Also reviews related information in data protection, security and performance on Windows NT4 and 2000.

SQL Server 7 24seven
By: Rick Sawtell (Editor), Michael Lee, Matt Bridges, Victor Isakov
Advanced guide to SQL Server 7. Written for administrators who already have experience with SQL Server, this book provides high-end information on crucial SQL Server topics: designing and implementing database systems on SQL Server; migrating to SQL Server 7 from earlier versions of SQL Server and other databases; troubleshooting problems; and optimizing the database for performance and reliability.

SQL Server 7: Administration Guide
By: Mark A. Linsenbardt, M. Shane Stigler
Provides lots of background wisdom, plus xscores of quick-and-dirty solutions to database-administration challenges (both common and somewhat rare). For example, they explain how to use the Transact-SQL statements TRUNCATE_ONLY and NO_LOG to free up disk space for a database that's growing faster than planned -- this procedure often will buy enough time to install more disk space.

Microsoft SQL Server 7 DBA Survival Guide
By: Mark Spenik (Editor), Orryn Sledge (Contributor), Laura Herb (Contributor)
Organized into several parts that compromise the various jobs and tasks the DBA performs, this book focuses on learing the SQL Server environment and managing it in the real world. The CD-ROM includes checklists and two custom products, the DBA Assistant and the Estimator, that simplify SQL Server administration.

Data Warehousing With Microsoft Sql Server 7.0 Technical Reference
By: Jake Sturm
Primarily a reference to Multidimensional Extensions (MDX) and ActiveX Data Objects Multidimensional (ADO MD), this book includes tons of information about the Microsoft way of collecting and managing large quantities of data, looking at complex relationships among the bits of information, and deriving significant business-related meaning from them.


Google

© 2000-2008, Krislyn Corporation. All rights reserved. All trademarks are owned by the respective company or Krislyn Corporation.