8 min read
1
SQL Server installation
Installation Whenever we want to start the installation of the SQL server we need to gather details of installation. SQL…
Year: 2017
3 min read
2
SQL Server Transaction Log Architecture
Transaction Log Architecture SQL Server uses LSN (Log Sequential Number) in identifying the transaction. Each and every transaction that comes…
4 min read
10
SQL Server Database Architecture
SQL Server data mainly in 2 types of files, Data file stores actual data with .mdf extension. It stores permanent…
3 min read
3
SQL Server Storage Architecture
In an SQL server all the data will be stored in the form of records, these records also called row…
5 min read
4
SQL Server Architecture
Introduction If you’re curious about how SQL Server works behind the scenes or you’re new to the world of databases,…
2 min read
7
SQL Server Database Administration Introduction
1. Database Administration A database administrator is a person responsible for the database design, implementation, maintenance, and repair of the…