SQL Server Migration
Migration means moving one (or) set of databases from one server to another server. SQL Server Migration Scenarios Scenario 1: As a part of launch, deployment in the production server and go live In all these 3 types we are…
Category: MSSQL
Read More →
SQL Server Automation
Automation refers to scheduling the regular maintenance tasks. Whenever schedule time comes automatically that task will be executed. DBA regular activities can be automated we can get the status f the task in the form of alert and helpful while…
SQL Server Security
Security is the most important tasks for a DBA. we need control the access to sql server as well as provide security to the datal. Levels of SQL Server Security There are mainly 3 levels of security. Server level – Is…
SQL Server Restoration Tutorial
Restoration is a process of using backups to recover the exist database (or) to create a new database in another server. Situations for Restoration Planned restoration, when we have planned activities like migration, upgradation, database refresh from prod to other…
SQL Server Backups
Backup means, saving the exact copy of the current version of database in some other location. Situations where backup can use Hardware failure includes operating systems CPU memory, network card failures. Software failure includes operating system failures database server failures.…
SQL Server Databases
Database: Database is a container which stores data and data objects. It manages data and allows fast storage and retrieval of that data. Types of Databases in SQL Server: There are 2 types of databases, 1. System Databases: System databases…
SQL Server installation
Installation Whenever we want to start the installation of the SQL server we need to gather details of installation. SQL Server Versions Version (Name) RTM SP1 SP2 SP3 SP4 Sql server 2014 (Heteko) Trail version released Sql server 2012 (Denali)…
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 to the log file will associate with an LSN number. Roll forward and the rollback will be done internally using…
SQL Server Database Architecture
SQL 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. We have another file called secondary data file .ndf file…
SQL Server Storage Architecture
In 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 page is a default storage unit of the SQL server.…