During a user group meeting one of the user asked that If we were to migrate our databases over to the evaluation edition of SQL Server 2005, is there a way of upgrading to the purchased (licensed) version (before the 180 day expires) without uninstalling or stopping the converted migrated running or production 2005 databases. The easy option is ...

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 a DBA or how many DBAs you need to manage a 400+ SQL Servers within their environment. I believe ...

Yet another AWE memory settings blog post here that I'm posting for the issues we have had recently. Before going into details review about 3GBPAE blurb here and also refer to this KBA274750 to enable more than 2GB memory within your SQL Server Enterprise edition instance. Coming to the problem on a server having 6GB RAM and having required ...

Say you have multiple instances of SQL Server and on mixed platforms such as 32 bit and X64 bit platforms, so how do you find which version of SQL you have installed. If you are well versed with the environment then by looking at the servernames you can mention so. But how about a new DBA started and need to perform a set of actions on X64 ...