Tag: Best Practice

• Using Database Roles for Database Level Security Management

  

  2014-01-06 - Fundamentals, General, Security

  Database roles simplify security management on a database level. With database roles we can grant or deny permissions to a group of database users. Find out how you can use database roles in your environment.

  [more…]

• Using Server Roles for Server Level Security Management

  

  2014-01-04 - General, Security

  Server roles simplify management of server level permissions. Before SQL Server 2012 we were confined to 9 fixed server roles. However, now we are able to create user-defined server roles and grant any server level permission to them. Read on to find out more…

  [more…]

• The Principle of Least Privilege

  

  2014-01-01 - General, Security

  The Principle of Least Privilege tells us to always grant only the minimal set of permissions to any user. Read on to see what this means in the context of SQL Server.

  [more…]

• The TRUSTWORTHY Database Property Explained – Part 2

  

  2013-06-18 - General, Security, Trustworthy

  Why is the TRUSTWORTHY db option so dangerous? This second post on that topic shows how that “trust” can be misused to elevate a login to be a sysadmin.

  [more…]

• How to rollback in procedures

  

  2012-01-23 - General

  Transaction Management The question where in the call stack a transaction should be managed, is similar to the one where errors should be handled. There are several strong reasons to push the transaction management as high up the stack as [more…]