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 : Index Part 3 :Explaining the Clustered Table Structure

by nelsonaloor

PracticalSQLDba

In SQL server, there are two types of table based on the storage.A table with clustered index is called Clustered...

2013-03-12

2,901 reads

SQL Server : Understanding the IAM Page

by nelsonaloor

PracticalSQLDba

In my earlier post, we have discussed about Data,GAM,SGAMand PFS pages. In this post, let us try to understand about...

2013-03-07

7,868 reads

SQL Server : Index Part 2 : Structure of Heap Tables

by nelsonaloor

PracticalSQLDba

In the earlier post we tried to understand the difference between a table having clustered index and does not have a clustered...

2013-03-06

2,219 reads

SSRS: Report Server Usage Report

by nelsonaloor

PracticalSQLDba

While working with SSRS (SQL Server Reporting Service) it is very common to look into the Execution log to understand...

2013-03-06

2,591 reads

Windows Server 2008 Cluster: Understanding the Cluster Log Behavior

by nelsonaloor

PracticalSQLDba

In any system, logs are very important to troubleshoot the issue. In the case of windows cluster, cluster logs are...

2012-10-17

1,032 reads

SQL Server : Index Part 1 : Basics of index

by nelsonaloor

PracticalSQLDba

While conducting interviews , I have noticed that, many people does not have clear picture about index.Many of them does not...

2012-10-11

1,385 reads

SQL Server:Understanding The Page Free Space (PFS) Page

by nelsonaloor

PracticalSQLDba

In my earlier post, we have discussed about GAM and SGAM Page and Data Page. In this postlet us discuss about...

2012-10-10

6,413 reads

SQL Server: Sending Email in HTML Table Format Using TSQL

by nelsonaloor

PracticalSQLDba

As part of our DBA life , we have to configure many alert or statistical mails which gives an idea about...

2012-10-04

1,512 reads

SQL Server : Setting up Server Side Trace

by nelsonaloor

PracticalSQLDba

For a DBA, SQL profiler is a great tool to trouble shoot performance issues. It is a pain to configure...

2012-10-02

1,291 reads

SQL Server: Part 2 : Approaching Database Server Performance Issues

by nelsonaloor

PracticalSQLDba

In the Part 1, we have seen how quickly we can check the runnable task and I/O pending task on...

2012-09-28 (first published: 2012-09-21)

3,794 reads

Blogs

dataMinds Connect 2026 – Slides & Scripts

By Koen Verbeeck

You can find the slides and SQL scripts for my session “Spice up your...

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

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

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

“What exactly did it do on my server?” is the first question a DBA...

Read the latest Blogs

Forums

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

By layanan_Bca88

Telp/Wa 628217555651 Thamrin Nine Podium Area - UG Unit A, Jl. MH Thamrin No.10,...

Alamat BCA KCP Samanhudi Telp:08218200203

Telp/Wa 628218200203 Jl. Samanhudi No.57 B, RT.5/RW.3, Ps. Baru, Kecamatan Sawah Besar, Kota Jakarta...

Alamat BCA KCP AM Sangaji Telp:08218200233

Telp/Wa 628218200233 Jl. A.M Sangaji No.020 A, RT.3/RW.04, Petojo Utara, Kecamatan Gambir, Kota Jakarta...

Visit the forum

Question of the Day

Checking the Error Log III

If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?

See possible answers