This article will show how to use Azure SQL Database to classify and tag data with sensitivity labels to generate reports out of it.
Read more »Gauri Mahajan
Gauri is a SQL Server Professional and has 6+ years experience of working with global multinational consulting and technology organizations. She is very passionate about working on SQL Server topics like Azure SQL Database, SQL Server Reporting Services, R, Python, Power BI, Database engine, etc. She has years of experience in technical documentation and is fond of technology authoring.
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
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)
- Oracle Substring function overview with examples - June 19, 2024
- Introduction to the SQL Standard Deviation function - April 21, 2023
- A quick overview of MySQL foreign key with examples - February 7, 2023
Dynamic Data Masking in Azure Synapse Analytics
April 23, 2021This article will take you through the process to apply Dynamic Data Masking on the dedicated SQL pool of Azure Synapse Analytics.
Read more »
Sourcing data from Azure SQL Database in Azure Machine Learning
April 19, 2021In this article, we will show how to source data from Azure SQL Database to use in a Machine Learning workflow.
Read more »
Export compressed data from Azure SQL Database
April 12, 2021This article will walk you through the way to export data out of Azure SQL Databases in a compressed format using Azure Data Factory.
Read more »
Visualizing data with Azure Data Explorer dashboards
April 8, 2021This article will help you understand the process of author dashboards using Azure Data Explorer to visualize data hosted in the clusters.
Read more »
Migrating homogeneous and heterogeneous databases to Azure SQL Database
March 29, 2021In this article, we will look at how we can use the Azure Database Migration Service to migrate to Azure SQL Database.
Read more »
Ingesting data into Azure Synapse Analytics using PolyBase
March 19, 2021In this article, we will learn how to ingest data into Azure Synapse Analytics with a focus on using PolyBase to load the data.
Read more »
Consuming an Azure Data Share of Azure SQL Database
March 16, 2021This article will help you understand the process to accept an incoming or received data share of Azure SQL Database and integrate it with the desired data repository to start consuming it.
Read more »
Creating Azure Data Shares for Azure SQL Database
March 4, 2021This article will walk you through the process of creating Azure Data Shares for an Azure SQL Database.
Read more »
Explore Azure Analysis Services Model and Data
February 4, 2021This article will walk you through how you can deploy a sample model on Azure Analysis Services and you will also learn the way to consume it using different tools.
Read more »
Getting started with Azure Analysis Services
January 13, 2021This article will describe how to get started with Azure Analysis Services and help you understand the configuration and pricing options to create our first Analysis Services instance.
Read more »
Connect Azure Databricks data to Power BI Desktop
June 1, 2020This article is next in the Azure Databricks series, where we will learn how to connect data in Azure Databricks to the Power BI Desktop. We will also talk briefly about visualizations in the Databricks service.
Read more »
Load data into Azure SQL Database from Azure Databricks
April 30, 2020In this article, we will learn how we can load data into Azure SQL Database from Azure Databricks using Scala and Python notebooks.
Read more »
Accessing Azure Blob Storage from Azure Databricks
April 2, 2020We introduced Azure Databricks, how it is created and some of its important components in my previous article here. We will look at how we can work with Azure Blob Storage in Azure Databricks in this article.
Read more »
A beginner’s guide to Azure Databricks
March 18, 2020This article serves as a complete guide to Azure Databricks for the beginners. Here, you will walk through the basics of Databricks in Azure, how to create it on the Azure portal and various components & internals related to it.
Read more »
SQL Server Query Store options in SSMS 18.4
March 4, 2020In this article, we will run through the new options added in the Query Store with SSMS v18.4.
Read more »
Azure Data Explorer for beginners
February 27, 2020This article discusses what exactly an Azure Data Explorer is and its important features. We will also walk through the Kusto query language and explore a sample data in the Data Explorer in Azure.
Read more »
Getting started with Azure Data Catalog
February 20, 2020This article talks about Azure Data Catalog and how data professionals can use it to locate, understand and consume data sources.
Read more »
How to recover accidental deletes in Azure Blob Storage
February 13, 2020This article explains one of the important data protection features in Azure Blob Storage – Soft Delete, which helps to recover data that is accidentally deleted in blobs or blob snapshots.
Read more »
A complete guide to T-SQL Metadata Functions in SQL Server
July 30, 2019In this article, we will demonstrate T-SQL metadata functions available in the SQL Server.
Read more »
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.