Introduction
You might be thinking why do you want to create Azure SQL Database and what are the best configurations. This article will provide you with the basic configurations of the Azure SQL Database.
Read more »
SQL Azure
Building U-SQL jobs locally for Azure Data Lake Analytics
December 23, 2020This article will help you learn to develop U-SQL jobs locally, which once ready, can be deployed on Azure Data Lake Analytics service on the Azure cloud.
Read more »
Deploying U-SQL jobs on Azure Data Lake Analytics
December 23, 2020In this article, we will learn how to execute U-SQL jobs that have been developed or tested locally, to the production environment from a local machine.
Read more »
How to track data changes on Azure SQL Database
December 21, 2020In this article, we will guide you through tracking data changes on the Azure SQL database and introduce common use case scenarios and learn how to get the most out of system-versioned tables.
Read more »
Developing U-SQL jobs on Azure Data Lake Analytics
December 21, 2020In this article, we will learn how to develop U-SQL jobs on Azure Data Lake Analytics to process data stored in Data Lake Storage.
Read more »
Getting started with Azure Data Lake Analytics
December 15, 2020This article aims to help you understand the concept of Azure Data Lake Analytics capability offered by Microsoft in the Azure cloud.
Read more »
Quick start guide to Geo-restore in Azure SQL Database
November 24, 2020Azure SQL Database—a cloud-based service model provides a platform to back up the data and ensure to keep the business up-and-running even after the disaster. The data is vital and backup of the data revolves around the process of backup, restoration, recovery, Business-Continuity-Plans (BCP), and disaster recovery (DR). In this article, we will learn:
Read more »
Import data into Azure SQL database from AWS Redshift
November 10, 2020In this article, we will learn an approach to source data from AWS Redshift and populate it in the Azure SQL database, where this data can be used with other data on the SQL Server for desired purposes.
Read more »
Export data from Azure SQL Database to Azure Data Lake Storage
November 4, 2020In this article, you will learn how to export data from Azure SQL Database to Azure Data Lake Storage using Azure Data Factory.
Read more »
Azure SQL Database vs SQL Server on Azure VMs
October 20, 2020The recent trend proves that the adoption of the Cloud has much greater significance and importance in modernizing IT. If you are working on migrating the on-premises SQL Server to Microsoft Azure cloud, you need to have a better understanding of the key differences between Azure SQL databases and SQL Server on Azure VMs and options that work best for you.
Read more »
Populate Azure SQL Database from Azure Blob Storage using Azure Data Factory
October 20, 2020This article will talk about loading data into Azure SQL databases from Azure Blob Storage with the help of Azure Data Factory.
Read more »
Understanding Azure Synapse Analytics (formerly SQL DW)
October 16, 2020This article will discuss one of the powerful analytics services in Azure – Azure Synapse Analytics, along with its components, features, security, and more.
Read more »
How to clone an Azure SQL Database
October 12, 2020In this article, we will learn cloning an Azure SQL Database.
Read more »
Create a Serverless Azure SQL Database
October 6, 2020In this article, we will take a look at how to create a serverless Azure SQL database.
Read more »
Create an Azure SQL Database with built-in sample data
September 30, 2020In this article, we will learn to create an Azure SQL Database with built-in sample data.
Read more »
Four different methods to copy your Azure SQL database
September 30, 2020In this article, we will see different methods to copy the Azure SQL database. With the advent of all the business dynamics available in today’s IT industry, there is a huge paradigm shift towards automation. You need to constantly innovate and keep moving forward.
Read more »
Getting started with Azure SQL Database using Azure CLI
September 9, 2020There are plenty of tools out in the market to manage Azure Cloud platform— Azure Management Web portal, Visual Studio, Visual Studio Code with Azure Studio SDK, Azure PowerShell, Azure CLI, and Azure Cloud Shell.
Read more »
Getting started with Azure SQL Analytics
July 29, 2020Using Azure SQL Analytics, you will rediscover the new ways to manage the Azure SQL Database. Microsoft is driving an intelligent platform to provide seamless collaboration for all their end users to business analysts, by building an effective Log Analytics stack and intelligent insight through dashboards.
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 »
Build an ASP.NET app with Azure SQL Database
May 6, 2020In this article, you will learn about Azure SQL Database and its uses. Then the article splits into two sets of tutorials. The first part will show you how to create a single database in Azure SQL Database. The second tutorial will show you how to build an ASP.NET app in Azure SQL Database.
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 »
How to access data from Azure Blob Storage using Power BI
March 17, 2020In this article, I am going to explain how we can access the data from the Azure Blob Storage using Power BI. To do that, we are going to use the below tools:
- Azure BLOB Storage account: We have uploaded the source CSV file to it
- Power Query editor: To choose the data that we want to load in the Power BI report
- Power BI Desktop: To view the data imported from the CSV file
How to export data from Excel into multiple tables in Azure SQL Database using SSIS
March 3, 2020In this article, I am going to explain how we can split the data within the excel file and upload it to the tables created on the Azure SQL database.
Read more »
How to migrate SQL data to Azure Cosmos DB
February 27, 2020In this article, I have explained the step by step process of migrating data from SQL Server to Azure Cosmos database. To perform database migration, we will proceed in the following manner:
Read more »