SQL Server Functionality

Posted on by
Functionality

SQL Server 6.5

SQL Server 7.0

SQL Server 2000

SQL Server 2005

SQL Server 2008

SQL Server 2008 R2
Backup/Recovery

Yes

Yes

Yes

Yes

Yes

Yes
Batch processing

Yes

Yes

Yes

Yes

Yes

Yes
BCP/Export/Import

Yes

Yes

Yes

Yes

Yes

Yes
Capacity planning

Yes

Yes

Yes

Yes

Yes

Yes
Clustering and redundancy design

Yes

Yes

Yes

Yes

Yes

Yes
Daily maintenance

Yes

Yes

Yes

Yes

Yes

Yes
Database maintenance plans, scheduling, alerts

Yes

Yes

Yes

Yes

Yes

Yes
DCL/DDL/DML

Yes

Yes

Yes

Yes

Yes

Yes
Devices, databases and logs – design, creation,
and updating

Yes

Yes

Yes

Yes

Yes

Yes
Disaster Recovery

Yes

Yes

Yes

Yes

Yes

Yes
Documentation – policies and procedures

Yes

Yes

Yes

Yes

Yes

Yes
DTS (Data Transformation Services)

Yes

Yes

Yes

——

——

——
Hardware/RAID

Yes

Yes

Yes

Yes

Yes

Yes
Indexing, index statistics updating and index
optimization

Yes

Yes

Yes

Yes

Yes

Yes
Install/Configure/Upgrade

Yes

Yes

Yes

Yes

Yes

Yes
Load balancing

Yes

Yes

Yes

Yes

Yes

Yes
Logical design (schema)

Yes

Yes

Yes

Yes

Yes

Yes
Migration

Yes

Yes

Yes

Yes

Yes

Yes
Monitoring, including DBCC (Database Consistency
Checking)

Yes

Yes

Yes

Yes

Yes

Yes
Network/OS

NT

NT, Win 2000

NT, Win 2000

Win

Win

Win
OLAP Services (pre-SSAS) Yes

Yes

——

——

——

——
OLAP (Data warehousing)

Yes

Yes

Yes

Yes

Yes

Yes
OLTP

Yes

Yes

Yes

Yes

Yes

Yes
Performance Tuning (Optimization)

Yes

Yes

Yes

Yes

Yes

Yes
Physical design

Yes

Yes

Yes

Yes

Yes

Yes
Query Optimization

Yes

Yes

Yes

Yes

Yes

Yes
Replication

Yes

Yes

Yes

Yes

Yes

Yes
Security (User) administration

Yes

Yes

Yes

Yes

Yes

Yes
SQL (T-SQL)

Yes

Yes

Yes

Yes

Yes

Yes
SQL Server end of architecture (2-tier, 2½-tier,
3-tier & other n-tier)

Yes

Yes

Yes

Yes

Yes

Yes
SQL Server end of ecommerce solutions

Yes

Yes

Yes

Yes

Yes

Yes
SQL Server vendor relations

Yes

Yes

Yes

Yes

Yes

Yes
SSAS —— —— Yes Yes Yes Yes
SSIS —— —— —— Yes Yes Yes
SSRS —— —— Yes Yes Yes Yes
Stored procedures, triggers, constraints, views

Yes

Yes

Yes

Yes

Yes

Yes
Tables, fields (columns), records (rows) –
creation and updating

Yes

Yes

Yes

Yes

Yes

Yes
Troubleshooting

Yes

Yes

Yes

Yes

Yes

Yes