Creating Configurable and Portable SSIS Packages Part 1

This is the first part of a two-part post about creating and deploying a simple SSIS package. When I first started this I was a complete novice as regards SSIS. I thought it was 'something like' DTS, which I had used quite frequently in SQL Server 2000. To make matters worse, I never actually got round to learning it even w... More

Handling Orphaned Database Users

This isn't the first time I've had to deal with orphaned users in SQL Server, and probably won't be the last but today I found myself investigating why it happens and how to resolve the issue it causes. I guess before I start on that I should explain what an orphaned user is. The best way is probably to illustrate with a c... More