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 : How to List All Email Subscription configured in SSRS ?

by nelsonaloor

PracticalSQLDba

Often I used to get request from my business managers to get a list of all subscriptions configured in SSRS...

2012-09-27

14,809 reads

SQL Server: Part 4 : Approaching Database Server Performance Issue

by nelsonaloor

PracticalSQLDba

In the last three parts, we have discussed about different queries that can be used to list the current state...

2012-09-26

1,756 reads

SQL Server: Part 3 : Approaching Database Server Performance Issue

by nelsonaloor

PracticalSQLDba

In the last post, we have discussed the script to list the sessions which are waiting for resource or currently...

2012-09-24

1,172 reads

SQL Server: Part 1 : Approaching Database Server Performance Issues

by nelsonaloor

PracticalSQLDba

When you work as DBA, many people will approach you with a complaint like "Application is taking ages to load...

2012-09-18

1,415 reads

How to Connect PerfMon to a Remote Server ?

by nelsonaloor

PracticalSQLDba

Till now, we do not have any third party tool to monitor the SQL server, but we have implemented many custom...

2012-09-17

4,981 reads

SQL Server : Usage of OVER Clause

by nelsonaloor

PracticalSQLDba

Over clause can be used in association with aggregate function and ranking function. The over clause determine the partitioning and...

2012-09-17 (first published: 2012-09-10)

10,475 reads

Discuss

SQL Server: String Pattern Matching

by nelsonaloor

PracticalSQLDba

It is common scenario that, we might need to extract the data from the SQL server based on some pattern....

2012-09-13

11,730 reads

SQL Server: Understanding GAM and SGAM Pages

by nelsonaloor

PracticalSQLDba

We know that SQL server stores the data in 8 KB pages. An extent is made up of 8 physically contiguous...

2012-09-12

26,770 reads

SQL Server:Output Clause

by nelsonaloor

PracticalSQLDba

Couple of days back, one of my colleague came to me asking for help. He is inserting multiple record from a...

2012-09-09

1,504 reads

SQL Server:Understanding the Data Record Structure

by nelsonaloor

PracticalSQLDba

In our last post, we have gone through the data page structure and we have noticed that there is an...

2012-08-22

7,333 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