What Brings a Good Looking DBA Like You to a Place Like This? You’ve most likely found this post because of one of the following reasons: You’ve got this shiny new server and are thinking about installing SQL Server on it. You’ve been following this series from the beginning (thank you by the way) and(…)
The db_owner Database Role Has a Secret The right solution is not frequently the easiest to implement. Avoiding hyperbole as much as possible I’ll simply say that database security is a very fine example of that adage. It is by far easier to … grant all users in a database membership in the db_owner database(…)
A Little Patience It’s been a long time since I rock and rolled since I addressed this series on common mistakes in SQL Server database administration. When it comes to this topic I’m glad I held off because the recommendations have changed from when I was originally working on this series when it comes to(…)