Browse by Tags

All Tags » application   (RSS)
Unattended installation of application on multiple sites by using sa password with a symmetric key, is it possible in SQL Server?
29 January 08 12:36 AM | SQL Master | 2 Comments   
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 Read More...
Performance - check whether it is affecting application or system, don't blame SQL Server alone
03 September 07 07:42 AM | SQL Master | 2 Comments   
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 Read More...
TSQL cursors vs API cursors - poor cursor usage
27 August 07 06:54 AM | SQL Master | 2 Comments   
Cursors are based for a definitive purpose, but heavy usage of such methods will prove as costly expense on database performance. The process of cursor is prolonged, as a cursor first has to be defined with its features set, then populated after positioning Read More...
Using Application roles and security - SQL Server 2005
19 June 07 01:30 PM | SQL Master | 1 Comments   
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 Read More...