Scribd
Upload
26 views4 pages

SQL Server Capacity Planning Guide

This document provides an overview of SQL Server and discusses topics related to its installation, configuration, administration, security, backup and recovery, performance monitoring and tuning, data transfer, high availability, and replication. It also covers the fundamentals of designing reports in Crystal Reports, including selecting and organizing data, formatting reports, creating formulas, building parameterized and template-based reports, and using cross-tabs to summarize data. The document outlines 72 topics on SQL Server and 12 topics on Crystal Reports design.

Uploaded by

Sreedhar Sree
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
26 views4 pages

SQL Server Capacity Planning Guide

This document provides an overview of SQL Server and discusses topics related to its installation, configuration, administration, security, backup and recovery, performance monitoring and tuning, data transfer, high availability, and replication. It also covers the fundamentals of designing reports in Crystal Reports, including selecting and organizing data, formatting reports, creating formulas, building parameterized and template-based reports, and using cross-tabs to summarize data. The document outlines 72 topics on SQL Server and 12 topics on Crystal Reports design.

Uploaded by

Sreedhar Sree
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd

SQL SERVER OVERVIEW

1. WHAT IS SQL SERVER 2. SQL SERVER INTEGRATION 3. SQL SERVER DATABASES 4. SQL SERVER SECURITY 5. WORKING WITH SQL SERVER 6. PLANNING TI INSTALL SQL SERVER 7. HARDWARE INSTALLATION CONSIDERATIONS 8. SQL SERVER 2000 EDITIONS 9. SOFTWARE INSTALLATION CONSIDERATIONS [Link] OF INSTALLING SQL SERVER [Link] THE INSTALLATION [Link] SQL SERVER ENTERPRISE MANAGER [Link] [Link] DATABASE FILES [Link] TO DATA STRUCTURES [Link] DATABASES [Link] DATABASES [Link] DATABASES FILES AND LOGS [Link] THE DATABASE USING HARDWARE-BASED RAID [Link] THE DATABASE USING FILEGROUPS [Link] THE DATABASE USING FILEGROUPS WITH HARDWARE-BASED RAID [Link] PLANNING

[Link] CONSIDERATIONS [Link] SECURITY [Link] AN AUTHENTICATION MODE [Link] LOGINS TO USERS AND ROLES [Link] PERMISSIONS TO USERS AND ROLES [Link] SECURITY WITHIN SQL SERVER [Link] APPLICATION SECURITY [Link] SQL SERVER SECURITY IN THE ENTERPRISE [Link] ADMINISTRATIVE TASKS [Link] TASKS [Link] SQL SERVER ADMINISTRATIVE TASKS [Link] ROUTINE MAINTENANCE TASKS [Link] ALERTS [Link] SQL SERVER AUTOMATION [Link] MULTISERVER JOBS [Link] UP DATABASES [Link] DATA LOSS [Link] AND CHANGING A DATABASES RECOVERY MODEL [Link] SERVER BACKUP [Link] TO BACKUP DATABASES [Link] BACKUPS [Link] OF BACKUP METHODS [Link] A BACKUP SECURITY [Link] CONSIDERATIONS [Link] DATABASES [Link] SERVER RECOVERY PROCESS

[Link] TO RESTORE A DATABASE [Link] BACKUPS [Link] DATABASES FROM DIFFERENT BACKUP TYPES [Link] DAMAGED SYSTEM DATABASES [Link] SQL SER VER FOR PERFORMANCE [Link] TO MONITOR SQL SERVER [Link] MONITORING AND TUNING [Link] FOR MONITORING SQL SERVER [Link] MONITORING AND TUNING TASKS [Link] DATA [Link] TO TRANSFERRING DATA [Link] FOR IMPORTING AND EXPORTING DATA IN SQL SERVER [Link] TO DTS [Link] DATA WITH DTS [Link] HIGH AVAILABILITY [Link] TO AVAILABILITY [Link] AVAILABILITY USING FAILOVER CLUSTERING [Link] SERVERS AND LOG SHIPPING [Link] REPLICATION [Link] TO DITRIBUTED DATA [Link] TO SQL SERVER REPLICATION [Link] SERVER REPLICATION AGENTS [Link] SERVER REPLICATION TYPES [Link] REPLICATION MODELS

CRYSTAL REPORT DEVELOPMENT

Crystal Reports Design: - Fundamentals of Report Design 1. Planning a Report and developing a report prototype, creating a Report, Organizing Data on a Report, Formatting a Report, Conditional Reporting 2. Selecting Records, Sorting, Grouping record 3. Creating Basic Formulas (Defining formulas, Creating formulas and Applying them Crystal Reports Design: -Business Reporting Solutions 1. Report Creation Review, Managing Reports, Publishing reports to BO Enterprise, Using Variables and Arrays, Building Parameterized Reports, Using Report Templates, Using Report Sections 2. Summarizing Data with Cross-Tabs

You might also like