SQL Server is a relational database management system (RDBMS) developed by Microsoft. Its a central part of the Microsoft data platform. SQL Server is an industry leader in operational database management systems (ODBMS).
SQL Server Supports T-SQL (Transact-SQL), T-SQL is a set of programming extensions from Sybase and Microsoft that add several features to the Structured Query Language (SQL)
Edition | Description |
---|---|
SQL Server Enterprise Edition | Access mission-critical capabilities to achieve unparalleled scale, security, high availability, and leading performance for your Tier 1 database, business intelligence, and advanced analytics workloads. |
SQL Server Standard Edition | Find rich programming capabilities, security innovations, and fast performance for mid-tier applications and data marts. Easily upgrade to the Enterprise edition without having to change any code. |
SQL Server Express Edition | Build small, data-driven web and mobile applications up to 10 GB in size with this entry-level database. Available for free. |
SQL Server Developer Edition | Build, test, and demonstrate applications in a non-production environment with this full-featured edition. |
Version | Release Name | Year |
---|---|---|
Not yet released | SQL Server 2019 | 2019 |
14.0 | SQL Server 2017 | 2017 |
13.0 | SQL Server 2016 | 2016 |
12.0 | SQL Server 2014 | 2014 |
11.0 | SQL Server 2012 | 2012 |
10.50 | SQL Server 2008 R2 | 2010 |
10.0 | SQL Server 2008 | 2008 |
9.0 | SQL Server 2005 | 2005 |
The Database Engine is the core service for storing, processing, and securing data. The Database Engine provides controlled access and rapid transaction processing to meet the requirements of the most demanding data consuming applications.
The Database Engine to create relational databases for online transaction processing or online analytical processing data. This includes creating tables for storing data, and database objects such as indexes, views, and stored procedures for viewing, managing, and securing data.
Machine Learning Services to run Python and R scripts with relational data. You can use open source and Microsoft packages for predictive analytics and machine learning. The scripts are executed in-database without moving data outside SQL Server
Integration Services is a platform for building high performance data integration solutions, including packages that provide extract, transform, and load (ETL) processing for data warehousing.
Analysis Services is an analytical data platform and toolset for business intelligence. Servers and client designers support traditional OLAP solutions, new tabular modeling solutions, as well as self-service analytics and collaboration using Power Pivot, Excel, and a SharePoint Server environment.
Reporting Services to deliver Web based reporting functionality. You can also create reports that draw content from a variety of data sources, publish reports in various formats, with centrally manage security and manage subscriptions.
Replication is a set of technologies for copying and distributing data and database objects from one database to another, and then synchronizing between databases to maintain consistency.
SQL Server Data Quality Services (DQS) provides you with a knowledge-driven data cleansing solution.
Master Data Services is the SQL Server solution for master data management. A solution built on Master Data Services helps ensure that reporting and analysis is based on the right information.
SQL Server Connection String Formats
posted on 2019-08-27 05:53:53 - SQL Server Tutorials