SQL 2008 one click database encryption gives a false sense of security
While I think that the one click database encryption that Microsoft has built into SQL Server 2008 is a good idea, but I’m not sure how useful it actually is.
I’ll be speaking at the NJ SQL Server User Group
The NJ SQL Server User Group has been kind enough to invite me to come speak to them about SQL Server Service Broker. I’ll be speaking up there on August, 19, 2008.
Back To Basics: How do I use sp_change_users_login?
The sp_change_users_login procedure has a specific purpose. It’s used to identify and correct users within a database which do not have a corresponding logins.
Back To Basics: Logins and Users, what’s the difference?
Usually Logins and Users are words which are interchangeable with each other. However in Microsoft SQL Server they are very different things. Because everyone assumes that they are the same thing, it can get a little confusing.