I like to disable guest account access in SQL Server unless there is a real need for it. Here is why the guest user can be a serious security issue.
SQL SERVER – Case Sensitive Database and Database User – Fix: Error: 15151 – Cannot find the user , because it does not exist or you do not have permission.
Jeff hit Error 15151, cannot find the user, even though the user existed. The cause was a case sensitive database, and here is the fix.
Counting Users, Roles and Orphans in Every Database
Audit counting users across databases, include roles and schema ownership, and distinguish orphaned SQL users from contained identities.
SQL SERVER – 2012 Auditing Enhancement – On Audit Log Failure Options – Maximum Rollover Files
SQL Server 2012 adds two auditing enhancements: new options on audit log failure, like fail operation or continue, and a maximum rollover files setting.
SQL SERVER – Interview Questions and Answers – Guest Post by Rick Morelan – Day 27 of 31
A guest post by Rick Morelan, author of the Joes 2 Pros series, on the few interview questions that come up again and again and separate good answers from great.
Row-Level Security for Reports
Use SQL Server row-level security for reports with predicate functions and SESSION_CONTEXT, and test every identity boundary.
SQL SERVER – ‘Denali’ – A Simple Example of Contained Databases
What is new for security in SQL Server Denali? Contained databases keep their own settings, metadata and users, so moving them to a new server is easy.