A big challenge with implementing security is just being able to keep track of the different tables and columns where the data is located. This features in […]
Securing Azure AD using the free stuff
One of the first things I did in 2021 was to log into Azure portal and check my Active Directory. You can imagine how much of a shock […]
How to enable Hyper-V on Windows 10 Home edition OS
One the biggest issues I had with Windows 10 was when it said I had to uninstall VMware since it wasn’t compatible with the OS. Thus a perfectly […]
Masking Data prior to SQL 2016
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 […]
How to analyze a Presidential debate?
During the last US presidential election we extracted some important critical information from the presidential debate to help profile the candidates. This year we are performing the same […]
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, […]
Azure Data Sync Issues
Azure data sync is a great tool for those people looking for a quick and easy way to move data from on premise systems to the cloud. It […]
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 […]