Main menu

Category Archives: Database

MySQL Architecture

MySQL is an RDBMS owned by Oracle. It’s an widely used database server and was default in LAMP stack until MariaDB. MySQL is based on tiered architecture, which components that interact with each other to store, read and execute SQL…

Restore system databases in SQL Server

Before dig into restore system databases in SQL server first let’s know about why they are important. Their are mainly four system databases master : All system level information in SQL server like Database info, User info etc. model :…