Browse by Tags

All Tags » General Security   (RSS)
Disaster Recovery: What to do when the SA account password is lost in SQL Server 2005
You may have faced the issue of losing the SQL Server SA password. Perhaps you followed the security best-practice of removing the builtin\Administrators from the sysadmin server role, and no one you can find is in the sysadmin role. At this point you Read More...
Posted 12 July 07 10:19 by raulga | 3 Comments   
Filed under
Dynamic SQL and digital signatures in SQL Server 2005
As I already mentioned, dynamic SQL is a quite powerful, but also quite dangerous. In SQL Server 2005 we introduced a new feature that is also quite powerful and when used properly can be quite useful; but it is important to learn and understand any such Read More...
Posted 09 May 07 11:42 by raulga | 5 Comments   
Filed under , , , ,
Quick guide to DB users without logins in SQL Server 2005
SQL Server 2005 introduced a new SQL DB principal subtype that can be quite useful: a SQL user that is not mapped to any login. You may be asking yourself “Why is this feature interesting? after all SQL Server already had the ability to create SQL users”. This article tries to describe this new feature and give some useful tips on how to use it. Read More...
Posted 03 July 06 03:25 by raulga | 2 Comments   
Filed under ,
Attachment(s): User_without_login.sql
Link to Laurentiu's blog
I am including a link to Laurentiu Cristofor's blog: http://blogs.msdn.com/lcris . Laurentiu is one of the most valuable contributors in the SQL Security forums, and his articles and demos are great resources for anyone interested in SQL Server security Read More...
Posted 03 May 06 09:25 by raulga | 0 Comments   
Filed under

Search

This Blog

Syndication

Page view tracker