Browse by Tags

SQL Server 2008: Administer multiple servers by designating configuration servers

Published 27 February 8 3:0 AM | SSQA.net

Ok, they give you new tool and in next release it has been taken away! This is similar to Surface Area Configuration tool from SQL Server 2005 and after 3 years you don't see from next release which is SQL Server 2008. How do you manage or can administer...

Filed under: sql server, management, ssms, 2008, multiple, object explorer, configuration server

See how Resource Governor can help you 'in action' in managing SQL Server resources?

Published 8 February 8 2:11 AM | SSQA.net

As you may be aware about new features within SQL Server 2008, one of the them is Resource Governor which is a feature than you can use to manage SQL Server workload and system resource consumption. It will enable you to specify limits on the amount of...

Filed under: application, sql server, management, blogs, security, query, 2008, resource governor

What are advantages of 64-bit system in relation to SQL Server?

Published 19 December 7 8:40 AM | SSQA.net

We have most of our database systems on 64-bit environment, but one of the application user asked the question what is the advantage of a 64-bit environment in relation to SQL Server application. I would say with the evolution of SQL Server 2005 it has...

Filed under: sql server, package, management, microsoft, server, windows, best practices, 2008, consolidation, planning, x64, 2005, advantages, policies