Securing SQL Server: – Data Classification and Vulnerability Assessment

  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 SQL 2019 or SSMS specifically makes the task much easier. We cover how to automatically and manually classify sensitive information, we then explore how to audit SQL…

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 it would have been to me to see the screenshot below. Apparently I have been a target for a number of attacks from Pakistan, Indonesia and Vietnam….

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 good license was wasted. I figured I would just use Hyper-V going forward only to realize that Hyper V wasn’t supported on Windows 10 Home edition. For…

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 data masking was introduced in Microsoft SQL server version 2016. However for older versions of SQL server there are primarily just a few variations of same approach…

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 kind of activity using a different approach which will be detailed below. The intention of this post is not to support or negate any candidate. It is…

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, LDF and NDF. It doesn’t prevent the DBA from viewing the data. But it does protect the database from being restored on an unauthorized server where other…

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 works great when you have a fairly simple table structure and no transformations before the data is ready to load to the destination. Recently we came…

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 to grant these permissions and also how once granted, bad coding practices and carelessness can undo all the hard work in one swoop. This is one of…

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 other features like encryption. It adds a layer of masking on the final output and as such can be bypassed easily by rewriting the query as demonstrated…

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. When and how to use them and certain pitfalls. https://www.youtube.com/watch?v=aITXHwWHXJw&feature=youtu.be Defense in DepthThe series covers the following concepts Principle of least privilegesDynamic Data MaskingRow Level SecurityAlways EncryptedTransparent…

FREE PowerBI session – Batch 2

It’s time for the next batch of PowerBI Sessions. This is a 3 hour free PowerBI Session for those whose careers have been affected by #Covid or those who feel their careers have slowed down in recent years and would like a relevant in demand skill. In this session we will be creating the below…

Introduction to PowerBI

The Covid 19 situation has been tough for pretty much everyone and a lot of careers have come to an abrupt stop. If you feel your career opportunities are hampered by the lack of a particular skill I would like to help by providing a 3 hour introductory course to PowerBI. Why PowerBI? It’s almost…

Introduction to PowerBI

The Covid 19 situation has been tough for pretty much everyone and a lot of careers have come to an abrupt stop. If you feel your career opportunities are hampered by the lack of a particular skill I would like to help by providing a 3 hour introductory course to PowerBI. Why PowerBI? It’s almost…