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.

Windows Cluster : Understanding the Quorum settings

by nelsonaloor

PracticalSQLDba

In my earlier post, I have explained about the windows cluster and how Sql server works on cluster environment. In...

2012-07-18

3,986 reads

SQL Server: Instant Deadlock Alert Using WMI in Your Mailbox

by nelsonaloor

PracticalSQLDba

In my last post I have explained,how to setup alert for blocking using WMI. In this post let us see how...

2012-07-17 (first published: 2012-07-16)

5,601 reads

SQL SERVER:How Can I Get Notification Alert When Fail Over Happened ?

by nelsonaloor

PracticalSQLDba

It was long time I was searching for simple solution to get notification alert in my inbox when ever fail...

2012-07-16 (first published: 2012-07-05)

5,066 reads

SQL Server: Instant Blocking Alert Using WMI in Your Mailbox

by nelsonaloor

PracticalSQLDba

As a DBA, it is important for all of us to get real time alert on various issues in our...

2012-07-13

6,725 reads

SQL SERVER : SQL Server Scheduler

by nelsonaloor

PracticalSQLDba

While troubleshooting the performance issues of SQL server, you might have seen the sessions are in different state like SUSPENDED,RUNNING,RUNNABLE etc....

2012-07-12

8,730 reads