Sno SQL SERVER DBA ROLES & RESPONSIBILITIES:
1 SQL Server History, Versions, Editions, Installations
2 DB Architecture, Recovery Models, Backups & Restorations.
3 SQL SERVER SECURITY ( Windows, SQL & DB Level).
Automation of Administrative Jobs, DB Mail,
4
Maintenance Plans, Operators, Proxy, Credentials, Alerts.
5 High Availability Concepts.
6 SQL Server Patching (Stand Alone, SQL Clustered, SQL AlwaysOn)
7 Disaster Recovery Process
8 PERFORMANCE TUNING.--windows, sql server, db level, coding level
9 Monitoring & Troubleshooting SQL Server Issue.
10 SQL Server HealthChecks, Migrations & Up gradations.
11 SQL Server Environments Details, Ticketing Tools, Monitoring Tools.
12 Ticketing Tool:
13 Environmental Details:
Development
IT
Environments
Windows = SQL Server
SQL Server 2012
Sub-Topics
GUI -- Stand Alone
Un-attended
Post Installation--Pending
Clustered ( 2 windows -- 1 min sql server)
Log Shipping --2000
DB Mirroring----2005
Replication---2000
Clustering (Windows+SQL Server)---2000
AlwaysON(2012)---2012
Windows, SQL Server, DB Level
Incidents, Change Orders, SLA.
Development, Pre-production/PPE/Stage,
Testing & Production.
ROLE
Developer
1. Creates tables, Stored Procedure
Functions, Cursors, triggers, etc
BA
Developers
Testers
Application Team
DBA Team
Developers
Prod DBA
DBMS
RDBMS
Oracle DBA
SQL Server DBA
mysql
Windows
Production
Pre-production/Staging/PPE
Development
Testing
SQL Server 2000
SQL Server 2005
SQL Server 2008/2008 R2
Edition
Enterprise Edition
Standard Edition
Developer Edition
Expression Edition--Free
SQL Server Installations
Windows Server 2000----2016 --Guest
vmware 12.0
win 7 64 bit -- host OS
SQL Server Installations 2000
SQL Server 2005 till 2016
Estimated Days
Normal Uses Enterprise Purpose
win nt Windows Servers OS
win xp 2000
wind 7 2003
win 8 2008
win 10 2012
2016
DBA
Dev Box
Prod Box
sybase
ms sql server
oracle
mysql
50 +
Higher Paid Employees CMD
little bit high bit paid GUI
SQL Server
Production
Pre-production/Staging/PPE
Development
Testing
Version Environments
2000 till 2016 (32 bit , 64 bit) Production
2000 till 2016 (32 bit , 64 bit) Production
2000 till 2016 (32 bit , 64 bit) Dev/Testing
Windo4)ws server 2008(32 bit)
SQL Server 2008 64 bit
16 times ( default , 15 named instances)
50 times (default, 49 named instances
SQL Server Version Technical Details
1
4
6
7
SQL Server 2000 8
SQL Server 2005 9
SQL Server 2008 10
SQL Server 2008 R2 10.5
SQL Server 2012 11
SQL Server 2014 12
SQL Server 2016 13
GUI
SQL Server/DBA/MSBI MySQL
Development ( Front / Backend) Development
Application Supp Application Supp
DBA DBA
Front End --.net & BIDS
Backend---SQL Server
MSBI
3-Mar SQL Server Installation 2000
SQL DB Engine
SQL Server Agent
SQL Browser
Windows server 2012--64
Windows server 2012--32
Sufficient Drives
RAM
SQL Server Service Acco
1 SQL Server Version to be
2 Location of Setup files
3 Drives Details-Best pract
4 Service Accounts
1st Time--SQL Installatio
SQL 2000
SQL Server 2000
SQL Server 2005 Above
MongoDB Sybase Oracle
Development Development Development
Application Supp Application Supp Application Supp
DBA DBA DBA
DB, logins, SP, Functions, Triggers
Jobs
SQL Server 32 or 64
SQL Server 32 bit only. No 64 bit
C os
D SQL Binary Files
E Data Files
L Log Files
H Backups
T Temdb
X Reserved
1 GB
SQL DB Engine
SQL Agent Service
SQLServiceAcc@xyz.com
xyz\sqlserviceAcc
2000
I'll copy the files
C, D---Use only those 2 drives
I'll give it
Default Installation----windows server
16 1---Default--Name: Windows Server
2,3,4,.15---Named instances
50 1
49--named instances
Enterprise Manager SQL Query Analyzer
SQL Server Managem New Query
Windows 7
VMWare
Windows 2012 Server
SQL Server
SQLIndia
SQLHyd
SQLDelhi
64 bit
12 Free 64
Evaluation Datacenter Edition 64
2016 Free Evaluation 64
SQLServiceAcc
