Lesson 2. Introducing SQL Server

In this lesson, you’ll learn what SQL Server is and the tools you can use when working 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:

Performance: SQL Server is fast (make that very fast).

Trusted: SQL Server is used by some of the most important ...

Get Sams Teach Yourself Microsoft now with O’Reilly online learning.

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