Category: Series

• DENY vs. REVOKE – Part 5 – Durability

  

  2014-02-14 - DENY vs. REVOKE, General, Security, Series

  A DENY is a durable permission, similar to a GRANT. Find out what that means and how it affects your SQL Server permissions management.

  [more…]

• DENY vs. REVOKE – Part 4 – Hierarchies of Privileges

  

  2014-02-13 - DENY vs. REVOKE, General, Security, Series

  This fourth part of the short series about DENY vs. REVOKE shows that a DENY on the hierarchy of privileges can be used to fine tune permission management. Read on to get all the details.

  [more…]

• The Page – How SQL Server Stores Data

  

  2014-02-12 - General, Series, SQL Server Internals, Storage Wednesday

  SQL Server organizes all data into virtual containers called pages. The DBCC PAGE command can be used to explore these pages. This post starts a series about pages in SQL Server.

  [more…]

• DENY vs. REVOKE – Part 3 – Hierarchies of Securables

  

  2014-02-10 - DENY vs. REVOKE, General, Security, Series

  DENY can be used to fine tune permission management in hierarchies of securables. A common securable hierarchy is table, schema, database, server. Read on to see how a DENY on one level of such a hierarchy can override a GRANT on another level.

  [more…]

• DENY vs. REVOKE – Part 2 – Hierarchies of Principals

  

  2014-02-09 - DENY vs. REVOKE, General, Security, Series

  REVOKE and DENY are similar at first glance. However, DENY can be very powerful when used in the context of security principal hierarchies. Read on to get all the details.

  [more…]