Category: Infosec

UBS Forums – CISO Round Table – SOC Modernization

Looking forward to speaking and participating with esteemed CISOs in the community.

Please join us and register

Threat Hunting on SQL Server with Azure Sentinel

For years Microsoft SQL Server has served as a backbone of critical applications for enterprises. Due to the nature of critical data stored on the SQL Server databases, it has always been a point of Interest for internal or external adversaries and one of the primary targets for exploitation.

 It is important to monitor all your SQL database instances and servers for any sign of threats.

Last week I posted a detailed blog post on Monitoring SQL Server with Azure Sentinel on Microsoft Azure Sentinel Official Blog. The blog talks about how to ingest logs from SQL Servers running on VMs, Parse the logs in readable format and then run various hunting queries and create alerts

You can read the detailed post here.

The Parser and hunting queries are also uploaded to Azure Sentinel Github repo.

My Session at Economic Times–Microsoft Security 360 Conclave and Microsoft organized a one-day conclave to enable CISOs enhance their security stance in the era of flux and transformation. The conclave served as a platform for top CISOs and security experts to deliberate on the latest opportunities, challenges and trends in the enterprise cybersecurity space.

It was really speaking at this event on “ Top Security Myth busters” which was all about various myths within the security community and in organizations for their internal cyber security and compare them with things happening in reality. This session also had some demos on some of Microsoft’s investments in threat detection capabilities and remediation accross Email Security, Endpoint Security and Identity protection.

If you happened to attend this event in person,  I really hope you liked it.

If you couldn’t attend it in person, the sessions were streamed LIVE and now available On-Demand below.

My Session starts at ~ 4:28:00



My Session at Digital Governance Tech Summit 2019, New Delhi – Security Considerations for Moving to Cloud.

Digital tech

I’ll be speaking at Digital Governance Tech Summit 2019, New Delhi on

Security considerations while moving to the cloud” –  1615 Hrs, 27th August 2019

In this session, learn about various security considerations organizations to make while moving to cloud, shared responsibilities between cloud provider and end customers.

If you happen to be participating in this conference, please do stop by and say hi.

There are other great sessions in this conference presented by elite Microsoft speakers and other industry veterans like Keynote by Ananth Maheshwari, President Microsoft India and Amitabh Kant, CEO, Niti Aayog, Govt of India.

You can find the list of entire list of sessions and tracks here

I look forward to have some of you in the session and discuss more on your secure cloud journey.



Best Practices in configuring Office 365 Anti Phishing Policy

Office 365 Advanced Threat Protection enables additional layer of protection against malicious URLs, Malicious Attachments and Phishing campaigns.

In my previous posts we talked about these configurations, please click on the hyperlinks below to see those posts.

1. Best practices in configuring Office 365 Safe Attachments

2. Best Practices in configuring Office 365 Safe Links.

Today we’ll take a look at anti phishing policies which can be configured in Office 365 for protection against

  • 1. User Impersonation
  • 2. Domain Impersonation
  • 3. Domain Spoofing

User Impersonation : User Impersonation configuration allows organization to list down their top executives like CEO, CFO, Directors etc and any emails coming with the exact same display name and going to users will be quarantined/delivered to Junk as per the configuration.

Domain Impersonation : Domain Impersonation configuration protects against emails coming with similar typosquatted domains like yours. For eg. your organizations domain is and attackers may send emails after registering similar looking domains like, etc.

Domain Spoofing :  Domain spoofing configuration enables domain authentication like SPF, DKIM, DMARC to be enforced validating the origin of the emails as per the from address and block/quarantine/junk those emails which fails authentication.

I have created this video tutorial of Step by Step tutorial of the recommended configurations of Anti Phishing Policies in Office 365 Advanced Threat Protection.

Hope you like the videos, please do subscribe to the channel to be updated with future tutorials.


Best Practices in configuring ATP Safe Link Policies in Office 365

