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,764 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,745 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,168 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,412 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,969 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,454 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,711 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,725 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,497 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,300 reads

Blogs

Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables

By Eduardo Pivaral

Every PostgreSQL migration eventually hits the same fork in the road. The database is...

A Spread of Vacation

I’m off on vacation today. Which is a little weird as I just got...

How AgentDBA Identifies Backup Failures

Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...

Read the latest Blogs

Forums

ALAMAT BCA KCU PURI INDAH Telp:08218154393

WA:08218154393 Gedung C3 Lt. 1-3 Komplek, Jl. Puri Indah Raya No.1-3 Blk 02, RT.3/RW.2,...

ALAMAT KONTAK BCA KCP Santa Telp:08218154393

WA:08218154393 Jl. Wolter Monginsidi No.54, RT.2/RW.4, Petogogan, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah...

Have you done a Mid year check in?

Comments posted to this topic are about the item Have you done a Mid...

Visit the forum

Question of the Day

Independence Day 2026

In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.

See possible answers