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
|
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.
|
© 2000-2008, Krislyn Corporation. All rights reserved.
All trademarks are owned by the respective company or Krislyn Corporation.
|