Welcome to PC Teach Me...

Free Computer Training Videos.

Although you do not need to register to access this site. Registering has its benefits. Such as:

  • Access to training material associated with the video you are watching [if applicable]
  • Automatic email updates when new training videos are available.
  • Ask for a training video.
  • Exclusive access to pose questions to me [limited availability as I am doing this for free :-)].
  • Free contribution of your own training topics, this includes referencing your videos outside of PC Teach Me.
  • Its Free!

Member Login

Lost your password?

Not a member yet? Sign Up!

By registering with this blog you are also agreeing to receive email notifications for new posts but you can unsubscribe at anytime.

24778 Registered Users
71 Number Of Articles
Free Video Tutorials (Email) Free Video Tutorials (RSS) Free Video Tutorials (Twitter) Free Video Tutorials (Flickr)

SQL: System Databases

Part of Microsoft SQL Basics

sql SQL: System Databases SQL: System Databases

In SQL Server there are four databases that you may never use but are equally as important as your databases you work on day in day out.

These “System” databases are a fundamental concept to understand and will take a long time to master. In the case of this video I will give you a run down of what each one does (albiet quickly) so you have a general understanding of what they do and why they need to be backed up.

What are the SQL System Databases?

These database are the very core to SQL Server.  They control from everything you see in the SQL Management studio, through to the commands/statements that you use in your general day to day useage.  Although it can be considered a boring part of SQL it is still vital. So have your coffee ready and follow me!

Without giving to much of the story away (watch the video for the full detail) the 4 databases are as follows:

  1. Master
    This contains all the core information for SQL to work.
  2. MSDB
    This is the library of all commands and is the root for all other SQL connections such as SSIS.
  3. TempDB
    This as its name suggests is a temporary store of information.
  4. Model
    This is a template database which is used everytime you create a new database.

The above is a whirlwind summation of what they do.  The video will expand on these things further.

Other SQL Videos

This video is one of many SQL tutorials on this site click here for more

Related Posts

22 Comments

  1. vong visalsambath says
    05 Jul 14 at 7:50am

    Thank you :)

  2. Sankung Fofana says
    22 Oct 12 at 11:49pm

    Quite clear and helpful…

Leave a Comment

You must be logged in to post a comment.

Valid XHTML 1.0 Transitional website security