New Article: Configure SQL Server Service Broker for sending stored procedure data
I’ve just published a new tip on SearchSQLServer.com called Configure SQL Server Service Broker for sending stored procedure data. In it I’m going over SQL Service Broker and how to configure all the objects.
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.