SQL Server - Getting Started



What is SQL Server?

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)


Editions

EditionDescription
SQL Server Enterprise EditionAccess 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 EditionFind 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 EditionBuild small, data-driven web and mobile applications up to 10 GB in size with this entry-level database. Available for free.
SQL Server Developer EditionBuild, test, and demonstrate applications in a non-production environment with this full-featured edition.

Versions

VersionRelease NameYear
Not yet releasedSQL Server 20192019
14.0SQL Server 20172017
13.0SQL Server 20162016
12.0SQL Server 20142014
11.0SQL Server 20122012
10.50SQL Server 2008 R22010
10.0SQL Server 20082008
9.0SQL Server 20052005

SQL Server Technologies

Database Engine

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

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

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

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

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

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.


Data Quality Services

SQL Server Data Quality Services (DQS) provides you with a knowledge-driven data cleansing solution.


Master Data Services

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.



Connection String

SQL Server Connection String Formats

posted on 2019-08-27 05:53:53 - SQL Server Tutorials


UNION

union in SQL server

posted on 2019-08-09 23:05:33 - SQL Server Tutorials


System Functions

System Functions in SQL Server

posted on 2019-08-09 06:14:33 - SQL Server Tutorials


Prompt Examples

ChatGPT Prompt Examples

posted on 2023-06-21 22:37:19 - ChatGPT Tutorials


Use Cases

Chat GPT Key Use Cases

posted on 2023-06-21 21:03:17 - ChatGPT Tutorials


Prompt Frameworks

Prompt Frameworks

posted on 2023-06-21 19:33:06 - ChatGPT Tutorials