In this article, we will demonstrate T-SQL metadata functions available in the SQL Server.
Read more »Gauri Mahajan
Gauri Mahajan
She has a deep experience in designing data and analytics solutions and ensuring its stability, reliability, and performance. She is also certified in SQL Server and have passed certifications like 70-463: Implementing Data Warehouses with Microsoft SQL Server.
View all posts by Gauri Mahajan
Latest posts by Gauri Mahajan (see all)
- A complete guide to T-SQL Metadata Functions in SQL Server - July 30, 2019
- Understanding the SQL Decimal data type - July 15, 2019
- A step-by-step walkthrough of SQL Inner Join - June 21, 2019

Understanding the SQL Decimal data type
July 15, 2019This article aims to walk you through the SQL Decimal data type and its usage with various examples. We will also see how we can exercise this data type in SQL Server to help make SQL developer’s job easier.
Read more »
A step-by-step walkthrough of SQL Inner Join
June 21, 2019Organizations are generating and analyzing unmatched volumes of data with each passing minute. In this article, we will demonstrate how we can employ SQL Inner Join to query and access data from multiple tables that store this incessantly growing data in the SQL databases.

Vulnerability Assessment and Advanced Threat Protection in Azure SQL Database
June 17, 2019In today’s time where data breaches are highly expected to happen, there is a high need to ensure sensitive data in the Azure SQL databases is secured and which is why data security implementation is gaining momentum across each community. We covered one of the features of Advanced Data Security here in Advanced Data Security in Azure SQL Database – Data Discovery & Classification. Let’s dive further into the other two features that Azure SQL offers with this capability in this article.
Read more »
Advanced Data Security in Azure SQL Database – Data Discovery & Classification
June 17, 2019Azure SQL supports in building and managing wide range of SQL databases, tools, frameworks etc. on the cloud. Organizations are drifting towards Azure SQL because of its obvious advantages over on-premises SQL Server and are generating, exchanging and storing data at an exponential rate on Azure. It becomes essential to safeguard, monitor our sensitive data and get alerts on anomalous activities else companies may come under fire for letting data leak and hacked.
Read more »
SQL varchar data type deep dive
May 29, 2019In this article we’ll review the SQL varchar data type including a basic definition and overview, differences from varchar(n), UTF-8 support, Collation, performance considerations and more.