Advantages
- Support for large amounts of data
- Reliability against data loss
- Full support for relational databases
Disadvantages
- Large installation footprint
- Requires more powerful hardware
Components
- Data Storage Engine
- Data Retrieval Engine
- Transaction Broker
- Reporting Services
- Full Text Search Service
Development tools
- SQL Server Management Studio
- Microsoft Visual Studio