Tag: SQL Server

• The Ownership Chain – How the Securable Owner affects Permission Enforcement in SQL Server

  

  2014-03-14 - General, Security

  The ownership chain enables us to setup guarded access in SQL Server. Guarded access means to grant securable access only through a procedure or view. That module can then be used to enforce additional security requirements. Read on to see how the ownership chain makes this possible.

  [more…]

• The Row Header (A Storage Wednesday Post)

  

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

  The row header contains metadata describing the row. It contains information about the row type, the column count and a NULL-bitmap. Read on to get all the details.

  [more…]

• An implicit user creation has failed.

  

  2014-03-10 - General, Security, Security Pitfalls

  The error message “An implicit user creation has failed.” indicates that SQL Server tried to create a user automatically and failed. Read on to see when and why this happens.

  [more…]

• CONTROL SERVER vs. sysadmin – Differences when Creating a Schema

  

  2014-03-07 - CONTROL SERVER vs. sysadmin, General, Security, Security Pitfalls

  The CONTROL SERVER privilege and a membership in sysadmin are supposed to be equivalent. However, there are substantial differences, e.g. securable ownership. Read on to see what happens when a schema is created by a login with CONTROL SERVER permissions.

  [more…]

• Finding table pages with DBCC IND (A Storage Wednesday Post)

  

  2014-03-05 - General, Series, SQL Server Internals, Storage Wednesday

  Are you trying to use DBCC PAGE and need a way to find all pages that belong to a table? That is exactly what DBCC IND can help with. Read on to get all the details.

  [more…]