JJB, your intuitions are correct.  You won't be able to use Windows Authentication to easily let the SQL Server database determine the permissions for your users.  In the world of...

I'll make an educated guess about why Microsoft has not changed this.  First, the design for SQL Authentication probably originated with Sybase in the early 1990s.  It was not a...

Steve, I am primarily a developer more than a DBA, but your explanations of GIT are much easier for me to understand than the many tutorials I have read targeted...

Thanks for raising the awareness of this behavior!