Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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: March 2012

Caveats of a CONTROL SERVER permission


Today morning I was working on one of the server to complete the regular documentation of security audit with details of logins with sysadmin rights and their access to various database. Later I have realized that, one login has access to all database but it is not captured by my auditing script.…

Read more

1 comments, 850 reads

Posted in PracticalSQLDba on 29 March 2012

Microsoft Failover cluster 2008 : Moving MSDTC to new SAN disk


We have four node cluster on Windows 2008 where the MSDTC disk hosted on a SAN array. Now we have to move the MSDTC disk to new SAN drive as we are going to decommission the existing SAN. In this post  I will explain the steps that we have followed in…

Read more

4 comments, 1,824 reads

Posted in PracticalSQLDba on 28 March 2012

SQL server 2005 Database Mail stopped functioning after installing Service Pack 3


Recently I have upgraded one of our SQL server 2005 instance to Service Pack 3 and later point of time we have noticed that the database mail in that instance stopped working with the following error in Database Mail error log.

[260]  Unable to start mail session (reason: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException: Mail…

Read more

8 comments, 663 reads

Posted in PracticalSQLDba on 26 March 2012

How do you secure the SQL Server instance after enabling xp_cmdshell ?


OR
How do you allow non-administrator to use xp_cmdshell ?

From the day I started working with SQL server, I have heard about the security risk associated with enabling the xp_cmshell and used to restrain from using the xp_cmdshell. Now I have started using it as xp_cmdshell simplify many tasks…

Read more

7 comments, 1,845 reads

Posted in PracticalSQLDba on 22 March 2012

Importing images to SQL server database using T-Sql


Yesterday evening one of the developer  asked me that he need a help in importing images into a   table. It was interesting question for me as I never thought about the possibility of importing images to database table using a T-SQL. I invested some time and found that OPENROWSET is…

Read more

0 comments, 2,429 reads

Posted in PracticalSQLDba on 15 March 2012

Understanding the concept of SQL Server Failover Cluster


Before getting hands on experience in SQL server on failover cluster , I used to read many article about failover clustering. Unfortunately I was not able to digest the concept till I wet my hands.I will keep this point in my mind while explaining the failover cluster in this post.

What…

Read more

25 comments, 6,525 reads

Posted in PracticalSQLDba on 14 March 2012

Memory configuration in SQL server and break up of memory utilized by SQL server



In this post I would like to explain memory configuration option and memory utilization pattern in SQL server.I have seen many people worrying about the memory utilization (in task bar or through other monitoring tool) on a box where SQL server is installed. I have also seen people becoming…

Read more

1 comments, 2,098 reads

Posted in PracticalSQLDba on 11 March 2012

How to log off remote desktop users from a remote machine ?


When you try to log on to a  remote server on emergency to perform some task , it may throw an error "The terminal server has exceeded the maximum number of allowed connection". In many servers you may not have the rights to log on with /console or /admin option.…

Read more

7 comments, 5,215 reads

Posted in PracticalSQLDba on 6 March 2012

Resource Governor Configuration


Resource Governor(RG) is a technology which introduced in SQL server 2008 to manage the CPU and Memory resource that a incoming session can use.This feature is only available on Enterprise edition ,Develepoer edition and Evaluation Edition.

RG can be configured to restrict the resource utilization of user session. You can use it not only to…

Read more

0 comments, 1,172 reads

Posted in PracticalSQLDba on 4 March 2012