Microsoft SQL Server 2012 Instance Architecture

Microsoft SQL Server 2012 Relational Database Engine is driven by an Instance and the Instance is driven by the system databases.

There 5 mandatory system databases that drive the instance Master, MSDB, Model, TempDB and mssqlsystemresource.

In This video we have a look at the relevance of the system database and also have a look at how we can configure instance with a Central Management Server.We also unveil the secret of how you can have a peek into the hidden mssqlsystemresource database and view its contents.

The Video Embedded below is one of the sessions I have conducted recently to a corporate audience and tries to give you an in-depth understanding of the SQL Server system databases and Introduces Central Management Servers.

Please note this is a live training video and could have interruptions and class communication parceled along J