Subscribe to this blog
PracticalSQLDba
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.
Archives: October 2012
Windows Server 2008 Cluster: Understanding the Cluster Log Behavior
In any system, logs are very important to troubleshoot the issue. In the case of windows cluster, cluster logs are like a black box which will have all information about the failure of cluster.This is very important information, that we need, to raise a case with Microsoft. In this post let…
0 comments, 83 reads
Posted in PracticalSQLDba on 17 October 2012
SQL Server : Index Part 1 : Basics of index
While conducting interviews , I have noticed that, many people does not have clear picture about index.Many of them does not have clear picture about the difference between clustered and non clustered index.When people ask about index, it is tough to explain in one go. I feel it is worth…
6 comments, 119 reads
Posted in PracticalSQLDba on 11 October 2012
SQL Server:Understanding The Page Free Space (PFS) Page
In my earlier post, we have discussed about GAM and SGAM Page and Data Page. In this postlet us discuss about the Page Free Space (PFS) page.
PFS page is the second page (Page Number 1) in the data file followed by file header (Page Number 0). GAM…
0 comments, 87 reads
Posted in PracticalSQLDba on 10 October 2012
SQL Server: Sending Email in HTML Table Format Using TSQL
As part of our DBA life , we have to configure many alert or statistical mails which gives an idea about the state of the database server. Let us discuss how we can send an email in HTML table format using TSQL. I am just going to give a sample…
0 comments, 119 reads
Posted in PracticalSQLDba on 4 October 2012
SQL Server : Setting up Server Side Trace
For a DBA, SQL profiler is a great tool to trouble shoot performance issues. It is a pain to configure a trace and analyse it using the profiler GUI . I usually use server side trace which can be configured by running set of scripts. Server side traces are much lighter as…
1 comments, 454 reads
Posted in PracticalSQLDba on 2 October 2012