6 min read
1
SQL Server Migration
Migration means moving one (or) set of databases from one server to another server. SQL Server Migration Scenarios Scenario 1:…
Category: MSSQL
4 min read
3
SQL Server Automation
Automation refers to scheduling the regular maintenance tasks. Whenever schedule time comes automatically that task will be executed. DBA regular…
9 min read
3
SQL Server Security
Security is the most important tasks for a DBA. we need control the access to sql server as well as…
9 min read
5
SQL Server Restoration Tutorial
Restoration is a process of using backups to recover the exist database (or) to create a new database in another…
9 min read
1
SQL Server Backups
Backup means, saving the exact copy of the current version of database in some other location. Situations where backup can…
6 min read
4
SQL Server Databases
Database: Database is a container which stores data and data objects. It manages data and allows fast storage and retrieval…
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…
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…