Browse by Tags

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

Unattended installation of application on multiple sites by using sa password with a symmetric key, is it possible in SQL Server?

Published 29 January 8 1:36 AM | SSQA.net

The newest ranch of Security - trust worthy features in SQL Server 2005 usage of symmetric keys has an important role. Always the document suggests to use Windows Authentication of security purpose and better control of user/security management, but when...

Filed under: application, sql server, security, best practice, sql authentication, sa password, symmettric keys, store, windows authentication

Performance - check whether it is affecting application or system, don't blame SQL Server alone

Published 3 September 7 9:42 AM | SSQA.net

Its a general assumption that whenever performance is degraded, the finger will be pointed to SQL Server, pretty easy eh!? If you look at any of the SQL Server related forums then 3 in 10 questions asks same question and nothing but shove blame on SQL...

Filed under: application, sql server, performance, blocking, security, query, table, wait, queue, high cpu, oltp

Using Application roles and security - SQL Server 2005

Published 19 June 7 3:30 PM | SSQA.net

In SQL Server, you can create database roles for easier administration of permissions in a database. Instead of granting individual permissions to each user separately, you can group users with the same permission needs by making them members of the same...

Filed under: application, sql server, performance, msdn, security, roles