Restoring AdventureWorks2014 In order to restore the database, we'll need the following tokens: - A certificate file - A private key -...

TDE Encryption on AdventureWorks2014 This how-to guide covers how to protect a database by using transparent data encryption (TDE), and...

1. Introduction The purpose of this document is to explain the importance of having a database testing strategy. Database testing is a...

1. Problem The problem that our business is facing now is that we lack documentation of our datasets for the reports. Since we’re working...

1. Introduction This is a how to guide on setting up a SQL Server Audit Log. It’s a fairly new feature introduced in SQL Server version...