Software : Microsoft : SQL Server

Microsoft SQL Server

(as of 4/12/2016)

Software Overview

Main Features

  • In-Memory OLTP capabilities for quick transactional speed and throughput of your application
  • Encrypted backup of your data, whether it is on-premise or on Microsoft Azure
  • Deployment wizard for deploying on-premise SQL Server databases to Microsoft Azure

Microsoft SQL Server is a relational database application for the Windows platform. The application is primarily used to store and retrieve data, whether it be from software applications on the same computer or across a network.

SQL Server provides a set of tools that enable you to build, deploy, and manage databases, whether you are on-premise or on Microsoft's Azure cloud platform. The software features column-based data storage and query processing for storing and managing data, which works especially well for data warehousing workloads. SQL Server's core provides in-memory online transaction processing (OLTP) capabilities for quick transactional speeds and throughput. Also, SQL Server gives you peace of mind, as it supports encryption for database backups regardless of if they take place on-premise or through Microsoft Azure.

SQL Server is available in a variety of editions that are geared towards different audiences, however, the industry-standard software is mainly used by businesses. The application provides first-rate tools that allow you to build, deploy, and manage databases, which makes Microsoft SQL Server a great choice for your business.

▶ Primary file extension

.MDF – SQL Server Database File

▶ Other file extensions used by Microsoft SQL Server 2014

Supported File Types
.ABFAnalysis Services Backup File
.BAKBackup File
.CKPSQL Server Checkpoint File
.CUBAnalysis Services Cube File
.DACPACSQL Server Data Tier Application Package
.DBMLVisual Studio OR Design File
.DTSCONFIGSSIS Package Configuration File
.DTSXDTS Settings File
.LDFSQL Server Transaction Log File
.NDFSQL Server Secondary Database File
.QRYQuery File
.SDFSQL Server Compact Database File
.SQRSQL Program File
.TRCSQL Server Trace File
.TRNSQL Server Transaction Log Backup File
.WRKSQL Server Log Shipping File

Updated: April 12, 2016