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
|
