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.
Search Results for: azure
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.
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.
Getting started with Azure SQL Database
February 5, 2020In this article, we will uncover the basics of the Azure SQL Database.
Access PostgreSQL databases using the Azure Data Studio extension
January 16, 2020This article installs PostgreSQL on Ubuntu 16.4 operating system and connects the database using Azure Data Studio.
Generate data scripts using SSMS and Azure Data Studio
January 13, 2020This article explores different ways to generate data scripts using Azure Data Studio and SQL Server Management Studio.
Encrypting passwords with Python Scripts in SQL Notebooks of Azure Data Studio
January 6, 2020This article explores the Python scripts for encrypting and decrypting passwords in SQL Server using Azure Data Studio SQL Notebooks.
Use Python SQL scripts in SQL Notebooks of Azure Data Studio
December 25, 2019This article explores the Python SQL scripts in SQL Notebook of Azure Data Studio.
Database Administration Tool Extension for Windows in Azure Data Studio
December 17, 2019Azure Data Studio provides a modern and productive experience for managing on-premise and cloud-based SQL Server instances. Previously, we discussed many useful features of it, and you can explore these articles in Azure Data Studio category.
SQL Server Schema Compare extension in Azure Data Studio
December 5, 2019This article explores the SQL Server Schema Compare extension in the Azure Data Studio.
Exploring the SandDance Visualizations extension in Azure Data Studio
November 6, 2019Azure Data Studio is an open-source, cross-platform and lightweight data management tool. We can use it for on-premise SQL Server, Azure SQL database and Azure SQL data warehouse. Previously we knew this tool as SQL Operations Studio.
A handy SQL Notebook for the purposes of troubleshooting in Azure Data Studio
November 5, 2019This article prepares a handy SQL Notebook for DBAs. You can use this notebook to troubleshoot performance issues and for getting SQL Server instance details.
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.
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.
Using Logistic Regression in Azure ML for Predicting Customer’s Loan Eligibility
August 19, 2019This article aims to provide the basics of creating Logistic Regression in Azure ML by designing a simple model step-by-step.
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 […]
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.
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.
Overview of the CREATE DATABASE statement in Azure SQL Server
July 23, 2019In this article, we will review CREATE DATABASE statement in the Azure SQL database with various examples.
How to configure Azure SQL Database long-term retention (LTR) backups
July 23, 2019In this article, we will review default backup settings, long-term retention (LTR) backups in Azure SQL database and how-to setup long-term retention (LTR) backup policy in Azure SQL database using Azure portal.
Azure SQL Server auto-failover groups
July 18, 2019In this article, we will review how to set up auto-failover groups in Azure SQL Server and how failover group is different from active geo-replication in Azure. Auto-failover group is an Azure SQL database feature that replicates one or a group of databases to the secondary Azure SQL server in the cross-region. We cannot have […]
Azure SQL database Geo-Replication
July 15, 2019In this article, we will review how to set up Geo-Replication on Azure SQL databases. Geo-Replication is an Azure SQL database feature that allows you to create a readable secondary database in the same region or cross-region. We can failover to the secondary database in case of an outage for a long time on the […]
Azure SQL Data Sync – Replicate data and schema changes between Azure SQL databases
July 5, 2019In this article, we will review how to configure the sync group to replicate data between Azure SQL databases using Azure SQL Data Sync.
Azure SQL – Index tables using Azure Automation
June 25, 2019This article provides an overview of indexing tables in Azure SQL database using Azure Automation and how to schedule indexing jobs to run at specific intervals.
Azure SQL – Elastic Job Agent
June 24, 2019In this article, we will review on elastic job Agent in Azure SQL and how to configure elastic jobs to run scripts on Azure SQL databases. SQL Server Agent is a powerful component that is used to schedule and execute jobs in SQL server. But in Azure, SQL server agent is available only in managed […]