Author Archives: Jayanth Kurup

About Jayanth Kurup

This post was written by Jayanth Kurup. A Microsoft SQL Server Consultant and Trainer based out of Bangalore, India. Jayanth has been working on MS SQL Server for over 15 years. He is a performance tuning and Business Intelligence expert. Having worked with companies like Microsoft, DELL, Wells Fargo, Thomson Reuters and many other fortune 100 companies. Some other technologies Jayanth works on include Microsoft Azure, PowerBI, Python and AWS. When he isn’t consulting or training, Jayanth like to travel, paint and read. He is also very active in social causes and the founder of Enabled Business Solutions. Visit his company by clicking the link in the menu or email him directly.

How to analyze a Presidential debate?

By | October 18, 2020

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… Read More »

Azure Data Sync Issues

By | October 2, 2020

  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… Read More »

Securing SQL Server – Dynamic Data Masking

By | September 22, 2020

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… Read More »

Microsoft SQL Server Security: – Defense in Depth Series

By | September 8, 2020

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 The series covers the following concepts Principle of least privilegesDynamic Data MaskingRow Level SecurityAlways EncryptedTransparent Data EncryptionBackup… Read More »

Microsoft SQL Server Security: – Defense in Depth Series

By | September 8, 2020

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 The series covers the following concepts Principle of least privilegesDynamic Data MaskingRow Level SecurityAlways EncryptedTransparent Data EncryptionBackup… Read More »

FREE PowerBI session – Batch 2

By | August 27, 2020

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… Read More »

FREE PowerBI session – Batch 2

By | August 27, 2020

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… Read More »