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
|