Learn more about SQL Server tools

mssqltips logo

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories


SQL Server 101 Tutorial Outline and Overview


Since its initial release in 1989, SQL Server has come a long way from its base functionality as an enterprise level database platform.  While the core of SQL Server is still it's database engine, it is now so much more than just a relational database platform.  We now have Analysis Services for online analytical processing, Reporting Services for developing reports, Integration Services for developing and running ETL programs as well as many other tools and services that work with and/or support these core components. 

As long as I have been working with SQL Server, I have had at least some exposure to each of the core SQL Server components, but every so often I come across some new tool or even an old tool that I had not heard about within the SQL Server ecosystem that would have helped me with an issue I was trying to resolve. 

In the following tutorial we will try to go through most of the core components and tools that make up the SQL Server platform and explain what can be done within each of these components. 

Below is an overview of what we will cover:

  1. SQL Server Components
    • Core Components
    • Ancillary Services
    • Other tools
  2. Feature Set by Software Version and Edition
  3. Version Release Dates and Support Timeline
  4. Installation Guidelines
  5. Licensing Models and Costs
  6. Architecture Overview
    • Database
    • Analysis Services
    • Reporting Services
    • Integration Services
  7. Tools Available and their Function
  8. Querying Data
    • Language
    • Tools
  9. Terminology
Additional Information

Last Update: 8/23/2019

More SQL Server Solutions

Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 

Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.


Learn more about SQL Server tools