languageEnglish

An Introduction to SQL Server Features

visibility 727 comment 0 access_time 8 years ago

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

info Last modified by Raymond 8 years ago copyright This page is subject to Site terms.

Subscribe newsletter

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

More from Kontext

visibility 1562
thumb_up 0
access_time 2 years ago
visibility 1072
thumb_up 0
access_time 7 years ago
visibility 436
thumb_up 0
access_time 7 years ago