|
|
-
|
|
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 ...
|
|
-
|
|
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 our ...
|
|
-
|
|
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 s...
|
|
-
|
|
ORHow do you allow non-administrator to use xp_cmdshell ?From the day I started working with SQL server, I have heardabout the security risk associated with enabling the xp_cmshell and used to restrain from using the xp_cmdshell. Now I havestarted using it...
|
|
-
|
|
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 a...
|
|
-
|
|
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 fail...
|
|
-
|
|
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 installe...
|
|
-
|
|
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 ...
|
|
-
|
|
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 config...
|
|