An Introduction to SQL Server Features

417 views 0 comments posted at about 4 years ago Raymond

SQL Server provides a batch of great features to build robust, high-performance and scalable data solutions.

image

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

Add comment

Comments (0)

No comments yet.
In this Page