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 »
SQL Azure
Azure Automation: Export Azure SQL Database to Blob Storage in a BACPAC file
May 5, 2021Azure SQL Database supports exporting schema and data in a compressed format BACPAC. We can store this BACPAC file into an Azure storage account. Later, this BACPAC file can help restore the Azure SQL database, and Azure managed SQL instance or on-premises SQL Server.
Read more »
How to use SQL Server DACPAC extensions in Azure Data Studio
April 29, 2021This article is focused on installing and using SQL Server DACPAC Extension in Azure Data Studio.
Read more »
Azure Automation: Create database copies of Azure SQL Database
April 27, 2021This article will explore Azure automation for creating a new Azure SQL Database copy.
Read more »
Azure Automation: Automate Azure SQL Database indexes and statistics maintenance
April 27, 2021Azure SQL Database is a PaaS solution for migrating your on-premises databases to the Azure cloud infrastructure. It is a managed service and Azure manages the infrastructure, database availability, backup restore, and compute resources.
Read more »
Lift and Shift SSIS packages using Azure Data Factory V2
April 23, 2021This article will explore the process for Lift and Shift SSIS packages to Azure using Azure Data Factory V2.
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 »
Using Azure Purview to analyze Metadata Insights
April 5, 2021In this article, we will learn how to explore the metadata registered in Azure Purview as well as learn how to analyze the metadata insights using the Purview Studio tool.
Read more »
Cataloging metadata with Azure Purview
March 31, 2021In this article, we will learn how to catalog metadata using the Azure Purview service.
Read more »
Getting started with Azure Purview Studio
March 29, 2021This article will get you started with Azure Purview Studio and the different facets associated with this tool.
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 »
Configure long-term backup retention for Azure SQL database
March 25, 2021This article configures a long-term backup retention policy for Azure SQL Database.
Read more »
Create a transactionally consistent copy of Azure SQL database
March 22, 2021In this article, we implement a copy of the Azure SQL database using both Azure Web Portal and Azure CLI.
Read more »
Getting started with Azure Purview for Data Catalog and Governance
March 16, 2021This article will show different features of Azure Purview as well as describe how to get started with this service on Azure.
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 »
Move local SSIS packages to Azure Data Factory
March 11, 2021In this article, we will learn how to deploy SSIS packages which are typically built on developer workstations, to Azure Data Factory using Visual Studio and Data Tools.
Read more »
Copy data into Azure Synapse Analytics using the COPY command
March 8, 2021In this article, we will learn how to copy data from an external data source using the COPY command into a dedicated SQL pool of Azure Synapse Analytics.
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 »
Restore dedicated SQL pools in Azure Synapse Analytics
March 2, 2021This article will walk you through the process of restoring dedicated SQL pools in Azure Synapse Analytics.
Read more »
Analyze Azure Cosmos DB data using Azure Synapse Analytics
February 24, 2021This article will help you understand how to analyze Azure Cosmos DB data using Azure Synapse Analytics.
Read more »
Deploy Azure Data Lake Analytics database using the U-SQL scripts
February 23, 2021In this 3rd article of the Azure Data Lake Analytics series, we will explore deploying a database, tables using U-SQL scripts.
Read more »
Elastic Jobs in Azure SQL Database
February 18, 2021Introduction
I have dedicated this article to the topic of Elastic Jobs in Azure SQL Database which is in Public Review. This feature allows you to run scheduled tasks in your Azure SQL Databases. This is similar to SQL Server Agent you have in the On-prem SQL Server versions. However, in Elastic Jobs, you can execute the scheduled tasks in multiple Azure SQL Servers and multiple Databases which is an added advantage when considering the features of SQL Server Agent. Further, this execution performs parallelly.
Read more »
Join database tables using U-SQL scripts for Azure Data Lake Analytics
February 17, 2021In this article, we will explore joining database tables using U-SQL scripts for Azure Data Lake Analytics.
Read more »