access_time 8 years ago languageEnglish
more_vert

An Introduction to SQL Server Features

visibility 709 comment 0

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.
Like this article?
Share on

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

Follow Kontext

Get our latest updates on LinkedIn.

Want to contribute on Kontext to help others?

Learn more

More from Kontext

visibility 405
thumb_up 0
access_time 8 years ago
visibility 1347
thumb_up 0
access_time 8 years ago