One of the major attack vector used by threat actors are sending emails with malicious URLs. These emails without any malicious attachments usually has luring text which encourages users to click on a link to take any action and then take them to a Phishing URL or a webpage with malicious content.

For E.g. the email below, which looks like it has come from Microsoft to users and asking users to click on a URL which would lead to


Office 365 Advanced Threat Protection enables Safe Link policy which protects users at the time of click by verifying the URL against threat intelligence for any phishing page or malicious content.

Please watch this video on how to configure Office 365 Safe Links with recommended configurations.

if you want to see a quick demo on how Office 365 Safe works, checkout the following video.


Best Practices in Configuring Office 365 ATP Safe Attachments

Security and End User Experience don’t often go hand in hand, the art is to find the right balance.

I often get asked how should I configure my Office 365 Advanced Threat Protection Safe Attachments policy to achieve maximum protection against modern day threats such as Zero Day Exploits, Macro Based trojans and other specially crafted malicious attachment.

In this video, we’ll go through some of the recommendations on configuring ATP Safe Attachment policy in Office 365.

Domain Spoofing – Making things difficult for an attacker

Phishing emails comes in many shapes and form. here are various forms of phishing, organizations are currently struggling with :

Types of Phishing

1. Domain Spoofing – In this type of phishing, the email’s from address indicates it has come from reputated domains like Microsoft, Google, Paypal etc and often organization’s own domain but it really has not originated from there servers. Attackers often spoof the domain to make it look like a legitimate emails from these company’s and asking recipients to do a task like verify their account to harvest credential, download and install a file which is malicious, or visit a malicious webpage.

2. Domain Impersonation – In this type of phishing, the attackers registers a similar looking domain as your organization’s or major brands Microsoft etc, For Eg If your Organization’s domain is, attackers would register domains like, etc and then sends out emails from these domains to your users asking them to carry out a transaction, click on URLs or open an attachment. If users are not paying attention they would never be able to differentiate between original domain name of the organization and “Typosquatted” domain attacker is sending these email from.

3. User Impersonation – In this type of phishing, attackers uses the name of top executive’s names like your CEO, Director, CFO etc and then send email to their subordinates or to the other group of employees and then ask them to carry out a high value activity. These executive’s name usually have high authority which are often not questioned and hence employees falls for it without verifying the identity or the intent of the email.

While this is not a exhaustive list, attackers also use combinations of above techniques to increase their chances of a successful exploitation.

In this post, we’ll talk about Domain Spoofing in details”:

Spoofing a domain and its reputation have been into existence for ages and with the advent of various tools and scripts it has got a lot easier to carry out this attack.




Protection against Spoofed Emails

Create a SPF record for your Organization : –

SPF or Sender Policy Framework is a authentication technique to validate if the email is actually originated from designated server of the domain or not and hence helps in detecting spoofed and forged emails.

If you are an Office 365 Email customers, you can follow these steps to create your SPF Record.

DMARC and DKIM are additional domain authentication techniques you should also look at.

This will ensure if any attackers tries to spoof your domain to send emails to your organization or to others external parties will have their domain authentication failed.


If you are an Office 365 Exchange Online Customer, Inbuilt Exchange Online Protection by default protects from domain spoofing by redirecting all the emails to Junk Mailbox folder if the SPF or domain authentication is failed by marking them as High Spam or Spam.

You should definitely check your Anti Spam settings to see how you want Spam and High Spam emails to be treated,


SPAM Settings





Detecting a Spoofed email

Detecting a spoofed email is never so easy as the from address will have the exact domain name as you’d like it to have. So if an attacker is trying to spoof your own organization’s domain, your users will actually see the correct domain name in the ‘From’ address.

if you take a look at following example of an Spoofed email, the ‘from’ domain is actually showing as which is the legitimate domain of this Organization. So its not that easy to differentiate unless you are ready to dive deep into Header Analysis

Spoofed Email

Yes, you may find additional clue in the email which might seem odd and can help figure it out, you can read my previous post on finding clues for Phishing.

So lets take a look at what are the things you should look at in the email header which can help identify that this is a spoofed email.

