Browse by Tags

SQL Server 2005 detect DAC session with TSQL

Published 9 May 8 1:11 PM | SSQA.net

SQL Server 2005 has introduce a secret-door for Admins to identify and resolve any connect lockout issues within your database instance, as on http://sqlserver-qa.net/blogs/tools/archive/2007/08/04/dedicated-administrator-console-dac-saved-an-important...

Filed under: sql server, security, dmv, tsql, dac, session

TSQL to findout blocking and locks on a SQL Server?

Published 7 December 7 1:8 PM | SSQA.net

Have you ever performed huge operations such as deleting records of a table and processing inserts on that table at the same time? This is a common task that every application will have to perform and you can avoid by fine tuning your queries (mostly...

Filed under: sql server, performance, indexes, blocking, security, insert, tsql, locks, deletes

How to find all the owners of entities contained in a specified schema?

Published 4 October 7 3:0 AM | SSQA.net

How to find all the owners of entities contained in a specified schema? USE <database_name>; GO SELECT 'OBJECT' AS entity_type ,USER_NAME(OBJECTPROPERTY(object_id, 'OwnerId')) AS owner_name ,name FROM sys.objects WHERE SCHEMA_NAME...

Filed under: sql server, security, login, tsql, enhancement, schema, entity

Control metada visibility using few 'simple' statements

Published 9 August 7 5:3 AM | SSQA.net

You may be aware that a user in a SQL Server 2005 database can only see metadata that the user either owns or on which the user has been granted some permission. A default policy enhanced as compared to how a DBA can control the security access to the...

Filed under: security, access, view, tsql, principal, privileges, metadata

Fun and fumes about Dynamic SQL & SQL injection

Published 24 July 7 7:25 AM | SSQA.net

D-SQLInjection & DSQL_Talk things you need to consider and take care, just caught my eye recently....( read more ) Read More...

Filed under: security, tsql, injection, dynamic sql

Usage and good practices with UPDATE STATISTICS feature in SQL 2005

Published 23 July 7 5:39 AM | SSQA.net

UPDATE STATISTICS is very helpful to get the performance by updating the distribution of key values for one or more statistics groups or set of collections in the specified table or indexed view. So how this is handled within the SQL Server, you may be...

Filed under: performance, security, dmv, query, optimization, tsql, statistics, update statistics