Welcome to Romanian SQL Server User Group Sign in | Join | Help

octombrie 2007 - Posts

Error Handling in Service Broker procedures

Error handling in T-SQL traditionally has been a sort of misterious voo-doo for most developers, with it’s mixture of error severities, SET settings like XACT_ABORT, ARITHABORT or ARITHIGNORE and the options to handle the error on the server or Read More...
Posted 31 octombrie 2007 20:13 from rusanu.com | (Comments Off)
Filed under:

SQL Server undocumented password hashing builtins: pwdcompare and pwdencrypt

First, I must say that I don't know why these exist in an undocumented form. They have been around for a long time and a search on their names gets me back pages of hits. Being undocumented means that their actual implementation may change slightly from Read More...
Posted 31 octombrie 2007 20:08 from Laurentiu Cristofor's blog | (Comments Off)

Welcome to rusanu.com

Welcome to my new blog: http://rusanu.com/blog. Here I will continue to post articles on Service Broker as I used to on the old MSDN blog, as well as other areas of interest. Fell free to leave a comment and feedback is not only welcomed, but much desired! Read More...
Posted 29 octombrie 2007 14:57 from rusanu.com | (Comments Off)
Filed under:

Basic SQL Server Security concepts: SIDs, orphaned users, and loginless users

I am grouping here two topics (orphaned users and loginless users) that are actually very different, but I have often seen confusion between them, so I am covering them together in an attempt to dispel that confusion. In a previous discussion of logins Read More...
Posted 26 octombrie 2007 02:42 from Laurentiu Cristofor's blog | (Comments Off)

SQL Server 2005: A note about the use of certificates

To avoid any confusion, this post is not about the use of certificates for securing the communication between a client machine and the server; instead, this refers to the use of certificates created via the CREATE CERTIFICATE DDL. I am prompted in writing Read More...
Posted 5 octombrie 2007 05:59 from Laurentiu Cristofor's blog | (Comments Off)

SQL Server 2008: Transparent data encryption feature - a quick overview

I have kept silent on this feature while it was being developed, but as it has now been publicly advertised in various ways (being mentioned here , here , here , and here , for example), I think it is probably time to write a bit about it. Given that Read More...
Posted 4 octombrie 2007 01:55 from Laurentiu Cristofor's blog | (Comments Off)