Browse by Tags
All Tags »
server (RSS)
Performance tuning exercise involves using SYSMON for the server based tasks, also I have seen users referring that MEMORY is at peak level by referring to Task Manager on the server. Not always depend upon the task manager, for optimum information better
Read More...
This sounds like a joke that "How many DBAs you need to change a light bulb?". I have come across this less technical question from SSP forum asking for recommended practices. They wanted to have information that How many servers should be managed by
Read More...
I hope you will get to see the above error message most often and I say a common question among forums & newsgroups. Few times you might be thinking why it is throwing error even though you are using right credentials to access that SQL Server instance.
Read More...
In SQL Server 2000 when you create a linked server then you can see that on Enterprise Manager under Security --> Linked Server. One of the Developer asked me how we can find same in SQL Server 2005 Management studio, here it is: You will find under
Read More...
Recently SQL Server support team had changed the process of releasing support hotfixes for the issues that are specific to a customer base. This KBA revises the incremental servicing model that is deployed for all the support fixes. We have moved away
Read More...
I have seen mounting questions asking on support for SQL Server 2005 on Vista & Windows 2008, what a surprise! As Windows Server 2008 (aka Longhorn) is still in CTP (BETA 3) stages it is hard to comment or confirm any sort of support arrangements
Read More...
I feel like there is lot of confusion ( new users ) in deciding which build to apply after the re-release of SQL Server 2005 Service Pack2 during the month of March 2007. So here is the list of references I would like to share in explaining what is what
Read More...
Using BIDS any user cannot create folders under the project like VS2005 does. As usual u ser can create more than one query folder, and the root folder can create child folders. The only way to recover this problem is to edit the XML file that is created
Read More...
Well the prime criteria for DBAs is to upgrade from the previous versions to latest version and it is not an easy option or platform to perform so quickly without having a proper testing within their environment. As far as the SQL Server is concerned
Read More...
This is a common question for a DBA who have been the path of Upgrade from previous version of SQL server to 2005 version, there are many reasons associated and main one is nothing but bad-code or poorly optimized code. Here are list of things you need
Read More...
With the latest release of SP2 Update release it has been a rumour in the community that it is a SP2a release, which I believe not as it is intended to fix a particular issue with cleanup tasks and maintenance plans. As the remaining tasks with Service
Read More...
Well this was my first question when my manager asked me about shall we look at Server Virtualization. When evaluating file virtualization solutions, you must consider how you plan to use virtualization initially, as well as how it fits into the infrastructure
Read More...