dreamwinz's Profile - Middleton - Arkansas - sujith | OLX

sujith's photo

dreamwinz's Profile

  • Username: dreamwinz
  • First Name: sujith
  • Location: Middleton, Arkansas, United States

About Me:

SQLSERVER DBA ONLINE / CLASSROOM TRAINING FROM PROFESSIONAL DBAS
SQL SERVER DBA
Introduction
Welcome
Course Overview
SQL Server Basics
Getting Hands On
Microsoft SQL Certifications
SQL Server Editions

Installing SQL Server 2008
Hardware Requirements
SQL Server Instances
SQL Server Components
Collation Choices
Service Accounts
Creating Service Accounts
Installing SQL Server 2008
Upgrading SQL Server 2008
SQL Server Configuration Manager
SQL Server Authentication Modes
Changing Authentication Modes
SQL Server Management Studio

SQL Server 2008 Databases
File Types
Transaction Log
System Databases
File Placement
Creating a Database
Autogrowth
Database Options
Sizing the Transaction Log
Schemas
Default Schema
Creating a Schema
Moving Data Files
Installing Sample Databases

Maintaining SQL Server
Hiding System Objects
SQL Server Agent
Creating a Maintenance Plan
Understanding Operators
Understanding Jobs
Understanding Alerts

Server Management
SQL Server Options
Registering Servers
Server Configuration
Activity Monitor
Database Mail


Maintaining The Database
Maintaining the Database
Database Backup
Backup Compression
Backup Devices
Managing the Transaction Log
Restoring the Database

Monitoring & Troubleshooting
Dedicated Administrator Connection
SQL Profiler
Log File Viewer
Event Forwarding

Optimizing Performance
Using Filegroups
Partitions
Partition Planning
Database Tuning Advisor

High Availability
High Availability Options
Failover Clustering
Database Mirroring
Log Shipping


Regards
Ravi,
Dream Winz,
Padmavathi Plaza, 305, 306 & 307,
Kukatpalli.
Dream.winz@gmail.com
http://dream-winz.blogspot.com


Cell: 9640933444 / 9550419629 / 9502741758