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 | … |