Microsoft SQL Server
Version | 2019(as of 9/1/2020) |
Platform | Windows |
License | Commercial |
Category | Productivity |
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
Software Overview
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 Type
.MDFSQL Server DatabaseSupported File Types
Extension | File Type |
---|---|
.MDF | SQL Server Database |
.ABF | Analysis Services Backup File |
.BAK | Microsoft SQL Server Database Backup |
.CKP | SQL Server Checkpoint File |
.CUB | Analysis Services Cube File |
.DACPAC | SQL Server Data Tier Application Package |
.DBML | Visual Studio OR Design File |
.DTSCONFIG | SSIS Package Configuration File |
.DTSX | DTS Settings File |
.LDF | SQL Server Transaction Log File |
.NDF | SQL Server Secondary Database File |
.QRY | Query File |
.SDF | SQL Server Compact Database File |
.SQR | SQL Program File |
.TRC | SQL Server Trace File |
.TRN | SQL Server Transaction Log Backup File |
.WRK | SQL Server Log Shipping File |