From the course: SQL Server 2014: Developing Databases

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Understanding the SQL Server services

Understanding the SQL Server services - SQL Server Tutorial

From the course: SQL Server 2014: Developing Databases

Start my 1-month free trial

Understanding the SQL Server services

- Let's understand the other services that are available within SQL. Basic idea of SQL Server is it's a relational database management system. So, we have multiple databases, and they're managed by SQL Server. And the heart of all of these services is the database engine where we create our databases which is the subject of this course. There are other services within SQL that you should at least be familiar with. So, let's take a look at them. I'm in Object Explorer, and I'm going to pull down my select chevron, and select Analysis Services, and now I'm going to connect into Analysis Services. This is available because, when I was doing my install of SQL, I said I wanted not only the database engine, but I also wanted Analysis Services. So, I call Connect, and now we're connected into Analysis Services. This is hard to see, but that's in the shape of a cube, whereas this is in the shape of an elongated cylinder. So, again, if I expand out Databases, I'm looking at Analysis Services…

Contents