access_time 6 years ago visibility688 comment 0 languageEnglish
more_vert

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 at 6 years ago * This page is subject to Site terms.

More from Kontext

visibility 14052
thumb_up 0
access_time 6 years ago

SQL Server Compact 4.0 (CE 4.0) is a free SQL Server embedded database ideal for building standalone and occasionally connected applications for mobile devices, desktops, Web clients and others. In one of my projects, I used it as the database for logging errors, which assumes the errors will onl...

open_in_new View open_in_new SQL Server

visibility 1165
thumb_up 0
access_time 6 years ago

Serial: An Introduction to SQL Server Features Case Scenario In the previous articles of this serial, I’ve introduced how to use SQL Server as database for online transaction proces...

open_in_new View open_in_new SQL Server

visibility 4339
thumb_up 1
access_time 6 years ago

Serial: An Introduction to SQL Server Features Case Scenario For this ETL project, the requirements are listed below: Sales data will be pushed to specified shared fold...

open_in_new View open_in_new SQL Server

Create Business Reports using SSRS

local_offer plot

visibility 877
thumb_up 0
access_time 6 years ago

Serial: An Introduction to SQL Server Features Case Scenario After the data is loaded into the database, reports can be built using SSRS (SQL Server Reporting Service). The g...

open_in_new View open_in_new SQL Server

info About author

Dark theme mode

Dark theme mode is available on Kontext.

Learn more arrow_forward

Kontext Column

Created for everyone to publish data, programming and cloud related articles. Follow three steps to create your columns.


Learn more arrow_forward