Category: General

• Bulk Changed Map (BCM): The Minimally Logged Advantage

  

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

  The Bulk-Logged recovery mode can provide a performance gain for your database. Check out how SQL Server uses the Bulk Changed Map to make this possible.

  [more…]

• CERTPROPERTY – Digging Deeper into SQL Server Certificates

  

  2014-05-12 - Cryptography, General, Security

  Discover how to read the properties of a specific SQL Server certificate using its certificate_id and the built-in CERTPROPERTY function.

  [more…]

• How to Drop a Certificate Conditionally with CERT_ID

  

  2014-05-09 - Cryptography, General, Security

  Discover how CERT_ID can be used to conditionally execute statements (like a drop or create) based on the existence of a specific certificate, since it returns a noon-NULL value only if the certificate exists.

  [more…]

• Differential Changed Map (DCM): How SQL Server Tracks Changed Pages

  

  2014-05-07 - Backup, General, Series, SQL Server Internals, Storage Wednesday

  SQL Server uses the Differential Changed Map to determine, which pages changed since the last full backup. Read on to find out how the DCM is working.

  [more…]

• How to Restore a Certificate in SQL Server

  

  2014-05-05 - Cryptography, General, Security

  Do you know how to restore certificates in SQL Server? Read on to find out how, even though there is no RESTORE CERTIFICATE statement.

  [more…]