I have total of 11 years of IT experience with Application development, Database Development and Database Administration. I have worked with different version of SQL server from 7.0 to 2008.Started my carrier as VB ,VC++ and database developer in a banking sector for implementing their core banking solution. Currently working as Database Administrator with wide knowledge in performance tuning, high availability solution, troubleshooting and server monitoring. This blog is my humble attempt to share my knowledge and what I learned from my day to day work.

SQL Server :Part 1 : Architecture of Transaction Log

by nelsonaloor

PracticalSQLDba

In our earlier post, we have discussed in detail about the architecture of the data file and different types of...

2013-09-30

10,024 reads

SQL Server: Data File Structure

by nelsonaloor

PracticalSQLDba

In our earlier posts , we have discussed about various types pages in details. In this post let us discuss about the organization of the data file.In other words...

2013-09-03

841 reads

SQL Server: Data File Structure

by nelsonaloor

PracticalSQLDba

In our earlier posts , we have discussed about various types pages in details. In this post let us discuss about...

2013-09-02

2,650 reads

SQL Server : Understanding Bulk Change Map (BCM) Page and Bulk Logged Recovery Model

by nelsonaloor

PracticalSQLDba

In the last post , we have discussed about the Differential Change Map pages and how it is utilized in the differential backup process.In this post, let us try to...

2013-07-25

50 reads

SQL Server : Understanding Bulk Change Map (BCM) Page and Bulk Logged Recovery Model

by nelsonaloor

PracticalSQLDba

In the last post , we have discussed about the Differential Change Map pages and how it is utilized in the...

2013-07-24

3,779 reads

SQL Server : Understanding Differential Change Map (DCM) Page and Differential Backups

by nelsonaloor

PracticalSQLDba

In our earlier posts, we have discussed about different types of pages.Data Pages, GAM and SGAM,PFS page and IAM page. In this post, we will try to understand the Differential Change...

2013-07-24

1,834 reads

SQL Server: Performance Tuning :Understanding Set Statistics IO output

by nelsonaloor

PracticalSQLDba

Performance tuning is one of the important task of DBA. Many times people comes to us with different types of...

2013-07-24 (first published: 2013-07-16)

4,018 reads

SQL Server : Understanding Differential Change Map (DCM) Page and Differential Backups

by nelsonaloor

PracticalSQLDba

In our earlier posts, we have discussed about different types of pages.Data Pages, GAM and SGAM,PFS page and IAM page. In this...

2013-07-23

2,248 reads

SQL Server: Performance Tuning :Understanding Set Statistics Time output

by nelsonaloor

PracticalSQLDba

In the last post we have discussed about Set Statistics IO and how it will help us in the performance tuning. In this post we will discuss about the Set...

2013-07-18

89 reads

SQL Server: Performance Tuning :Understanding Set Statistics IO output

by nelsonaloor

PracticalSQLDba

Performance tuning is one of the important task of DBA. Many times people comes to us with different types of performance issue.To handle all these, we should have...

2013-07-17

59 reads

All authors

SQL Server :Part 1 : Architecture of Transaction Log

SQL Server: Data File Structure

SQL Server: Data File Structure

SQL Server : Understanding Bulk Change Map (BCM) Page and Bulk Logged Recovery Model

SQL Server : Understanding Bulk Change Map (BCM) Page and Bulk Logged Recovery Model

SQL Server : Understanding Differential Change Map (DCM) Page and Differential Backups

SQL Server: Performance Tuning :Understanding Set Statistics IO output

SQL Server : Understanding Differential Change Map (DCM) Page and Differential Backups

SQL Server: Performance Tuning :Understanding Set Statistics Time output

SQL Server: Performance Tuning :Understanding Set Statistics IO output

Blogs

dataMinds Connect 2026 – Slides & Scripts

How to Clear the SSMS Cache (SSMS 21 and Later)

The flight recorder: Replaying what an AI agent did on my SQL Server

Forums

Alamat BCA KCP Thamrin Nine Telp:0821°7555°651

Alamat BCA KCP Samanhudi Telp:08218200203

Alamat BCA KCP AM Sangaji Telp:08218200233

Question of the Day

Checking the Error Log III