SQL SharkJan 12, 20203 min readRestoring a TDE Encrypted DatabaseRestoring AdventureWorks2014 In order to restore the database, we'll need the following tokens: - A certificate file - A private key -...
SQL SharkJan 12, 20204 min readTDE Encrypting a Database TDE Encryption on AdventureWorks2014 This how-to guide covers how to protect a database by using transparent data encryption (TDE), and...
SQL SharkOct 17, 20197 min readDatabase Testing Strategy1. Introduction The purpose of this document is to explain the importance of having a database testing strategy. Database testing is a...
SQL SharkSep 28, 20194 min readExport and Archive SQL Datasets from the Reporting Server1. Problem The problem that our business is facing now is that we lack documentation of our datasets for the reports. Since we’re working...
SQL SharkSep 26, 20193 min readSQL Server Audit Log1. 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...