I was recently asked by a friend of mine what would be the best way to mask data in SQL Server. Now you may be aware that dynamic […]
Securing SQL Server: – Transparent Data Encryption -TDE
https://youtu.be/iDfH7dKEFto In this video we cover TDE or transparent data encryption. It is a feature that allows the DBA to protect files in the disk such as MDF, […]
Securing SQL Server – Principal of least Privileges
In this second video of the series we cover “Principle of least privileges”. It means we grant only the minimum required permission to any account. We explore how […]
Securing SQL Server – Dynamic Data Masking
In this video we cover the feature Dynamic Data Masking. While technically a security feature DDM can be easily bypassed and therefore is often used in conjunction with […]
Script for Backup Encryption
Microsoft SQL Server Security: – Defense in Depth Series
In this series we cover all the different ways you can protect your Microsoft SQL Server database from attacks. We cover the methodology being used to secure databases. […]
What does a brute force attack look like?
Ever wondered if your server is being targeted for a brute force attack? What does it look like? How to prevent it? What is a brute force attack? […]
Backup and restore of encryption keys and restoring
USE master; /************************************************************* CREATE YOUR MASTER KEY AND YOUR CERTIFICATE FOR TDE AND ALL OTHER TYPES OF ENCRYPTION *************************************************************/ OPEN MASTER KEY DECRYPTION BY PASSWORD = ‘Isthis@securePa$word?’; BACKUP […]
Changing Default port number for SQL on Windows/Linux Install
Changing the default port number of a SQL installation is one of the most basic post install steps performed. It is mainly used to make intrusion more difficult […]
The-certificate-chain-was-issued-by-an-authority-that-is-not-trusted-when-conn -FIXED
Interesting little problem came up today when migrating a database from Azure SQL database to local server. The connections sting in the web app had the following property […]