Lesson 2. Introducing SQL Server

In this lesson, you learn what SQL Server is, and the tools we’ll be using to work with it.

What Is SQL Server?

In the previous lesson, you learned about databases and SQL. As explained, it is the database software (DBMS or Database Management System) that actually does all the work of storing, retrieving, managing, and manipulating data. SQL Server is a DBMS—that is, it is database software.

SQL Server has been around for a long time and is in use at millions of installations worldwide. Why do so many organizations and developers use SQL Server? Here are some of the reasons:

Image Performance—SQL Server is fast (make ...

Get Sams Teach Yourself Microsoft® SQL Server T-SQL in 10 Minutes, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.