-
SQL Server Database Architecture
4 January 2017SQL Server data mainly in 2 types of files, Data file stores actual data with .mdf extension. It stores permanent data. Log files stores modified recorded information with .ldf extension….
-
SQL Server Storage Architecture
3 January 2017In an SQL server all the data will be stored in the form of records, these records also called row data. All these records further grouped into a page. The…
-
SQL Server Architecture
2 January 2017Introduction If you’re curious about how SQL Server works behind the scenes or you’re new to the world of databases, you’ve come to the right place. In this article, we’ll…
-
SQL Server Database Administration Introduction
1 January 20171. Database Administration A database administrator is a person responsible for the database design, implementation, maintenance, and repair of the database. The main goal of DBA is to keep the…