This article will discuss one of the powerful analytics services in Azure – Azure Synapse Analytics, along with its components, features, security, and more.
Read more »
SQL Azure
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 »
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 »
Use AzCopy to upload data to Azure Blob Storage
February 19, 2020AzCopy is a command-line tool that is used to upload and download blobs/files from or to the Azure Blob Storage. In this article, I am going to explain how we can use it to create a new container on Azure blob storage and upload the data from the local machine to the Azure blob storage.
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 »
Getting started with Azure SQL Database
February 5, 2020In this article, we will uncover the basics of the Azure SQL Database.
Read more »
Install and configure the AdventureWorks2016 sample database
January 9, 2020This article explains the process of installing the AdventureWorks2016 and AdventureWorksDW2016 sample database on a stand-alone instance of SQL Server and Azure SQL Server. The sample databases were published by Microsoft to demonstrate how to design a database using SQL Server. Microsoft has also published another lightweight database named AdventureworksLT, which can be used as a sample database on Azure SQL Server.
Read more »
Geo Replication on Transparent Data Encryption (TDE) enabled Azure SQL databases
October 24, 2019In this article, we will review how to set up Geo-Replication on a Transparent Data Encryption (TDE) enabled Azure SQL database.
Read more »
Transparent Data Encryption (TDE) on Azure SQL database
September 13, 2019In this article, we will review on Transparent Data Encryption (TDE) on an Azure SQL database and how to enable Transparent data encryption using Asymmetric keys in Azure Key Vault.
Read more »
Implementing Dynamic Data Masking in Azure SQL database
July 30, 2019In this article, we will review Dynamic Data Masking in the Azure SQL database. Dynamic Data Masking is a feature to limit the sensitive data to the non-privileged users by hiding the data of a column. Data is not masked and stored in the disk. Masking is applied to the result set returned to the user. The users with “db_owner” permission on “UNMASK” permission can still see the unmasked data when they query the table.
Read more »
Protecting Azure SQL databases from accidental deletion
July 30, 2019In this article, we will review options called LOCKS in Azure SQL database and Azure SQL Server that are used to protect databases or servers from accidental deletes or configuration changes.
Read more »
Configuring email notifications in Azure SQL database
July 24, 2019In this article, we will review how to configure email notifications in the Azure SQL single database or elastic pool.
Read more »