Follow this to pull out the message headers if you are using Outlook Client.

If you are using OWA, click on the drop down menu on the right hand side and click on message details.


You may copy the message headers and then paste it to the Microsoft Message Header Analysis tool and hit analyze.

Now lets see what things you should look at:

You should find that domain Authentication like SPF = FAIL.  We’ll learn more about SPF later in this post.

Since the email is not originated from the server of the domain which it says its from, the SPF will be failed.

Also Auth AS value should be showing Anonymous. which means the email is not authenticated with a credentials.

if this email actually had been sent from your domain, the Auth As value should be “Authenticated”

Auth As

Create an Warning Message for all External Email – Mail Tips

Consider creating a caution message on the top of all the emails originating from external servers,  You can use Exchange Online mail flow rules to create these custom notifications, More info on creating disclaimers here

Mail tip

Legitimate Spoofing

Legitimate Spoofing” ? Is that even a thing? why would a spoofing be legitimate?

Well, Yes, there are emails which could be SPF failed but still be legitimate,

No SPF Records :  If you are getting an email from a organizations who have not configured and published their SPF records with their domain registrar, there is no way to authenticate them.

Cloud Hosted Email Service Provider :  If your sender’s email service is hosted on a shared tenant with a cloud service provider, there are chances that the provider cannot provide individual server details for SPF configuration for each and every email tenant.

Marketing and Newsletters : Some organizations outsources their marketing email campaign to third party companies who sends emails on behalf of their clients and hence those emails would look like as Spoof however genuine.

Spoof Intelligence to rescue :

Office 365 Customers can now take a look at the Spoof Intelligence report to see the domain pairs who are sending emails to your organizations and their domain authentication is getting failed. You also have the option to configure if you are okay to have their emails coming in while their domain authentication has failed.

Spoof Intelligence

So if you do see a domain here which is sending legitimate emails but getting failed authentication, you can come here and mark them as “Allowed to Spoof” which will ensure optimized mail flow from them.

I hope this post helps un understanding domain Spoofing and how can we make it harder for attackers to bypass the protection.

In my next post, we’ll look at a common configuration mistake which lets these Spoofed emails coming in and getting delivered, specially if the attacker is spoofing your own domain.



My Article on CIO Review Magazine : Stay Updated, Stay Protected

(Post migrated from

In the increasingly dynamic world of cyber threats where threat landscape is changing by seconds, staying updated breaks the ROI of the attackers.

If you are a reader of CIO review magazine hope you’ll like my this article published in the October 2017 edition.


You can read the full CIO review Digital Magazine here with some other great articles.



What is Windows Defender ATP ?

I get to hear a lot of confusion between Windows Defender and Windows Defender ATP and people don’t often get the difference between the two,

lets understand the difference.

Windows Defender is an Anti malware / Anti Virus solution part of Windows 10 itself, it helps protect you from known malware/Viruses which has already been discovered and there is a definition available for it. So think of this like similar Anti Virus capability provided by known vendors like McAfee, Symantec etc.

Besides protecting you from known malware, Windows Defender also has inbuilt machine learning and heuristics to detect malware in realtime based on behaviour analysis. If you want to see a glimpse of what Defender AV can do in real time, watch this video below.


Windows Defender ATP on the other hand is an Endpoint detection and Response ( EDR) solution from Microsoft which enables identifying and detecting suspicious and malicious activities on the endpoint PCs and help you take remedial actions for containment.

So if there is a persistent attack scenario where attackers are doing initial recon and lateral movement activity to find out critical and high value assets for them to compromise, this activity gets detected in the Defender ATP console and helps organizations to confine it before the attackers are able to compromise your high value assets.

Here is a quick overview of Windows Defender ATP and some of the example activities of compromise it can help detect and remediate.

Defender ATP can run irrespective of the fact what Anti Malware you are using.

Hope that clears out the confusion.

Do subscribe to my channel on YouTube for more informative demos on InfoSec.