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:
Performance—SQL Server is fast (make ...