SQL Server Videos Playlist

 
00:00

What is SQL Server?

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database, it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet). There are at least a dozen different editions of Microsoft SQL Server aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users. Its primary query languages are T-SQL and ANSI SQL.

Prior to version 7.0 the code base for MS SQL Server was sold by Sybase SQL Server to Microsoft, and was Microsoft's entry to the enterprise-level database market, competing against Oracle, IBM, and, later, Sybase. Microsoft, Sybase and Ashton-Tate originally worked together to create and market the first version named SQL Server 1.0 for OS/2 (about 1989) which was essentially the same as Sybase SQL Server 3.0 on Unix, VMS, etc. Microsoft SQL Server 4.2 was shipped around 1992 (available bundled with IBM OS/2 version 1.3). Later Microsoft SQL Server 4.21 for Windows NT was released at the same time as Windows NT 3.1. Microsoft SQL Server v6.0 was the first version designed for NT, and did not include any direction from Sybase.

About the time Windows NT was released in July 1993, Sybase and Microsoft parted ways and each pursued its own design and marketing schemes. Microsoft negotiated exclusive rights to all versions of SQL Server written for Microsoft operating systems. (In 1996 Sybase changed the name of its product to Adaptive Server Enterprise to avoid confusion with Microsoft SQL Server.) Until 1994, Microsoft's SQL Server carried three Sybase copyright notices as an indication of its origin.

SQL Server 7.0 and SQL Server 2000 included modifications and extensions to the Sybase code base, adding support for the IA-64 architecture. By SQL Server 2005 the legacy Sybase code had been completely rewritten.[5]

Since the release of SQL Server 2000, advances have been made in performance, the client IDE tools, and several complementary systems that are packaged with SQL Server 2005.
These include:
- an extract-transform-load (ETL) tool (SQL Server Integration Services or SSIS)
- a Reporting Server
- an OLAP and data mining server (Analysis Services)
- several messaging technologies, specifically Service Broker and Notification Services

SQL Server Release History
Version Year Release Name Codename Internal

Version

1.0

(OS/2)

1989 SQL Server 1.0

(16 bit)

Ashton-Tate /

Microsoft SQL Server

-
1.1

(OS/2)

1991 SQL Server 1.1

(16 bit)

- -
4.21

(WinNT)

1993 SQL Server 4.21 SQLNT -
6.0 1995 SQL Server 6.0 SQL95 -
6.5 1996 SQL Server 6.5 Hydra -
7.0 1998 SQL Server 7.0 Sphinx 515
- 1999 SQL Server 7.0

OLAP Tools

Palato mania -
8.0 2000 SQL Server 2000 Shiloh 539
8.0 2003 SQL Server 2000

64-bit Edition

Liberty 539
9.0 2005 SQL Server 2005 Yukon 611/612
10.0 2008 SQL Server 2008 Katmai 661
10.25 2010 Azure SQL DB Cloud Database

or CloudDB

-
10.50 2010 SQL Server 2008 R2 Kilimanjaro (aka KJ) 665
11.0 2012 SQL Server 2012 Denali 706
12.0 2014 SQL Server 2014 SQL14 782

Source - http://en.wikipedia.org/wiki/Microsoft_SQL_Server

SQL Server videos by titles