SQL Server provides a batch of great features to build robust, high-performance and scalable data solutions.
It supports on-line transaction processing (OLTP), data integration, namely extract, transform and load, reporting and on-line analytical processing (OLAP). In this serial, I will introduce them using simple daily samples.
* Some features are only available in SQL Server 2012 or later versions (SQL Server 2014).
Sample 1, Build Online Product Management Website using MVC 3 + Entity Framework + SQL Server
Link: Build Online Product Management Website using MVC 3 + Entity Framework + SQL Server
Sample 2, Create ETL Project for Collecting Sales Data using SSIS
Link: Create ETL Project for Collecting Sales Data using SSIS
Sample 3, Create Business Reports using SSRS
Link: Create Business Reports using SSRS
Sample 4, Create OLAP Project using SSAS
Link: Create OLAP Project using SSAS
Others
There are also a lot of other functions to meet your various requirements about data management for different situations.
| Requirements | Implementations |
| Failover and Availability | Database Mirroring(High Performance and High Safety)/AlwaysOn High Availability |
| Data Synchronization | Replication (Transactional/Merge/Snapshot) |
| Auditing | Audits, Server Audit Specification |
| Policy Management | Policies, Conditions, Facets |
| Data Backup and Restore | Backup/Restore |
| Distributed Communication | SQL Server Service Broker |
| Management and Tuning | DMF, DMV, Data Collection, Resource Governor, SQL Server Profiler/Extended Events, Execution Plan, Tuning Advisor |
| Mailing | Database Mail |
| Tools | SSMS, Data Tool, Configuration Manager, Master Data Service Manager, Power Shell... |
| Web Services | Endpoints |
| Others | … |
