Security

Broken ownership chain – Dynamic SQL

Today I had a co-worker come to my desk wondering why his service was getting a permissions error when selecting from a table. His confusion was rooted in the fact that his service has been using this stored procedure for…

Creating Logins and Users – Why I can’t connect

If you have ever used database projects with SSDT I’m sure you’ve experienced a situation where that user you just created yesterday is suddenly complaining to you that they can no longer access the database. Often this is because SSDT…